Generate and email monthly payslips from a Google Sheet

Pulls payroll data from a spreadsheet, builds a PDF payslip for each employee, and emails it out.

How the work actually flows

It repeats. Exactly one path is taken; repeats move to next employee.

Pattern: Structured Loop (21) · Exclusive Choice (4)

flowchart TD trig(("payroll run started")):::human s0["check if already paid"]:::task s1["generate pdf payslip"]:::task s2["email payslip to employee"]:::svc trig --> s0 s1 --> s2 gx{"× already sent this payslip"}:::gate s0 --> gx p00["skip employee"]:::task gx -->|"already paid"| p00 p10["generate and send payslip"]:::task gx -->|"not yet paid"| p10 p00 --> s1 p10 --> s1 lp{"employee list exhausted"}:::gate s2 --> lp lp -. "move to next employee" .-> s0 lp -->|"finished"| out out[/"payslip emailed to every employee"/]:::out pay{{"accurate payroll without manual work"}}:::pay out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
A stepAn outside serviceA personOne path onlyRepeat or finishResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Email AutomationDocument Processing & OCRImage & Media ProcessingSpreadsheet & Database OpsWeb Scraping & Data Collection
Connects
Google SheetsGmail

The problem it solves

Putting together payslips every month means copying numbers into individual documents and emailing each one by hand. It's slow, and a single typo can mean an employee gets the wrong numbers.

Who it fits

Small business owners and HR teams handling payroll without dedicated payroll software.

How it works

  1. You run the automation when payroll is ready
  2. It pulls each employee's payroll data from Google Sheets
  3. It skips anyone who's already been sent theirs and processes the rest one at a time
  4. A PDF payslip is generated and emailed directly to each employee
Quick estimate

What it is worth to you

Your numbers, your hourly cost. We add nothing hidden.

count
minutes
$ per hour
0Hours freed per month
0Value per year at your hourly cost

Assumes payroll figures are already finalized in the sheet each month.

What you get

A PDF payslip emailed to every employee, with the sheet updated to show who's been paid.

What you need

A Google Workspace account and a Gmail account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Read invoices from Gmail and log them to Google Sheets automatically

Pulls invoice attachments out of your inbox, reads the details with AI, and records them in a spreadsheet.

Advanced

Send a PDF invoice and log every Stripe payment automatically

Every time a customer pays through Stripe, this creates a PDF invoice, emails it to them, and logs the payment in Google Sheets.

Standard

Manage contacts, email, and content creation from one Telegram chat

A Telegram AI assistant looks up contacts, sends emails, reads PDFs, and turns web links into ready-to-post content.

Advanced

Scrape product data and send it as CSV, Sheets, and Excel

Pulls product listings from a website, sorts them by price, and delivers the results as a CSV, sheet, and spreadsheet.

Advanced
Back to the AI Playbook