IT OPS

Daily sweep for dormant accounts of departed staff

Runs every morning, cross-checks an offboarding roster against live access in GitHub and Google Drive, and flags any account that should have been revoked but is still active.

CategoryIT Ops
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily morning schedule fires
  • ActionRead departed-employee rosterAirtableAirtable
  • ActionCheck lingering GitHub membershipGitHubGitHub
  • ActionCheck active Google Drive accessGoogle DriveGoogle Drive
  • LogicKeep only still-active overdue accounts
  • OutputPost exceptions to Slack ops channelSlack

What it does

Catches offboarding gaps. Each day it reads the list of employees marked as departed, checks whether they still have active GitHub org membership or Google Drive access, and posts any stragglers to a Slack channel for the IT team to clear.

When to use it

Use it as a safety net behind your real-time revocation. Manual offboarding misses things; this scheduled audit surfaces accounts that slipped through so nothing stays live past someone's last day.

How it works

  1. 1A daily schedule triggers the sweep each morning.
  2. 2The workflow pulls the roster of departed employees from an Airtable offboarding table.
  3. 3For each departed person, it checks GitHub for lingering org membership.
  4. 4It checks Google Drive for files still owned by or shared with that account.
  5. 5A branch keeps only accounts that are still active despite a past departure date.
  6. 6The exceptions are posted to a Slack ops channel with the account, the gap, and the days overdue.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect GitHubRepos, issues, pull requests, actions.
  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.