HR & RECRUITING
Merit-Cycle Raise Audit (Airtable to Outlook Digest)
Scans all proposed raises in an Airtable merit-cycle table on a schedule, flags any new salary that lands outside the employee's band.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule during comp cycle
- ActionFetch proposed raises from AirtableAirtable
- LogicFlag salaries outside employee band
- LogicGroup exceptions by manager
- OutputEmail exception digest via OutlookOutlook
What it does
During a merit or promotion cycle, this workflow reviews every proposed raise recorded in Airtable, checks the post-raise salary against the employee's approved band, and assembles a digest of all out-of-band proposals. The digest is emailed via Outlook to the relevant managers so they can correct entries before payroll locks.
When to use it
Run it nightly during an active comp cycle when raise proposals are being entered in Airtable and you need a daily safety net catching salaries pushed above max or left below min before approvals are finalized.
How it works
- 1A daily schedule triggers the audit during the cycle window.
- 2Airtable returns all proposed-raise rows with employee, level, current and proposed salary.
- 3A logic step joins each row to its band and flags rows where the proposed salary breaches min or max.
- 4If there are no exceptions, the run ends quietly.
- 5If exceptions exist, they are grouped by manager and an Outlook email digest is sent to each manager listing the employees, the breach amount, and the band.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Connect OutlookMail, calendar, contacts.
- 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.