IT OPS
Weekly Idle-Seat Audit from Okta Last-Login Logs
Pulls last-login data from your identity provider via webhook export, compares it against a license roster in Airtable.
How it runs
The automated pipeline, trigger to output.
- TriggerWebhook receives weekly IdP login exportHTTP webhook
- ActionMatch users to Airtable license rosterAirtable
- LogicRank by days-idle and reclaimable cost
- OutputEmail per-department idle-seat digestGmail
What it does
It builds a weekly idle-seat report by joining identity-provider login history against your authoritative license roster. Each department lead gets a tidy email of who has not logged in, how long it has been, and the recurring cost tied up in those seats.
When to use it
Use this when you want recurring visibility rather than a one-off cleanup, and your SSO covers most apps. It is the lightweight cousin of a full deprovisioning pipeline: it informs, it does not yet revoke.
How it works
- 1An inbound webhook delivers the weekly last-login export from your IdP.
- 2The flow looks up each user against the Airtable license roster to attach tool, team, and monthly cost.
- 3A logic step ranks seats by days-idle and multiplies by cost to compute reclaimable spend.
- 4Seats under the idle threshold are filtered out.
- 5A per-department digest email goes out via Gmail with the ranked idle list and a total potential saving.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect GmailRead, draft, send, label.
- 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.