HR & RECRUITING
Publish a Quarterly Skills-Gap Report to Notion
Each quarter, cross-references the team's shipped-tech skills inventory against the requirements of all current open roles and the upcoming roadmap.
How it runs
The automated pipeline, trigger to output.
- TriggerQuarterly schedule fires
- ActionRead skills inventory and open rolesAirtable
- LogicCompute coverage, bus-factor, unmet requirements
- ActionSynthesize ranked gap narrative
- OutputPublish gap report to NotionNotion
What it does
This workflow produces the leadership-facing view of where the team's capabilities are thin. It aggregates the demonstrated skills across the whole org, compares them against every open requisition's requirements, and synthesizes a prioritized report: which technologies are over-concentrated in one person, which are entirely missing, and where hiring or training will move the needle most.
When to use it
Use it at quarterly planning to ground headcount and L&D budget conversations in evidence rather than anecdote.
How it works
- 1A quarterly schedule starts the run.
- 2A deterministic step reads the Airtable skills inventory and all open-role requirements.
- 3It computes coverage, bus-factor risk, and unmet-requirement counts per skill.
- 4An agent writes the ranked narrative: top gaps, recommended hire vs train per gap, and concentration risks.
- 5It publishes the formatted report as a new Notion page in the People-Ops space.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 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
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.