HR & Recruitment

Monthly Payslip Generator (WhatsApp & Email)

Generates a PDF payslip for every employee each month, saves it to Google Drive, sends it on WhatsApp and email, and marks payroll as sent in Google Sheets.

The Monthly Payslip Generator (WhatsApp & Email) workflow on the n8n canvas, with its 20 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
HR & Recruitment
Nodes
20
Apps
Google Sheets, Google Drive
Price
Free
Download JSON
On this page

How it works

  1. A monthly trigger fetches pending payroll rows.
  2. Each employee's data is normalised into a payslip template.
  3. The HTML is converted to PDF and stored in a Drive folder.
  4. A shareable link is sent on WhatsApp and the PDF by email.
  5. The payroll status is updated in the sheet.

Use cases

  • SMEs running payroll in spreadsheets
  • HR outsourcing firms
  • Contract staff payouts

What you need

This workflow connects to these apps.

  • n8n
  • Google Sheets
  • Google Drive

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Gmail account
  • Google Drive account
  • Google Sheets account
  • Twilio account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Automated Payroll Slip Sender → EmployeesGoogle SheetsstatusmonthReceipt PDF

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
Check If Receipt Folder Existsif
Upload Receipt PDF (Existing Folder)googleDrive
Upload Receipt PDF (New Folder)googleDrive
Generate Public Receipt Linkset
Find “Staff Salary Receipts” Folder in DrivegoogleDrive
Create “Staff Salary Receipts” FoldergoogleDrive
Monthly Payroll TriggerscheduleTrigger
Fetch Pending PayrollgoogleSheets
Process Employees One by OnesplitInBatches
Normalize Payroll Fieldsset
Build Payslip HTMLcode
Create HTML Binarycode
Convert Payslip HTML → PDFhttpRequest
Extract PDF Binary Onlycode
Get & Rename PDF Binary to datacode
Make PDF Public (Read-Only)googleDrive
Send Payslip via WhatsApptwilio
Send Payslip via Emailgmail
Store Receipt Link & Mark Payroll as SentgoogleSheets

Frequently asked questions

Generates a PDF payslip for every employee each month, saves it to Google Drive, sends it on WhatsApp and email, and marks payroll as sent in Google Sheets. It's a 20-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Gmail, Google Drive, Google Sheets, and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the Candidate Employment Verification workflow

    HR & Recruitment5 nodes

    Candidate Employment Verification

    Emails previous employers to verify a candidate's work history and tracks the status of each request in Google Sheets.

  • n8n canvas of the Interview Scheduling: Airtable to Google Calendar workflow

    HR & Recruitment5 nodes

    Interview Scheduling: Airtable to Google Calendar

    When a candidate's status changes to interview scheduled in Airtable, a Google Calendar event is created and the candidate receives an invitation email with all the details.

  • n8n canvas of the Offer Letter Generation & Onboarding workflow

    HR & Recruitment14 nodes

    Offer Letter Generation & Onboarding

    Generates a PDF offer letter when a candidate is ready, emails it, uploads a copy, notifies the manager on Slack and tracks onboarding status. Candidates with missing documents get a reminder.