← All Workflows

Generate invoice PDFs from Airtable records

Turn each Airtable record into an invoice or receipt PDF and save it to Google Drive or Dropbox.

See all workflows
Trigger1New/updated record in AirtableRun when a record is added or edited in a base.
Render2Olive Editorial Design Studio A4 Invoice with Cormorant Aperture Wordmark, Tall Serif INVOICE Header and Cream Alternating Table RowsExample template. Swap in your own design.
Destination3Google DriveSave renders to a Drive folder.

Every record becomes a finished invoice PDF

Invoicing from a database usually means exporting, pasting into a document, and fixing the layout every single time. This workflow skips all of it. You keep your invoices as Airtable records, design the invoice once, and Orshot renders a finished PDF for every record and files it for you.

Click a record to see it render as an invoice:

One row becomes one invoiceClick a row
AClientBItemCAmountDDue
1Northwind Co.Website redesign$4,200Aug 1, 2026
2Lumen LabsMonthly retainer$1,500Aug 5, 2026
3Harbor & KinBrand assets$2,800Aug 9, 2026
Orshot renders
Invoice
Northwind Co.
ItemWebsite redesign
Amount$4,200
DueAug 1, 2026
PDF

Rendered from row 1, one per row

What the workflow does with each record

  1. A new record lands in your Airtable base, an invoice, an order, whatever you track.
  2. The workflow reads its fields: client, line item, amount, due date.
  3. Those values fill your invoice template, so the layout is already right.
  4. Orshot renders a finished PDF and saves it to Google Drive or Dropbox.
  5. A write-back drops a link to the PDF onto the record, so your base and your files stay in sync.

Not just invoices

The same setup handles anything that is one document per record, so the invoice template is only a starting point. Point the workflow at a different design and it produces:

  • Receipts for every order record
  • Quotes and estimates a new lead can receive as a branded PDF
  • Order confirmations the moment a record is created

Keep an invoice number column in Airtable and each PDF carries its own number, the same way it carries the client name.

How it works, step by step

  1. Design an invoice template

    Build an invoice or receipt template in the studio with placeholders for the client, line items, amount, and due date.

  2. Connect your Airtable base

    Link the base that holds your invoices or orders. Each record becomes one PDF.

  3. Map fields to the template

    Match Airtable fields to the placeholders: client name, amount, invoice number, and dates.

  4. Save the PDF

    Send each finished invoice to Google Drive or Dropbox. Add a write-back so the record stores a link to its own PDF.

Frequently asked

How do I generate invoice PDFs from Airtable?

Design one invoice template, then connect your Airtable base to this workflow and map fields like client, amount, and due date to the template. Orshot renders a PDF for each record and saves it to Google Drive or Dropbox, so every invoice is created without a manual step.

Does it make an invoice when I add a record?

Yes. The workflow watches your base for new records, so a PDF is rendered the moment an invoice or order is added.

Can it write the PDF link back to Airtable?

Yes. Add a write-back so each record stores a link to its own finished invoice, which keeps your base and your files in sync.

Can each invoice have a unique number?

Yes. Keep an invoice number field in Airtable and place it on the template like any other value, so every PDF carries its own number.

Can I use it for receipts or quotes too?

Yes. The same setup works for receipts, quotes, and order confirmations. Design the matching template and point the workflow at it.