IT OPS
Flag Redundant SaaS Spend Across Departments
Joins Stripe subscription data with the SaaS category catalog in Snowflake to find multiple teams paying for tools in the same category.
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly schedule
- ActionPull active subscriptions from StripeStripe
- ActionJoin with category catalogSnowflake
- LogicFind categories with 2+ vendors, rank by spend
- ActionCreate consolidation opportunitymonday.com
- OutputPost top opportunities to IT channelSlack
What it does
Looks across all recurring SaaS spend and groups it by functional category, then finds categories where more than one distinct vendor is being paid for by different departments. For each overlap it estimates annualized duplicate spend and opens a consolidation opportunity so IT can standardize on one tool.
When to use it
Run this monthly or ahead of budget planning when you suspect teams are independently buying overlapping tools. It is the cost-optimization companion to discovery: not every shadow tool is a risk, but duplicate categories are almost always waste.
How it works
- 1A monthly schedule triggers the run.
- 2An action pulls active subscriptions and amounts from Stripe.
- 3An action joins them against the category catalog in Snowflake to tag each vendor's function.
- 4A logic step identifies categories with two or more distinct vendors across departments and ranks by total spend.
- 5An action creates a consolidation opportunity in Monday with the overlapping vendors and estimated savings.
- 6A final output posts the top opportunities to the IT-ops Slack channel.
Set it up
What you configure once, before turning it on.
- 1Connect StripeCustomers, subscriptions, payments.
- 2Connect SnowflakeWarehouses, queries, shares.
- 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.