HR & RECRUITING
Offer Comp-Band Drift Gate (BigQuery + Slack Approval)
Checks every new offer against the approved compensation band for its level and location in BigQuery.
How it runs
The automated pipeline, trigger to output.
- TriggerOffer submitted (webhook)HTTP webhook
- ActionLook up approved band for level + locationBigQuery
- LogicCompare proposed base to band, compute gap
- LogicIn-band: record and stop
- OutputOut-of-band: post Slack approval threadSlack
What it does
Whenever a recruiter submits an offer, this workflow looks up the approved compensation band for that job level and location, compares the proposed base salary, and decides whether the offer is in-band or needs sign-off. Compliant offers are logged silently; out-of-band offers are pushed to a Slack channel with the exact gap and an approve/reject action.
When to use it
Use it when your comp bands live in BigQuery and you want a hard gate so no offer above (or below) range goes out without a comp partner or manager explicitly approving it. Ideal for talent teams scaling hiring who can't manually eyeball every offer.
How it works
- 1An offer-submitted webhook fires with candidate, level, location, and proposed base.
- 2A BigQuery query pulls the approved min/mid/max band for that level + location.
- 3A logic step compares the proposed base to the band and computes the percent over or under.
- 4If in-band, the run records the offer and stops.
- 5If out-of-band, a Slack message posts to the comp-review channel with the gap, band, and an approval action for a comp partner to resolve.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.