HR & RECRUITING
Daily scan of recent offers and raises for comp-band drift, emailed as a digest
Every morning this workflow pulls the last 24 hours of approved offers and raises from BigQuery, flags any that landed outside the band for their level and geo.
How it runs
The automated pipeline, trigger to output.
- TriggerEvery weekday morning
- ActionQuery last 24h of offers + raisesBigQuery
- LogicFlag and rank out-of-band actions
- LogicAll-clear vs. exception digest branch
- OutputEmail exception digest via OutlookOutlook
What it does
This is the nightly auditor that catches what slipped through. Each morning it queries BigQuery for every offer and raise approved in the last day, joins each one to the approved band for its level and geography, and computes how far it sits inside or outside the range. It then assembles a single digest: total compensation actions reviewed, count outside band, and a ranked list of the worst breaches with name, manager, level, geo, the band range, and the percentage over or under. That digest is emailed to the comp team and HR leadership through Outlook, so the first thing they see is a clean exception report instead of a spreadsheet to comb through.
When to use it
Use it when offers and raises are already being approved across multiple systems and you need a reliable backstop that surfaces band breaches the next morning. It suits comp teams that want a standing daily record of drift without anyone running manual queries.
How it works
- 1A schedule trigger fires each weekday morning.
- 2The workflow queries BigQuery for offers and raises approved in the last 24 hours, joined to the approved band by level and geo.
- 3A logic step flags each action as in-band or out-of-band and ranks breaches by magnitude.
- 4If there are no breaches it sends a short all-clear; otherwise it builds the exception digest.
- 5The digest is emailed to the comp team and HR leaders via Outlook.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OutlookMail, calendar, contacts.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More HR & Recruiting workflows
Day-one readiness orchestrator across all onboarding owners
An agent-driven coordinator that, when a hire is launched, plans the full provisioning program across IT, Facilities, and Finance, opens the work in your tracker.
Escalate Compliance-Blocking Credential Lapses to Managers
Each day it finds credentials that have already expired or expire within 48 hours and are flagged compliance-blocking.
Assemble and send the debrief packet after the final interview
Triggered when a candidate's final interview ends on the calendar, it waits a short window for scorecards, compiles the aggregated packet to Google Drive.
Credential Renewal Evidence Verification Agent
When an employee replies with a renewed credential document, an agent reads the attachment, extracts the new expiry date and credential number.
New-Hire Credential Intake to Renewal Calendar Holds
When a new credential is added to the tracker, it validates the record, files the document.
New-hire equipment order email to IT and vendor
On a scheduled lead-time before each start date, drafts and sends an equipment order email (laptop, monitor.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.