HR & RECRUITING
Comp-band drift audit from BigQuery to Monday manager review
Nightly compares each employee's pay against refreshed band midpoints in BigQuery, flags anyone outside the band, and opens a Monday review item assigned to their manager.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires the audit
- ActionQuery pay vs refreshed band midpoints in BigQueryBigQuery
- LogicKeep employees whose pay is outside band min/max
- ActionCreate Monday review item assigned to managermonday.com
- OutputPost run summary of items opened by departmentmonday.com
What it does
This workflow runs the core compensation-band drift audit. It pulls current pay and the latest refreshed band midpoints from BigQuery, calculates each employee's position relative to their band, and queues a manager review on Monday for anyone who has drifted below the minimum or above the maximum.
When to use it
Run this after a comp-band refresh (annual or mid-year market adjustment) when you need to systematically catch employees whose salary no longer fits their re-baselined band. Ideal for People Ops teams who manage review cycles in Monday and warehouse HR data in BigQuery.
How it works
- 1A nightly schedule fires the audit.
- 2A BigQuery query joins the employee roster to the refreshed band table and computes each person's compa-ratio against the new midpoint.
- 3A filter keeps only employees whose pay falls outside their band's min/max range.
- 4For each flagged employee, a Monday item is created on the review board with the gap amount, suggested midpoint, and manager as owner.
- 5The output posts a run summary listing how many items were opened by department.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect monday.comVisual work management for teams.
- 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.