Automate payroll processing with GPT-4, Google Sheets, PDF payslips & Slack alerts
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 a schedule (every monthDay). Along the way it connects Google Sheets and Slack. It also calls api.openai.com and api.pdfmonkey.io over HTTP.
How it runs
Trigger: On a schedule (every monthDay).
- Get Employee Data (Google Sheets): uses Google Sheets
- AI Calculate Salary (HTTP Request): calls api.openai.com (POST)
- Format Payslip Data (Code): runs custom JavaScript code
- Log to Payroll Sheet (Google Sheets): append
- Generate PDF Payslip (HTTP Request): calls api.pdfmonkey.io
- Email Payslip to Employee (Send Email): sends an email over SMTP
- Notify HR on Slack (Slack): uses Slack
Services it uses
HTTP calls to: api.openai.com, api.pdfmonkey.io
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)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - Slack
n8n-nodes-base.slack
From the author
Automate your payroll process with this efficient workflow. Triggered monthly on the 28th, it fetches employee data from a Google Sheet, uses AI to calculate net salaries with tax and deductions, structures payslip data, generates PDF payslips, and notifies…