IT OPS
Reconcile Vendor Seat Exports Against Active Directory
Picks up a vendor's monthly seat-count CSV dropped in Google Drive, cross-checks each licensed account against your active-user roster.
How it runs
The automated pipeline, trigger to output.
- TriggerNew seat-export CSV in Drive folderGoogle Drive
- ActionLoad active-user roster from SnowflakeSnowflake
- LogicDiff licensed seats vs active users
- ActionAppend ghost seats to Drive tracking sheetGoogle Drive
- OutputNotify IT-ops of reclaimable spend in TeamsMicrosoft Teams
What it does
Catches seats you pay for that map to nobody current. When a SaaS vendor's billing export lands in a Drive folder, it compares every licensed account against your active-employee list and surfaces the mismatches as ghost seats.
When to use it
Use it for vendors that bill per seat but don't expose a clean usage API, where the only signal is a monthly CSV. Great for catching contractor seats, shared logins, and duplicates.
How it works
- 1A trigger fires when a new seat-export CSV appears in the watched Google Drive folder.
- 2An action loads your current active-user roster from Snowflake.
- 3A logic step diffs licensed accounts against active users to find ghost seats.
- 4For each ghost seat, an action appends a row to a reclamation tracking sheet in Drive.
- 5A final output messages IT-ops in Teams with the ghost-seat count and reclaimable spend.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect SnowflakeWarehouses, queries, shares.
- 3Connect Microsoft TeamsChannels, chats, files.
- 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.