Auto-generate and auto-fill business documents with Google Sheets & Gmail
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 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Drive, Gmail and Craftmypdf (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get employees (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Create agreement (Craft My Pdf): work with pdf
- Success? (If): checks a condition and branches into true / false
- Get agreement (HTTP Request): calls an HTTP API
- Upload agreement (Google Drive): uses Google Drive
- Send email with PDF (Gmail): uses Gmail
- Merge: merges the data from its input branches
- Update row (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-craftmypdf is verified or supports 3.0 (used in Create agreement).
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Craft My Pdf
n8n-nodes-craftmypdf.craftMyPdf - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Gmail
n8n-nodes-base.gmail
From the author
This workflow automates the generation and delivery of personalized business documents (e.g., contracts, job offers, invoices, pay slips) in PDF format. The data source is a Google Sheet, and the documents are created using CraftMyPDF, then uploaded to Google…