Generate and email PDF payslips from Google Sheets with 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 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Gmail and Puppeteer (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Company Configuration (Edit Fields (Set)): sets or maps fields
- Fetch Payroll Data (Google Sheets): uses Google Sheets
- Check Email Not Sent (Filter): keeps only the items that match a condition
- Iterate Payslip Rows (Loop Over Items (Split in Batches)): loops over the items in batches
- Prepare Payslip Data (Code): runs custom JavaScript code
- Generate Payslip HTML (HTML): parses or builds HTML
- Generate Payslip PDF (Puppeteer): uses Puppeteer
- Create PDF File (Convert to File): converts data to a file
- Send Payslip Email (Gmail): uses Gmail
- Mark Email Sent in Sheet (Google Sheets): uses Google Sheets
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-puppeteer is verified or supports 3.0 (used in Generate Payslip PDF).
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - HTML
n8n-nodes-base.html - Puppeteer
n8n-nodes-puppeteer.puppeteer - Convert to File
n8n-nodes-base.convertToFile - Gmail
n8n-nodes-base.gmail
From the author
This workflow automates the entire payslip process by pulling payroll data directly from Google Sheets, generating a professional and secure PDF for each employee, and emailing it to them instantly. Save hours of manual HR administration, eliminate human…