HR & RECRUITING

Alert Managers When a Team Crosses an Attrition Threshold

When a new exit interview lands, recalculates the trailing-90-day attrition rate for that team and, if it crosses a set threshold, sends the manager a Slack DM summarizing…

CategoryHR & Recruiting
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew tagged exit record in AirtableAirtableAirtable
  • ActionCompute team trailing-90-day attrition rateAirtableAirtable
  • LogicCrossed threshold? Else end quietly
  • ActionSummarize team's dominant exit themesOpenAI
  • OutputDM the team manager on SlackSlack

What it does

Watches for concentrated, team-level attrition and surfaces it before it becomes a pattern leadership only notices in a quarterly report. It only alerts when a specific team's recent departure rate exceeds a configurable threshold.

When to use it

Use it when you want managers to get an early, targeted heads-up about churn on their own team, with the reasons attached, rather than a company-wide average that hides hot spots.

How it works

  1. 1A new tagged exit-interview record in Airtable triggers the run.
  2. 2An Airtable query computes the departing employee's team headcount and counts exits from that team over the trailing 90 days.
  3. 3A logic step checks whether the team's attrition rate crosses the configured threshold; if not, the run ends quietly.
  4. 4When the threshold is crossed, OpenAI summarizes the dominant exit themes for that specific team into two or three bullets.
  5. 5A Slack direct message is sent to the team's manager with the rate, threshold, and theme summary.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect OpenAIModels, embeddings, files.
  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.