Generate PDF invoices with line item support from Airtable using Google Sheets — n8n Workflow
Overview
Stop manually copy-pasting client data into Word templates. This workflow automates the entire invoicing process, handling complex line items, VAT calculations, PDF generation, and CRM syncing in under 20 seconds.
It is designed to solve the "Admin Trap" by connecting your database (Airtable) to your document generator (Google Drive/Docs) via a Webhook trigger.
⚡ What this workflow does Receives Data: Listens for a Webhook (compatible with frontends like Lovable, Softr, or standard forms) cont
Nodes used
Workflow Preview
How it Works
- 1
Trigger
The workflow starts with a webhook trigger.
- 2
Process
Data flows through 15 nodes, connecting airtable, code, googledrive.
- 3
Output
The workflow completes its automation and delivers the result to the configured destination.
Node Details (15)
Airtable
airtable
HTTP Request
httpRequest
Google Drive
googleDrive
Code
code
How to Import This Workflow
- 1Click Download JSON button on the right to save the workflow file.
- 2Open your n8n instance. Go to Workflows → New → Import from file.
- 3Select the downloaded
generate-pdf-invoices-with-line-item-support-from-airtable-using-google-sheetsfile and click Import. - 4Set up credentials for each service node (API keys, OAuth, etc.).
- 5Click Test Workflow to verify everything works, then activate it.
Or paste directly in n8n → Import from JSON:
Integrations
Created by
Sergio Medina
@sergio-medina
Tags
New to n8n?
n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.
Get n8n Free →