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.

Agentic Task
GustoSlack BotFinanceHR & PeopleAI ReportsDaily Digests
PromptCreate

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.

Additional information

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

Frequently asked questions

What if we did not process a new payroll this week?
The digest handles that gracefully. If nothing new has run since the last Friday post, the message just notes that instead of re-reporting the same numbers.
How does the week-over-week comparison work?
It pulls the two most recent processed payrolls and compares them, so the deltas are always against your prior real run rather than an arbitrary calendar window.
Will off-cycle bonus and correction runs show up?
Yes. Off-cycle payrolls are called out separately in the summary so they do not get buried inside the regular numbers.
Can we include per-employee pay details in the message?
By default it stays at the company and team level, but you can extend the prompt to include individual lines. If you do, we recommend posting to a private leadership channel.
Does this need a special Gusto plan?
No. It uses standard Gusto payroll data that any admin with payroll access can already read, so it works on the plans small teams typically start on.

Stop chasing payroll numbers in Gusto.

Get the weekly highlights in Slack every Friday so founders and finance are always in the loop.