HR & RECRUITING
Quarterly Comp-Band Drift Snapshot (Snowflake to Notion)
Each quarter, measures how far every active employee's current salary sits from their band midpoint using Snowflake HR data.
How it runs
The automated pipeline, trigger to output.
- TriggerQuarterly schedule
- ActionQuery salaries and bands from SnowflakeSnowflake
- LogicCompute compa-ratio and classify drift
- LogicRank departments by total drift
- OutputPublish drift report to NotionNotion
What it does
This workflow takes a quarterly snapshot of pay-band health. It pulls current salaries and band definitions from Snowflake, calculates each employee's compa-ratio and flags who is below min, above max, or drifting toward an edge. The output is a structured Notion page ranking the worst drift by department for the comp planning team.
When to use it
Use it ahead of quarterly comp planning when you need a defensible, repeatable view of where pay has drifted relative to bands, rather than ad-hoc spreadsheet pulls. Good for comp and people-analytics teams that warehouse HR data in Snowflake.
How it works
- 1A quarterly schedule starts the snapshot.
- 2A Snowflake query joins current salaries to approved bands and computes compa-ratio per employee.
- 3A logic step classifies each employee as below-min, above-max, in-band, or near-edge and ranks departments by total drift.
- 4The results are formatted into a department-grouped report.
- 5A Notion page is created or updated with the ranked drift tables for the planning team.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect NotionPages, databases, comments.
- 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.