HR & RECRUITING
Weekly Compensation Band Drift Audit
On a weekly schedule, this scans the entire workforce against current comp bands, surfaces everyone who has drifted below band minimum or above maximum.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires the audit
- ActionPull all active employees + base pay from HRIS PostgresPostgres
- ActionJoin each employee to their band from AirtableAirtable
- LogicCompute band position, isolate + rank out-of-band cases
- ActionWrite dated audit report to Google Sheet in DriveGoogle Drive
- OutputPost top exposures + remediation budget to SlackSlack
What it does
Runs a standing audit of the whole employee population against the live band table. Bands move as the market shifts; this catches the employees who have quietly fallen out of band — usually below minimum after a band raise — and quantifies the cost to fix each one.
When to use it
Use this for ongoing comp hygiene rather than per-offer checks. It's ideal ahead of merit cycles or budget planning, when you need a defensible list of who is out of band and what it would cost to correct.
How it works
- 1A weekly schedule triggers the audit.
- 2The flow pulls all active employees and their current base pay from the HRIS Postgres database.
- 3It joins each employee to their applicable band by level and location from Airtable.
- 4A logic step computes band position for everyone and isolates below-min and above-max cases, ranking by gap size and remediation cost.
- 5The findings are written to a dated Google Sheet in Drive for the record.
- 6A summary with the top exposures and total remediation budget is posted to the People team channel in Slack.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect Google DriveDocs, sheets, slides, files.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More HR & Recruiting workflows
Route interview feedback by score the moment it is submitted
Receives each interviewer's scorecard via webhook, normalizes the rating, and routes strong-yes feedback to fast-track and any flagged concern to the recruiter.
Loom intake to recruiter handoff email
Transcribes a hiring manager's Loom intake, summarizes the role, and emails a recruiter handoff brief via Outlook with clarifying questions when details are missing.
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.
Compile interview scorecards into a hire-decision packet
When every interviewer has submitted their scorecard in Notion, automatically aggregates the scores, builds a one-page decision packet in Google Drive.
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.
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.