Generate invoice PDFs from Google Sheets with DocuPotion and Drive
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 8 nodes and runs on Google Sheets events (row update). Along the way it connects Google Sheets, Google Drive and Docupotion (community).
How it runs
Trigger: On Google Sheets events (row update).
- Filter: keeps only the items that match a condition
- Loop Over Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Invoice Items (Google Sheets): uses Google Sheets
- Create JSON Object From Items (Aggregate): combines items into one
- Generate PDF (Docupotion): uses Docupotion
- Upload to Google Drive (Google Drive): uses Google Drive
- Add Link to Google Sheet (Google Sheets): 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 n8n-nodes-docupotion is verified or supports 3.0 (used in Generate PDF).
Nodes used (7)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Docupotion
n8n-nodes-docupotion.docupotion - Google Drive
n8n-nodes-base.googleDrive
From the author
Automatically generate an Invoice PDF from Google Sheets data with DocuPotion How it works This workflow automatically generates a branded PDF invoice from data in Google Sheets and saves it to Google Drive. No manual document editing required. It's triggered…