IT OPS
Department-Based Access Group Assignment
On a scheduled run, finds newly approved hires and assigns them to the correct access groups and distribution lists for their department.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily scheduled run
- ActionQuery approved hires without group assignmentPostgres
- LogicMatch department to access groups, flag missing fields
- ActionAdd users to Teams groups and distribution listsMicrosoft Teams
- ActionWrite membership changes to audit tablePostgres
- OutputSend assignment summary to IT operations channelSlack
What it does
Keeps access-group membership in sync with your roster. Each run, it pulls hires marked approved-but-not-yet-grouped, matches their department to a predefined set of security groups and email distribution lists, applies the memberships, and writes an audit record so you can prove who got what and when.
When to use it
Use this when access groups (not individual app accounts) are how you gate permissions, and you need a clean audit trail for compliance reviews. Ideal for organizations where department determines the bulk of someone's access footprint.
How it works
- 1A daily schedule kicks off the run.
- 2The flow queries Postgres for hires in `approved` state without group assignment.
- 3For each hire, it looks up the department-to-group mapping.
- 4A filter skips anyone missing a required department field and flags them for review.
- 5It adds the user to the matching Microsoft Teams groups and distribution lists.
- 6It writes each membership change to an audit table in Postgres.
- 7It sends a summary of assignments and skipped records to the IT operations channel.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect Microsoft TeamsChannels, chats, files.
- 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
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.
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.
Reconcile SSO logins against expense spend to find unmanaged tools
Joins SSO usage data with expense/payment records in Snowflake to surface tools that are being used but not paid for, or paid for but never logged.
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.
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.
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.