How to generate invoices from Google Sheets

By Jake Marsh · Updated

To generate invoices from Google Sheets, keep one invoice per row with columns like Invoice #, Client, Email, Date, Amount and Due date, then design one invoice in Google Docs with {{Invoice #}}, {{Client}} and {{Amount}} placeholders. Open Extensions > PickMerge > Open PickMerge, pick that Doc, choose PDF files, name them Invoice {{Invoice #}} {{Client}}, and click Generate. Each row becomes a finished PDF invoice.

Before you start

  • PickMerge fills one document per row. Each row is one invoice, so put the line items you want to show in columns (Description, Qty, Rate, Amount) or as one text column.
  • Do the math in the sheet. Totals, tax and due dates are ordinary Sheets formulas; PickMerge prints the value each cell shows, formatted the way the sheet displays it (,250.00 stays ,250.00).
  • Google Sheets and Docs ship invoice templates, but each one is filled in by hand. PickMerge is for when the data already lives in rows.

Steps

  1. Set up the billing tab with one invoice per row. Add a Send? column if you only want some invoices each run.
  2. Design the invoice in Google Docs: your logo and address at the top, a table with {{Description}}, {{Qty}}, {{Rate}} and {{Amount}}, and {{Due date}} and payment terms at the bottom.
  3. Open Extensions > PickMerge > Open PickMerge and click Pick a template Doc.
  4. Choose PDF files and set the File name to Invoice {{Invoice #}} {{Client}}.
  5. Choose folder, for example an Invoices 2026 folder in Drive.
  6. Set Only rows where Send? equals Yes, so last month's invoices aren't touched.
  7. To email each invoice, tick Email each document to an address in the row, choose the Email column, and write a subject like Invoice {{Invoice #}} from Example Studio.
  8. Click Check and preview, tick the send confirmation if you're emailing, then Generate.

Keeping invoices in order

  • Numbering. Keep invoice numbers in the sheet (a formula or typed). {{_row}} prints the row number, which changes if you sort, so it isn't a safe invoice number.
  • No duplicates. Rows marked Done in PickMerge Status are skipped next time, so you can add this month's rows and run it again.
  • A record of what was sent. The PickMerge Emailed column shows which rows were emailed, and the emails sit in your Gmail Sent folder.
  • Corrections. Fix the row, then run with Regenerate rows already marked Done ticked and Row numbers set to that row.

What it costs

PickMerge's free trial covers your first 50 documents or 14 days, whichever comes first, with no card needed. Previews never count. After that it's $8.99 a month or $99 a year per Google account for unlimited documents. Install it from the PickMerge page.

PickMerge: Docs & PDFs from Sheets and Forms

Docs and PDFs from Sheets rows and Form responses, without full Drive access $8.99 a month or $99 a year per Google account.


Questions

Can an invoice have a variable number of line items?

PickMerge fills one value per placeholder, so a row can't grow into a longer table. Put up to a fixed number of item columns in the sheet (Item 1, Item 2, Item 3) and leave unused ones empty, or keep the items in one cell with line breaks.

Will my currency and date formats carry over?

Yes. Values print the way the sheet displays them, so set the number format in Sheets first.

Can I send invoices from a shared billing address?

Emails go out from the Google account that runs PickMerge. To send as billing@, run PickMerge while signed in to that account.

Can I keep an editable copy of each invoice?

Choose Google Docs and PDFs. You get a Doc you can change and the PDF you sent, both linked in the sheet.


More PickMerge guides


More Google guides