Generate PDF invoices with line item support from Airtable using Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Airtable and Google Drive.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Split Services (Split Out): splits a list into separate items
- Add Service to DB (Airtable): create
- Formatting Data (Code): runs custom JavaScript code
- Get Previous Invoices (Airtable): search
- Generate Invoice # (Code): runs custom JavaScript code
- Copy Invoice Template (Google Drive): copy
- Add Services to Invoice (HTTP Request): calls an HTTP API (POST)
- Get Client Info (Airtable): uses Airtable
- Add Client Info (HTTP Request): calls an HTTP API (POST)
- Create a record1 (template) (Airtable): create
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Webhook
n8n-nodes-base.webhook - Airtable
n8n-nodes-base.airtable - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest
From the author
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…