HR & RECRUITING
Merit-cycle raise sweep with manager justification emails
At the close of a merit cycle, it audits every proposed raise against the post-raise band and emails managers a justification request for each raise that pushes an employee out…
How it runs
The automated pipeline, trigger to output.
- TriggerMerit-cycle close schedule fires
- ActionQuery proposed raises joined to current bandsBigQuery
- LogicKeep raises that land out of band
- ActionEmail managers a justification requestGmail
- OutputLog pending requests to a Notion trackerNotion
What it does
When a merit cycle's proposed raises are finalized, this workflow recomputes each employee's new salary and checks it against their band. Raises that leave someone above the ceiling or, despite the increase, still below the floor are flagged. For each flagged raise it emails the proposing manager a structured request asking for written justification, and logs the outstanding requests to a Notion tracker so HR can see what is still pending.
When to use it
Use this once per review cycle to catch band breaches introduced by the raises themselves, and to gather manager rationale in one pass instead of chasing people individually.
How it works
- 1A schedule aligned to the merit-cycle close triggers the sweep.
- 2Query BigQuery for proposed raises joined to current bands; compute post-raise position.
- 3Filter to raises that land out of band.
- 4Email each affected manager a justification request via Gmail.
- 5Log every pending request and its status to a Notion tracker.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect GmailRead, draft, send, label.
- 3Connect NotionPages, databases, comments.
- 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.