IT OPS
Reclaim dormant SaaS seats from SSO login logs
Weekly scan of SSO login telemetry in BigQuery to find licensed accounts with no sign-in for 45+ days, then opens a manager-approved deprovision ticket in ClickUp for each one.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule
- ActionQuery dormant seats (45+ days no login)BigQuery
- LogicExclude service accounts and staff on leave
- ActionEmail manager for deprovision approvalOutlook
- LogicBranch on approval (auto-approve after 5 days)
- OutputOpen deprovision ticket in ClickUpClickUp
What it does
Queries your warehouse of SSO/IdP login events to surface paid SaaS seats that nobody has actually used in over 45 days, then routes each dormant account to its manager for approval before opening a deprovision ticket. The outcome is a steady, auditable trickle of recovered licenses instead of an annual panic before renewal.
When to use it
Run this when your SSO provider (Okta, Entra, Google) exports login events into BigQuery and you pay per-seat for tools like Salesforce, Figma, or monday. Best for orgs with 100+ seats where manual reviews never happen.
How it works
- 1A weekly schedule kicks off the run.
- 2A BigQuery query joins the license roster against login events and returns every seat with last_login older than 45 days.
- 3A logic step filters out service accounts and anyone on leave.
- 4For each remaining seat, an email asks the listed manager to approve reclamation, defaulting to approve after 5 business days.
- 5Approved seats become a ClickUp deprovision ticket assigned to IT with the tool name, owner, and monthly cost attached.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect OutlookMail, calendar, contacts.
- 3Connect ClickUpDocs + tasks + chats in one workspace.
- 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.