HR & RECRUITING

Weekly digest of internal candidates for each open role

Every week, ranks internal employees against all open reqs and posts each hiring manager a Notion page listing their best-fit internal candidates with match reasons.

CategoryHR & Recruiting
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule
  • ActionPull open reqs and employee skills inventoryGoogle BigQueryBigQuery
  • LogicScore and rank top internal candidates per req
  • ActionRender a per-manager candidate page in NotionNotionNotion
  • OutputNotify each manager in Slack with their shortlist linkSlack

What it does

Once a week this workflow pairs every open requisition with the internal employees who best fit it, then hands each hiring manager a clean Notion page: their role, the top internal candidates, and why each one matched. Managers get a standing shortlist without ever opening the warehouse.

When to use it

Use it when reqs stay open long enough that a weekly cadence makes sense and you want managers to seriously consider internal talent before requesting external headcount. Good for monthly or quarterly mobility programs that need a recurring touchpoint.

How it works

  1. 1A weekly schedule triggers the run.
  2. 2The workflow pulls all open reqs and the full employee skills inventory from BigQuery.
  3. 3A matching step scores each employee against each role and keeps the top candidates per req, attaching the specific skills and adjacent experience that drove the score.
  4. 4It groups results by hiring manager and renders one Notion page per manager.
  5. 5It posts a Slack message to each manager linking their Notion shortlist for that week.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.