HR & RECRUITING
Match Open Internal Roles to Employees' Growth Goals
When a new internal role opens in your HRIS, scores every employee against the role's required skills and stated career-growth goals.
How it runs
The automated pipeline, trigger to output.
- TriggerNew role added to Notion roles databaseNotion
- ActionPull employee roster, skills, and growth goals from BigQueryBigQuery
- ActionScore each employee on skills overlap and goal fitOpenAI
- LogicKeep candidates above fit threshold and rank them
- OutputPost ranked redeployment shortlist to hiring manager in SlackSlack
What it does
Turns every newly opened internal req into a ranked shortlist of existing employees who could grow into it. It reads the role's required skills, compares them against each employee's current skills and the development goals they logged in their growth plan, and surfaces the people for whom this role is a natural next step instead of a stretch hire from outside.
When to use it
Run this whenever you want internal mobility to be the default before opening an external search. Ideal for HR business partners and talent teams who already capture skills and growth goals in Notion but have no automated way to connect them to open headcount.
How it works
- 1A new role row is created in the Notion roles database, firing the trigger.
- 2The flow pulls the full employee roster and their skills + growth-goal records from BigQuery.
- 3An OpenAI step scores each employee on skills overlap and goal alignment, returning a fit score and a one-line rationale.
- 4A logic step keeps only candidates above the fit threshold and ranks them.
- 5The ranked shortlist with rationales is posted to the hiring manager's Slack channel for review.
Set it up
What you configure once, before turning it on.
- 1Connect NotionPages, databases, comments.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect OpenAIModels, embeddings, files.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More HR & Recruiting workflows
Route interview feedback by score the moment it is submitted
Receives each interviewer's scorecard via webhook, normalizes the rating, and routes strong-yes feedback to fast-track and any flagged concern to the recruiter.
Loom intake to recruiter handoff email
Transcribes a hiring manager's Loom intake, summarizes the role, and emails a recruiter handoff brief via Outlook with clarifying questions when details are missing.
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.
Compile interview scorecards into a hire-decision packet
When every interviewer has submitted their scorecard in Notion, automatically aggregates the scores, builds a one-page decision packet in Google Drive.
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.
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.