HR & RECRUITING

Severity-tiered comp drift triage to Monday and Slack escalation

Weekly audit that classifies pay drift by severity, routes minor cases to a Monday review queue.

CategoryHR & Recruiting
Enginesim
Difficultyadvanced
Triggerschedule
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule starts the audit
  • ActionCompute percent deviation from midpoint in BigQueryGoogle BigQueryBigQuery
  • LogicClassify each case as minor or severe
  • ActionCreate Monday review item for minor casesmonday.com
  • ActionEscalate severe under-band cases to SlackSlack
  • OutputRecord counts per severity tier

What it does

This workflow adds decision logic on top of the drift audit. It scores how far each employee's pay sits outside band, then routes by severity: small deviations become standard Monday review items, while large under-band gaps trigger an immediate Slack escalation so retention-risk cases get attention before the next cycle.

When to use it

Use it when not every drift case is equal and you want to protect against flight risk. Good for teams who already triage comp issues by urgency and need a defensible threshold-based split between routine review and escalation.

How it works

  1. 1A weekly schedule starts the audit.
  2. 2A BigQuery query computes each employee's percentage deviation from their refreshed midpoint.
  3. 3A branch classifies each flagged case as minor (within tolerance bands) or severe (well below minimum).
  4. 4Minor cases create a standard Monday review item for the manager.
  5. 5Severe cases post a Slack alert to the People Ops channel tagging the comp partner.
  6. 6A summary output records counts per severity tier.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect monday.comVisual work management for teams.
  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.