IT OPS
Orphaned Google Drive license detector for offboarded staff
Scans Google Drive for accounts still holding licenses after the employee left the directory, then opens a deprovisioning ticket in Linear for each orphaned seat.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule starts the check
- ActionList active Drive accounts and ownersGoogle Drive
- ActionRead active-employee rosterAirtable
- LogicKeep seats owned by departed staff
- OutputOpen a deprovisioning ticket per orphanLinear
What it does
Finds the gap between who still has an active Google Workspace seat and who is no longer an active employee. It compares Drive account ownership against your HR roster, isolates accounts belonging to departed people, and files a tracked deprovisioning task for each so the license is reclaimed and data is reassigned.
When to use it
When offboarding is inconsistent and former employees keep their Workspace seats for weeks. Use it to close the loop between HR status changes and actual license removal.
How it works
- 1A daily schedule starts the check.
- 2The flow lists recently active Drive accounts and their owners.
- 3It reads the active-employee roster from your Airtable HR table.
- 4A logic step keeps only Drive seats whose owner is missing or marked terminated in the roster.
- 5For each orphaned seat, it creates a Linear issue with the account, last activity, and files to reassign.
- 6A summary of opened tickets is delivered for the IT queue.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect LinearIssues, projects, cycles, triage.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More IT Ops workflows
Daily Building Anomaly Digest to MS Teams
Each morning queries BigQuery for the prior day's flagged sensor anomalies, summarizes them by site and system into a ranked briefing.
Indoor Air Quality Breach to Tenant Notice and Work Order
Listens for CO2, VOC, or humidity sensor alerts via webhook, and when a zone exceeds occupant-safety limits it emails affected tenants, opens a Monday remediation task.
Self-Service Reclaim Email for Idle Users
Detects users idle in a SaaS app past the threshold and emails each one a keep-or-release link; unanswered seats after the deadline are auto-flagged for removal.
Outlook Room Conflict Resolver with Approval Gate in Teams
When an Outlook room clashes, proposes a rebooking and asks the bumped meeting's organizer to approve the move in Microsoft Teams before any change is made.
Outlook Room Double-Booking Resolver with Auto-Rebook
Detects when two meetings claim the same Outlook room resource and automatically relocates the lower-priority meeting to a comparable free room.
Monthly Wasted-License Cost Report
Aggregates inactive-seat data across all tracked SaaS apps each month, computes total reclaimable spend, and delivers a ranked cost report to leadership in Notion and Slack.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.