IT OPS
Export a 60-day idle-seat reclamation report to Drive
Builds a monthly CSV of every SaaS seat unused for 60+ days with cost-per-seat, saves it to Google Drive, and notifies finance and IT for review before any deprovisioning.
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly schedule fires
- ActionQuery seats + last-login via admin APIHTTP webhook
- LogicFilter 60+ day idle, attach seat cost
- ActionBuild dated CSV reclamation report
- ActionUpload CSV to shared Drive folderGoogle Drive
- OutputNotify finance + IT in Slack with linkSlack
What it does
This is the report-first variant: instead of acting immediately, it compiles a clean monthly snapshot of idle seats and their cost, drops it in a shared Google Drive folder, and pings the right people to review. It is the paper trail that justifies a reclamation cycle.
When to use it
Use it when finance or security wants evidence before seats are touched, or during a cost-cutting review where humans decide the cuts. Pair it with a separate deprovisioning workflow once decisions are made.
How it works
- 1A monthly schedule kicks off the run.
- 2The flow queries the SaaS admin API over HTTP webhook for all seats and last-login dates.
- 3A filter keeps seats idle 60+ days and joins each to its per-seat license cost.
- 4It formats the results into a dated CSV report.
- 5It uploads the CSV to a shared Google Drive folder.
- 6It posts a Slack message linking the report and tagging finance and IT for sign-off.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect Google DriveDocs, sheets, slides, files.
- 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.