Generating documents from Google Sheets with Python

quote.py

import pandas as pd
from docxtpl import DocxTemplate

SHEET_URL='https://docs.google.com/spreadsheets/d/1Kvb5bmm2qZWEH4I5hJYZMEuIBU-CCw_ivyv_jjB1w4w/export?exportFormat=csv'
TEMPLATE = 'quote.docx'

def save_quote(quote_id):
    df = pd.read_csv(SHEET_URL, index_col='QuoteID')
    context = dict(df.loc[quote_id])
    doc = DocxTemplate(TEMPLATE)
    doc.render(context)
    doc.save(f'quote_{quote_id}.docx')

if __name__ == '__main__':
    import sys
    save_quote(int(sys.argv[1]))

requirements.txt

pandas
docxtpl