HR & RECRUITING
Weekly internal-mobility digest for talent partners
Every Monday, cross-references all open requisitions in BigQuery against current-employee skill profiles and emails each talent partner a digest of which open roles have strong…
How it runs
The automated pipeline, trigger to output.
- TriggerEvery Monday morning
- ActionQuery open reqs and employee skill warehouseBigQuery
- ActionMatch reqs to employees and score fitOpenAI
- LogicSplit reqs by internal-match availability
- OutputEmail digest to each talent partnerOutlook
What it does
This produces a single weekly readout that pairs every open role with its strongest internal candidates. Talent partners get one Outlook email showing, per req, the top internal matches and a clear flag on roles with zero viable internal fit — the ones safe to post externally now.
When to use it
Use this when you want a steady, low-effort cadence for internal-first hiring rather than per-req alerts. Good for talent teams managing many simultaneous reqs who need a prioritized view each week.
How it works
- 1A scheduled trigger fires every Monday morning.
- 2A BigQuery query returns all open requisitions with their required skills and the full active-employee skill warehouse.
- 3An OpenAI step matches each req to employees and assigns fit scores with rationale.
- 4A logic step splits reqs into "has internal matches" and "no internal fit — clear to post externally."
- 5A formatted digest is emailed to each talent partner via Outlook, grouped by their owned reqs.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect OutlookMail, calendar, contacts.
- 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.