IT OPS

Reconcile offboarding actions into a queryable audit ledger

After access is revoked, this workflow gathers proof from Slack, GitHub, and Google Drive, writes a structured row per system to a Postgres audit ledger.

CategoryIT Ops
Enginesim
Difficultyadvanced
Triggerwebhook
Steps6
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerOffboarding-complete webhook receivedHTTP webhook
  • ActionVerify GitHub access removedGitHubGitHub
  • ActionVerify Google Drive shares removedGoogle DriveGoogle Drive
  • LogicSplit confirmed vs unconfirmed systems
  • OutputInsert per-system rows into Postgres ledgerPostgreSQLPostgres
  • ActionAlert IT on any unconfirmed revocationSlack

What it does

Closes the audit loop. Following an offboarding, it re-checks each system to confirm access is actually gone, writes a structured evidence row per system into a Postgres ledger, and raises an alert if any system still reports active access.

When to use it

Use it when auditors need queryable, per-system proof that revocation happened, not just a free-text note. The Postgres ledger lets you answer "prove this person lost access on this date" with a single query.

How it works

  1. 1An offboarding-complete webhook fires with the employee email and run id.
  2. 2The workflow re-checks GitHub to verify org membership is gone.
  3. 3It re-checks Google Drive to verify no active shares remain.
  4. 4A branch separates confirmed-revoked systems from any still showing access.
  5. 5Confirmed evidence rows are inserted into the Postgres audit ledger, one per system, with status and timestamp.
  6. 6Any unconfirmed revocation triggers a Slack alert to IT so the gap is fixed immediately.

Set it up

What you configure once, before turning it on.

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