IT OPS
Shadow-IT Discovery: Correlate SSO Logins with Expense Charges into a Review Queue
Cross-references SSO authentication events with corporate-card SaaS charges to surface apps employees use that IT never approved.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires
- ActionQuery Datadog SSO auth events for app domains + user countsDatadog
- ActionRead expense ledger CSV and isolate recurring SaaS chargesGoogle Drive
- LogicJoin on domain, drop sanctioned allowlist apps
- ActionCreate a Monday review-queue item per unsanctioned appmonday.com
- OutputPost run summary to Slack #it-opsSlack
What it does
It pulls recent SSO login events and recurring software charges from your expense export, joins them on vendor domain, and removes anything already on your sanctioned-app allowlist. Every remaining app — a real tool people are paying for or signing into without IT's blessing — lands as a triaged card in a Monday board so your team can review it instead of discovering it during an audit.
When to use it
Run it weekly when you want a living inventory of unsanctioned SaaS rather than a once-a-year spreadsheet scramble. It is the entry point for the rest of the shadow-IT pipeline.
How it works
- 1A weekly schedule fires the workflow.
- 2It queries Datadog for SSO/auth log events and extracts the destination app domains and user counts.
- 3In parallel it reads the expense ledger CSV from Google Drive and isolates recurring SaaS line items by merchant.
- 4A logic step joins both sources on normalized domain and drops any app present in the sanctioned allowlist.
- 5For each surviving app it creates a Monday item with discovery source, user count, and monthly spend pre-filled.
- 6A Slack message summarizes how many new unsanctioned apps were queued this run.
Set it up
What you configure once, before turning it on.
- 1Connect DatadogMetrics, traces, log search.
- 2Connect Google DriveDocs, sheets, slides, files.
- 3Connect monday.comVisual work management for teams.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, 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.