IT OPS
Catch Subscriptions Paid for Departed Employees
Cross-references active Stripe subscriptions and SSO ownership in Snowflake against the HR active-roster.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule
- ActionPull subscriptions and owners from StripeStripe
- ActionQuery active roster and SSO statusSnowflake
- LogicFlag subscriptions with departed owners
- ActionOpen offboarding taskmonday.com
- OutputAlert IT-ops with recoverable spendSlack
What it does
Matches the owner of every active SaaS subscription against the current employee roster. When the spend owner or SSO account belongs to someone who has left, the subscription is flagged as orphaned and routed for cancellation or reassignment, so the company stops paying for unowned seats and closes a dormant access risk.
When to use it
Use when employee turnover means subscriptions outlive the people who bought them. It pairs naturally with offboarding: the formal HR process rarely catches every personally-expensed or self-signed-up tool.
How it works
- 1A weekly schedule triggers the run.
- 2An action pulls active subscriptions and their owner identities from Stripe.
- 3An action queries Snowflake for the current active-employee roster and SSO account status.
- 4A logic step flags subscriptions whose owner is no longer active.
- 5An action opens an offboarding task in Monday to cancel or reassign each orphaned tool.
- 6A final output alerts IT-ops in Slack with the list and total recoverable spend.
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.