IT OPS
Contractor Expiry Auto-Deprovision and Renewal Check
When a contractor's engagement end date passes, automatically revoke their SaaS access unless a renewal is on file, and notify the sponsoring manager either way.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily contractor-expiry schedule fires
- ActionQuery Postgres for engagements ending today or earlierPostgres
- LogicBranch on active renewal flag (skip vs deprovision)
- ActionRevoke GitHub access for non-renewed contractorsGitHub
- OutputNotify sponsoring manager of action taken in SlackSlack
What it does
Keeps contractor access from outliving the contract. Each day it checks for engagements whose end date has passed, confirms whether a renewal exists, and either auto-deprovisions the contractor's seats or pauses for a flagged renewal — then tells the sponsoring manager which path it took.
When to use it
Run it continuously for any organization that grants tool access to fixed-term contractors and agencies, so expired engagements never quietly retain Slack, GitHub, or Drive access.
How it works
- 1A daily schedule triggers the expiry check.
- 2The flow queries Postgres for contractor engagements with an end date on or before today.
- 3A logic branch checks each record for an active renewal flag.
- 4Renewed contractors are skipped and logged; non-renewed contractors proceed to deprovisioning.
- 5The flow revokes their GitHub access and removes them from Slack workspaces.
- 6The sponsoring manager gets a Slack message stating whether access was revoked or held for renewal.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect GitHubRepos, issues, pull requests, actions.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.