HR & RECRUITING
Quarterly comp band drift snapshot to Snowflake with Gmail report
Each quarter, computes org-wide band drift, writes a point-in-time snapshot to Snowflake for trend tracking, and emails HR leadership a summary report of the drift distribution.
How it runs
The automated pipeline, trigger to output.
- TriggerQuarterly schedule kicks off the snapshot
- ActionCompute org-wide compa-ratio and out-of-band flagsBigQuery
- ActionWrite dated drift snapshot to Snowflake historySnowflake
- LogicBuild quarter-over-quarter aggregates by department
- OutputEmail HR leadership the drift distribution reportGmail
What it does
This workflow treats drift as a metric to track over time rather than a per-employee task. It computes the full distribution of how employees sit against refreshed band midpoints, persists a dated snapshot to Snowflake, and emails HR leadership a quarterly report comparing drift to prior periods.
When to use it
Use it when leadership wants to monitor whether comp bands are keeping pace with actual pay across quarters — share of employees below band, average compa-ratio, drift by department — rather than acting on individual cases. Pairs with the per-manager workflows for case-level action.
How it works
- 1A quarterly schedule kicks off the snapshot.
- 2A BigQuery query computes compa-ratio and out-of-band flags for the whole roster.
- 3The results are written as a dated snapshot row set into a Snowflake history table.
- 4A query against Snowflake builds quarter-over-quarter aggregates by department.
- 5A Gmail report summarizing the distribution and trend is sent to HR leadership.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SnowflakeWarehouses, queries, shares.
- 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.