HR & RECRUITING
Quarterly Skills-Gap Report for Learning & Development
Each quarter, aggregates the skills your open roles demand against the skills and goals your workforce actually has.
How it runs
The automated pipeline, trigger to output.
- TriggerQuarterly schedule
- ActionQuery open/planned roles and workforce skills+goals from BigQueryBigQuery
- ActionCompute aggregate gaps and redeployments each skill blocksOpenAI
- LogicRank gaps by impact; tag those aligned to growth goals
- OutputPost prioritized skills-gap report to L&D Slack channelSlack
What it does
Turns the matcher's data into a strategic view for Learning & Development. Rather than matching one person to one role, it rolls up the gap between what open and forecast roles require and what the current workforce can offer, then ranks the skill shortfalls by how many redeployments they're blocking.
When to use it
Use it when planning training budgets, curriculum, or hiring strategy. Ideal for L&D and people-analytics teams who want evidence-based priorities: which capabilities, if built internally, would unlock the most internal moves and reduce external hiring.
How it works
- 1A quarterly schedule fires the workflow.
- 2The flow queries open and planned roles plus the full workforce skills-and-goals dataset from BigQuery.
- 3An OpenAI step computes the aggregate gaps and estimates how many redeployments each missing skill is blocking.
- 4A logic step ranks the gaps by impact and tags those that overlap with stated employee growth goals as high-leverage.
- 5The prioritized skills-gap report is posted to the L&D team's Slack channel.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.