IT OPS
Shadow-IT OAuth Grant Discovery to Airtable Inventory
On a daily schedule, pulls every third-party OAuth app authorized against your identity provider.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule fires
- ActionFetch all OAuth grants from IdP admin APICustom MCP server
- LogicNormalize scopes and tag sensitivity
- ActionUpsert each app into Airtable inventoryAirtable
- OutputWrite run summary row with new-app countAirtable
What it does
Keeps a living inventory of every third-party OAuth application that employees have granted access to your Google Workspace or Microsoft 365 tenant. Each app, its scopes, and the count of users who authorized it land in one Airtable base you can sort, filter, and review.
When to use it
Run this when you have no central record of shadow-IT app connections and need a baseline before you can decide what to revoke. It is the discovery layer the rest of your OAuth-governance workflows build on.
How it works
- 1A daily schedule fires the run.
- 2A custom-MCP call queries your identity provider's admin API for all authorized third-party apps, their granted scopes, and per-app user counts.
- 3A logic step normalizes scope strings and computes a coarse sensitivity tag (read-only, read-write, full-mailbox/drive).
- 4An Airtable action upserts each app by client ID, updating scope and user-count fields and stamping a last-seen date.
- 5The final output writes a run summary row recording how many apps were new this cycle.
Set it up
What you configure once, before turning it on.
- 1Connect Custom MCP serverConnect any MCP-compatible tool you own.
- 2Connect AirtableBases, tables, views, automations.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, 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.