IT OPS
Reclaim SaaS Licenses from Snowflake Usage Data
Queries a Snowflake usage warehouse nightly for seats with no login or activity in 60+ days.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionQuery Snowflake for 60-day inactive seatsSnowflake
- LogicDrop exempt / leave-of-absence users
- ActionAppend reclamation rows to Airtable trackerAirtable
- OutputPost manager sign-off summary to TeamsMicrosoft Teams
What it does
This workflow finds paid SaaS seats nobody is using and turns them into a clean reclamation queue. It runs against your Snowflake activity warehouse, flags every license that has gone dark past your inactivity threshold, and routes each one for manager approval before anyone touches it.
When to use it
Run this when license spend keeps climbing but usage is flat, or during a quarterly true-up where finance wants evidence before you cut seats. It is ideal for orgs that already centralize SSO and tool telemetry in Snowflake.
How it works
- 1A nightly schedule fires the run.
- 2It queries Snowflake for users whose last activity timestamp across each tracked tool exceeds 60 days.
- 3A filter drops anyone on a known leave-of-absence or exemption list.
- 4For each remaining seat it appends a reclamation row to an Airtable tracker with tool, cost, and last-seen date.
- 5It posts a per-manager summary to Microsoft Teams asking for keep-or-reclaim sign-off.
- 6Approved rows stay queued in Airtable for the next deprovisioning pass.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect Microsoft TeamsChannels, chats, files.
- 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.