Generate and email PDF invoices from Google Sheets with Acrewity and 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 on Google Sheets events (row added). Along the way it connects Google Sheets, Gmail, Google Drive and Acrewity (community).
How it runs
Trigger: On Google Sheets events (row added).
- Set Workflow Configuration (Edit Fields (Set)): sets 5 fields: companyName, companyLogoUrl, taxRate…
- Create Invoice HTML (Code): runs custom JavaScript code
- Validate Order (If): checks a condition and branches into true / false
- Convert HTML to PDF (Acrewity): work with html to pdf
- Update Order as Failed (Google Sheets): update
- Transform PDF to File (Convert to File): converts data to a file (to binary)
- Send Invoice via Email (Gmail): uses Gmail
- Save Invoice to Drive (Google Drive): uses Google Drive
- Update Order as Invoiced (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 @acrewity/n8n-nodes-acrewity is verified or supports 3.0 (used in Convert HTML to PDF).
Nodes used (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Acrewity
@acrewity/n8n-nodes-acrewity.acrewity - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
Quick overview This workflow watches for new order rows in Google Sheets, generates a styled HTML invoice, converts it to a PDF using Acrewity, emails the PDF via Gmail, archives it in Google Drive, and updates the order row status so successful and failed…