IT OPS

Dormant Google Workspace Seat Reclaim with Email Warning

Scans Google Workspace login activity, finds users dormant past a grace window, and emails each one a 7-day reclaim warning while logging the case to a Monday board for IT review.

CategoryIT Ops
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonthly schedule starts the dormant-seat check
  • ActionQuery Google Drive activity and last-active timestampsGoogle DriveGoogle Drive
  • LogicKeep only users dormant beyond grace window
  • ActionEmail each dormant user a 7-day reclaim warningGmailGmail
  • ActionLog warned accounts to Monday with follow-up datemonday.com
  • OutputPost warned count and savings to SlackSlack

What it does

This workflow reads Google Drive and Workspace activity to identify accounts that have not logged in or touched a file within your grace window. Rather than yanking access immediately, it emails each dormant user a courteous 7-day warning that their seat is slated for reclamation, and records every case on a Monday board so IT can act if someone replies.

When to use it

Use it when you want a human-friendly reclamation step before deprovisioning Workspace seats, especially for orgs where employees travel, take leave, or rotate projects and a hard cut would cause support tickets.

How it works

  1. 1A schedule trigger starts the monthly check.
  2. 2Query Google Drive activity and last-active timestamps per user.
  3. 3Branch: keep only users dormant beyond the grace window.
  4. 4Send each dormant user a Gmail reclaim-warning notice with a reply-to-keep link.
  5. 5Log every warned account to a Monday board with a 7-day follow-up date.
  6. 6Post the warned-user count and projected reclaim savings to Slack.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Connect GmailRead, draft, send, label.
  3. 3
    Connect monday.comVisual work management for teams.
  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.