Generate and email invoice PDFs from Google Sheets with PDFMunk and Gmail
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 8 nodes and runs on Google Sheets events (row added). Along the way it connects Gmail and Google Sheets. It also calls pdfmunk.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- Set Client and Item Details (Edit Fields (Set)): sets 7 fields: client_name, client_email, item_description…
- Prepare Invoice Number (Edit Fields (Set)): sets 1 field: invoice_number
- Append to Invoice Orders Sheet (Google Sheets): append
- Process Invoice Data (Code): runs custom JavaScript code
- Generate PDF Invoice (HTTP Request): calls pdfmunk.com (POST)
- Download PDF from URL (HTTP Request): calls an HTTP API
- Email Invoice via Gmail (Gmail): uses Gmail
Services it uses
HTTP calls to: pdfmunk.com
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)
- Gmail
n8n-nodes-base.gmail - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger
From the author
Quick overview This workflow watches a Google Sheets order sheet for new invoice rows, generates a unique invoice number, appends the normalized record to another sheet, converts an HTML invoice into a PDF via PDFMunk, and emails the PDF to the client using…