← All Workflows

Generate an invoice PDF for every order

Turn a spreadsheet of orders into clean invoice PDFs, one per row, filed automatically.

See all workflows
Trigger1On a scheduleRun automatically at a set frequency.
Source2Google SheetsRead rows from a spreadsheet.
Render3Olive Editorial Design Studio A4 Invoice with Cormorant Aperture Wordmark, Tall Serif INVOICE Header and Cream Alternating Table RowsExample template. Swap in your own design.
Destination4Google DriveSave renders to a Drive folder.

Invoices straight from your sheet

Plenty of freelancers, agencies, and small teams run billing from a spreadsheet. The orders are there, the amounts are there, and then the month ends and someone spends an evening copying it all into an invoice template one client at a time. This workflow does that evening's work automatically: every row in your sheet becomes a branded invoice PDF in Google Drive.

Who bills this way

Freelancers and consultants
Projects tracked in a sheet, with the invoice existing the moment the 'invoiced?' column is filled.
Agencies
Many small clients billed monthly, where the format never changes and only the names and numbers do.
Marketplaces and course sellers
Orders exported as CSV, pasted into Sheets, and returned as customer-facing receipts that don't look like an export.
Ops teams
Internal chargeback and billing summaries per department, produced on a fixed schedule.

From row to invoice

The workflow reads each row, fills your invoice template, and renders a PDF named and filed in Drive:

One row becomes one invoiceClick a row
AInvoice #BClientCDescriptionDAmountEDue
12026-041Northwind CoRetainer, June$2,400July 15
22026-042Acme LabsLanding page build$3,150July 20
32026-043Corner CafeMenu design$800July 22
Orshot renders
Invoice
Northwind Co
Invoice #2026-041
DescriptionRetainer, June
Amount$2,400
DueJuly 15
PDF

Rendered from row 1, one per row

Totals, tax lines, and payment instructions live in the template design, so they're always formatted correctly and never mistyped. Because the template is a real design and not a mail merge, long client names and descriptions fit cleanly, and the result looks like it came from proper billing software.

Runs on your billing cycle

Set the schedule to daily or weekly, and the workflow picks up new rows since the last run. Nothing renders when there's nothing new, and idle checks are free. Invoicing becomes a side effect of the bookkeeping you were already doing.

Frequently asked