HR & RECRUITING
Weekly Contractor Spend Variance Review Agent
Every Monday, an agent reconciles last week's logged contractor hours in BigQuery against planned budgets, investigates each variance.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday-morning schedule
- ActionQuery last week's actuals + plan from BigQueryBigQuery
- LogicIsolate engagements outside tolerance band
- LogicAttribute likely cause per variance
- OutputPublish variance review to dated Notion pageNotion
What it does
An agent pulls the prior week's contractor hours and budgets, identifies every engagement where actual spend diverged materially from plan, and reasons about the likely cause of each variance (scope creep, ramp, idle time). It writes a narrative review with a recommended action per engagement to Notion, going beyond a raw numeric report.
When to use it
Use it for a recurring Monday operations review when you want explained variances and concrete next steps, not just a dashboard, and a durable record finance can read.
How it works
- 1A Monday-morning schedule starts the run.
- 2The agent queries BigQuery for last week's actual hours and the corresponding planned budgets per engagement.
- 3It computes variance and isolates engagements outside the tolerance band.
- 4For each, the agent reasons over recent timesheet notes and history to attribute a likely cause.
- 5It drafts a per-engagement variance narrative with a recommended action.
- 6It publishes the full review to a dated Notion page and links it for the operations channel.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 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
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.
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.
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.
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.
New-Hire Credential Intake to Renewal Calendar Holds
When a new credential is added to the tracker, it validates the record, files the document.
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.
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.