HR & RECRUITING
Band-refresh webhook triggers per-manager Gmail drift digest
When a new compensation band sheet is published, this workflow re-audits all reports and emails each manager a single digest of which of their team members now fall outside band.
How it runs
The automated pipeline, trigger to output.
- TriggerWebhook fires when refreshed band sheet is publishedHTTP webhook
- ActionRecompute pay vs new midpoints in BigQueryBigQuery
- LogicFilter out-of-band employees and group by manager
- ActionCompose per-manager drift digestGmail
- OutputSend one Gmail digest to each affected managerGmail
What it does
This workflow reacts the moment a refreshed band table is published. It re-runs the drift check across the whole org, groups every flagged employee by their manager, and sends each manager one consolidated Gmail digest instead of scattered alerts.
When to use it
Use it when comp bands are refreshed on an irregular cadence and you want managers notified immediately, in a single readable email per manager, rather than logging into a tool. Best when reviews are conversational and the goal is fast manager awareness.
How it works
- 1A webhook fires when the new band sheet is published (e.g. from your comp-planning tool).
- 2A BigQuery query recomputes each employee's position against the just-refreshed midpoints.
- 3A grouping step keeps only out-of-band employees and buckets them by manager email.
- 4For each manager with at least one flagged report, a Gmail message is composed listing names, current pay, new midpoint, and the dollar gap.
- 5The digest emails are sent, one per manager.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect GmailRead, draft, send, label.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More HR & Recruiting workflows
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.
New-Hire Credential Intake to Renewal Calendar Holds
When a new credential is added to the tracker, it validates the record, files the document.
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.
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.
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.
Loom intake to req-tracker row in Airtable
Transcribes a hiring manager's Loom intake, scores the brief for completeness, and either logs a ready req in Airtable or routes incomplete intakes to a follow-up Slack ping.
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.