Automatic invoice generation and email with Airtable and CustomJS PDF generator
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Airtable and Pdf Toolkit (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Ready Invoices (Airtable): search
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Clients (Airtable): uses Airtable
- Get Invoice Items (Airtable): search
- Set Company Details (Edit Fields (Set)): sets 9 fields: CompanyName, Address, TaxId…
- Map Fields (Edit Fields (Set)): sets 4 fields: description, quantity, unitPrice…
- Generate Invoice (Invoice Generator): uses Invoice Generator
- Aggregate: combines items into one
- Send Email: sends an email over SMTP
- Update record (Airtable): update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @custom-js/n8n-nodes-pdf-toolkit is verified or supports 3.0 (used in Generate Invoice).
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Airtable
n8n-nodes-base.airtable - Aggregate
n8n-nodes-base.aggregate - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Invoice Generator
@custom-js/n8n-nodes-pdf-toolkit.invoiceGenerator - Edit Fields (Set)
n8n-nodes-base.set - Send Email
n8n-nodes-base.emailSend
From the author
> ⚠️ Notice: > This workflow uses the CustomJS Invoice Generator node from customjs.space, which requires a self-hosted n8n instance and a CustomJS API key. --- Google Spreadsheet → Invoice Generation → Email Workflow This workflow demonstrates how to:…