IT OPS
Detect First-Time SSO Logins to Unapproved Apps
Queries SSO authentication logs in Snowflake on a schedule, finds applications a user signed into for the first time that are not on the approved-app registry.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionQuery first-seen SSO app loginsSnowflake
- LogicDrop apps in approved registry
- ActionEnrich with department and OAuth scopesSnowflake
- OutputPost digest to security channelSlack
What it does
Reads your identity provider's authentication events landed in Snowflake, identifies any app a user authenticated to for the very first time, and cross-checks the app against your approved-application registry. New, unapproved app sign-ins are flagged as shadow IT and escalated. This catches free or trial SaaS that employees access via Google or Microsoft SSO with no spend trail at all.
When to use it
Use when your shadow-IT risk is dominated by OAuth and SSO sign-ups rather than card spend. Best for organizations piping Okta, Entra, or Google Workspace logs into a warehouse.
How it works
- 1A daily schedule triggers the run.
- 2An action queries Snowflake for distinct first-seen app sign-ins in the last 24 hours.
- 3A logic step filters out apps already present in the approved registry table.
- 4For each remaining app, an action enriches it with the user's department and OAuth scopes granted.
- 5A final output posts a digest to the security Slack channel and tags each user's manager for awareness.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect SlackChannels, DMs, threads, mentions.
- 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.