HR & RECRUITING

Gate external job postings until the bench is checked

When a req is moved to a 'ready to post externally' status in Notion, runs an internal-match check against BigQuery and either blocks the posting with a shortlist for review…

CategoryHR & Recruiting
EngineSim + Paperclip
Difficultyadvanced
Triggerevent
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerReq marked ready to post externallyNotionNotion
  • ActionPull active employee skill profilesGoogle BigQueryBigQuery
  • ActionScore internal candidates against reqOpenAI
  • LogicBranch on strong matches vs none
  • ActionUpdate req status and attach shortlistNotionNotion
  • OutputRecord cleared posting decisionSlack

What it does

This enforces an internal-first hiring policy as a hard gate. Before any role goes to external boards, the workflow verifies there is genuinely no strong internal candidate — and if there is, it pauses the posting and surfaces the shortlist for a human decision.

When to use it

Use this when leadership requires documented proof the bench was checked before external spend. It suits compliance-minded talent orgs that manage req lifecycle stages in Notion.

How it works

  1. 1A req's status changes to "ready to post externally" in Notion (trigger).
  2. 2A BigQuery query pulls active employees and their skill profiles.
  3. 3An OpenAI step scores internal candidates against the req requirements.
  4. 4A logic branch decides the outcome: strong matches found versus none.
  5. 5If matches exist, the req status is set back to "internal review" in Notion with the shortlist attached; if not, it is approved for external posting and a Slack note records the cleared decision.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect NotionPages, databases, comments.
  2. 2
    Connect BigQueryDatasets, queries, schemas.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.