HR & RECRUITING
Quarterly band-health drift report to leadership
Each quarter it aggregates band-drift across the whole company from BigQuery, computes how many employees and which departments are out of band and by how much.
How it runs
The automated pipeline, trigger to output.
- TriggerQuarterly schedule fires the report
- ActionAggregate band position by department and levelBigQuery
- LogicRank teams by drift rate and dollar exposure
- ActionRender the leadership-ready report
- OutputEmail the report to HR leadershipGmail
What it does
This workflow produces a quarterly view of how well compensation tracks its bands across the organization. It aggregates every active employee's band position from BigQuery, then rolls the data up by department and level: counts of below-floor and above-ceiling employees, total dollar exposure, and the departments drifting fastest versus the prior quarter. It assembles this into a ranked report and emails it to HR leadership so they can prioritize where to spend correction budget.
When to use it
Use this for board and leadership reviews when you need a trend-level read on comp-band integrity rather than individual flags, and want to see which teams are drifting before it becomes a retention or equity problem.
How it works
- 1A quarterly schedule triggers the report.
- 2Query BigQuery to aggregate band position by department and level.
- 3Rank departments by out-of-band rate and dollar exposure, comparing to last quarter.
- 4Render the ranked summary into a leadership-ready report.
- 5Email the report to the HR leadership distribution list via Gmail.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect GmailRead, draft, send, label.
- 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
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.