IT OPS
Zoom Idle Paid-Seat Sweep with Reclaim Queue
Runs a weekly sweep that flags Zoom Licensed users with no meetings hosted in the last 30 days, then posts a ranked reclaim queue to Slack for IT to action.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires the utilization sweep
- ActionList Zoom Licensed users with last-host and last-login datesZoom
- ActionWrite activity rows to BigQuery and compute days-idleBigQuery
- LogicFilter to seats idle past threshold, rank by days idle
- OutputPost ranked reclaim candidate list to SlackSlack
What it does
Each week this workflow pulls every Zoom Licensed (paid) user and their recent hosting activity, identifies seats that have gone unused past a threshold you set, and delivers a ranked reclaim candidate list to your IT-ops Slack channel. The outcome: you stop paying for dormant seats and have a concrete, reviewable list to act on.
When to use it
Run it when your Zoom bill keeps climbing but you suspect a chunk of Licensed seats are idle. Ideal for IT teams doing monthly or quarterly license true-ups who want evidence before downgrading anyone.
How it works
- 1A weekly schedule fires the sweep.
- 2The flow lists all Zoom users on the Licensed plan plus their last-meeting and last-login dates.
- 3Activity is written to BigQuery and joined against a 30-day window to compute days-since-last-host per user.
- 4A filter keeps only users past the idle threshold, sorted by days idle descending.
- 5The ranked candidate list (name, email, days idle, estimated monthly cost) posts to Slack for IT review.
Set it up
What you configure once, before turning it on.
- 1Connect ZoomMeetings, recordings, transcripts.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.