A Google Apps Script that turns rows of your Google Sheet into invoice PDFs on your template with one button

Example result

python merge_sales.py --month 2026-10

2026-11-02 09:14:03 INFO  Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO  shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO  shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN  shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO  Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
    """Reads one shop's file and gives it the report's column names."""
    table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
    renamed = {}
    for name, variants in columns.items():
        found = next((c for c in table.columns if c.strip() in variants), None)
        if found is None:
            raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
        renamed[found] = name
    table = table.rename(columns=renamed)[list(columns)]
    table["shop"] = path.stem
    return table

About this service

If you keep orders or work hours in a Google Sheet, making each invoice by hand means copying the client, items and totals into a document and saving a PDF. This Google Apps Script adds a button to your sheet: it fills your own invoice template in Google Docs or Sheets with the row's data, saves a PDF named the way you want into a Drive folder and puts the link back into the row. From Standard it handles several item lines and numbering; Premium can email each PDF from your Gmail to your client. Totals, taxes and wording come from your sheet and template: the script does the sums you describe and gives no tax or accounting advice, so check the first invoices. You install and run it in your Google account.

What is included

• What you getA ZIP archive with the Apps Script code and a README that shows how to add it to your sheet and template; the code is also shown on the order page.
• Your own templateYour layout, logo and wording in Google Docs or Sheets
• PDF to DriveNamed by number, client and date, in the folder you set
• Link in the rowYou see which rows already have an invoice
• NumberingFrom Standard, the next number taken from your sheet
• Readable codeWith comments, easy to change a field later

How it works

1. 1
   TemplateYou send the sheet's columns and your invoice template
2. 2
   CodeWe write the script and the guide to installing it
3. 3
   Try itYou make test invoices in a copy of the sheet and check the sums
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

The column names of your sheet with two or three rows of made-up data, your invoice template (a Google Doc or Sheet, or a PDF of an invoice you send now) with the places each value goes, and how totals are counted: tax rate, discounts, currency and rounding, as your accountant tells you. How invoices are numbered and named, the Drive folder for the PDFs, and, for Premium, the email text to the client.

We will ask you:

• What do you invoice for?
• What are the sheet's columns?
• What does your invoice look like?
• How are totals counted?

Compare packages

Questions and answers

Did not find your answer? Ask us