Post the latest Gusto payroll summary to Slack every Friday
Every Friday, roll up the latest Gusto payroll into a plain-English Slack post so founders and finance see totals, taxes, and headcount at a glance.
Every Friday at 4pm, look at the most recent processed Gusto payroll and post a plain-English summary to a Slack channel for the leadership team. Trigger this on a cron schedule; Gusto is not a poll provider, so scheduled runs are the right entry point.
Use gusto.List Payrolls with processed=true and a check_date filter (bounded to the last few weeks) to pull the two most recent processed runs — the latest one and the one immediately before it, so week-over-week deltas are against a real prior period. If nothing new has been processed since the last digest, send a short note that says so instead of re-reporting the same numbers.
For each of those two runs, call gusto.Get Payroll to fetch full totals plus per-employee compensations. Important: Gusto returns money and hours as decimal strings, not numbers, so parse them with a decimal-safe helper — never parseFloat, which loses precision on cents.
Compute and include in the digest: gross pay, net pay, employer taxes, headcount, whether the run was off-cycle, and week-over-week deltas versus the prior period. Keep the tone concise and readable, and highlight anything notable in punchy callouts — for example, "Engineering headcount +2, gross pay +$14k" or "Off-cycle bonus run, $23k gross". Flag notable jumps so leaders can react without opening Gusto.
Post the digest with slackbot.Send a Message to the leadership channel the user chooses at setup. Slack's native Gusto integration only pushes onboarding events, not payroll summaries — that is exactly the gap this workflow fills, so founders and finance see the numbers without logging in to Gusto.
What does this prompt do?
- Pulls the most recent processed Gusto payroll every Friday afternoon
- Summarizes gross pay, net pay, employer taxes, and headcount in plain English
- Flags notable movements versus last period, like "Engineering headcount +2, gross pay +$14k", plus any off-cycle runs
- Posts the digest to the Slack channel of your choice so leaders never have to log in to Gusto
What do I need to use this?
- A Gusto account with permission to view payroll history
- A Slack workspace and the channel where leadership should see the weekly update
How can I customize it?
- Change the send time (default Friday at 4pm) to any weekday and hour that fits your close cadence
- Swap the destination channel, or send to more than one so finance and founders each get a copy
- Tune which callouts feel newsworthy: headcount jumps, dollar deltas over a threshold, off-cycle bonus runs, department-level shifts
FAQs
What if we did not process a new payroll this week?
How does the week-over-week comparison work?
Will off-cycle bonus and correction runs show up?
Can we include per-employee pay details in the message?
Does this need a special Gusto plan?
Related templates
When someone leaves, we check which shared passwords they used in their final months and post a ranked rotation list to your security channel.
Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.
Twice every weekday, the conversations from your social inbox land on the right HubSpot contact timelines, with a Slack recap for sales.
Every morning, find the addresses that hard bounced or filed a spam complaint, update the matching HubSpot contacts, and post a short Slack recap.
Every weekday at 4pm, spot the threads that went quiet, stage a ready-to-send nudge in your mailbox, and get a ranked Slack recap.
When you merge a fix in GitHub, this agent checks the matching dead-letter queue, replays the failed messages, and reports back on the pull request and in Slack.
Stop chasing payroll numbers in Gusto.
Get the weekly highlights in Slack every Friday so founders and finance are always in the loop.