HR & RECRUITING
Weekly PTO Burnout-Risk Manager Nudge
Every Monday, scans accrued-vs-used PTO balances in BigQuery, flags employees whose unused leave crosses a burnout threshold.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday morning schedule fires
- ActionQuery accrual, usage, and manager from BigQueryBigQuery
- LogicFlag over-threshold, zero-usage employees and group by manager
- ActionCompose per-manager at-risk summary
- OutputSlack DM each manager their flagged reportsSlack
What it does
This workflow runs a weekly check on your HR data warehouse and surfaces employees who are accruing time off faster than they take it. It groups the at-risk people under their direct manager and sends each manager a private Slack nudge so the conversation happens before someone burns out or loses unused days at year-end.
When to use it
Run this when you have PTO accrual and usage data landing in BigQuery and want managers to act on under-utilized leave proactively, rather than discovering balance problems during an annual review or a use-it-or-lose-it deadline.
How it works
- 1A Monday morning schedule fires the workflow.
- 2A BigQuery query pulls each employee's accrued balance, days used in the trailing 90 days, and their manager ID.
- 3A logic step flags anyone whose unused balance exceeds the configured threshold AND who took zero leave in the window, then groups the flagged rows by manager.
- 4For each manager with at least one flagged report, the workflow composes a concise summary with names, balances, and a recommended check-in.
- 5A Slack direct message delivers that per-manager summary, so each manager only sees their own team.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 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.