HR & RECRUITING

Promotion Uplift Band Validator

When a promotion request is submitted, this checks whether the proposed new salary lands inside the target level's comp band and is a reasonable uplift over current pay.

CategoryHR & Recruiting
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerPromotion request form posts to webhookHTTP webhook
  • ActionLook up target level comp band in AirtableAirtableAirtable
  • LogicCheck pay within band AND uplift within policy range
  • ActionRecord valid requests in Google Drive tracking sheetGoogle DriveGoogle Drive
  • OutputFlag out-of-band requests to comp partner in SlackSlack

What it does

Validates promotion comp at the moment of request. It confirms the proposed new salary sits within the target level's band and that the percentage uplift over current pay falls inside policy guardrails — too small undermines the promotion, too large breaks budget norms.

When to use it

Use this during promotion cycles or ad-hoc promotions when managers propose new salaries and you need to guarantee each one lands in the destination band and respects uplift policy before it reaches finance.

How it works

  1. 1A promotion request form submission hits the incoming webhook with employee, target level, current pay, and proposed pay.
  2. 2The flow looks up the target level's comp band from Airtable.
  3. 3A logic step checks two conditions: proposed pay within band, and uplift percentage within the allowed range.
  4. 4Valid requests are recorded as approved-pending-finance in the tracking sheet on Google Drive.
  5. 5Requests that miss either guardrail are flagged with the specific reason and routed to the comp partner in Slack for adjustment before resubmission.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect AirtableBases, tables, views, automations.
  3. 3
    Connect Google DriveDocs, sheets, slides, files.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.