IT OPS
Stale External-Access Revocation Sweep for Dropbox
Weekly sweep that finds external collaborators on sensitive Dropbox folders whose owner reconfirmation has lapsed past the grace window, auto-revokes their access.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly revocation-sweep schedule
- ActionQuery lapsed external approvals in PostgresPostgres
- LogicSelect entries past the grace window
- ActionRemove expired collaborators from Dropbox foldersDropbox
- ActionLog revocations to Postgres ledgerPostgres
- OutputNotify owners of removals in TeamsMicrosoft Teams
What it does
This workflow closes the loop on unconfirmed external access. Each week it reads the approval ledger in Postgres, finds external collaborators on sensitive folders whose last owner reconfirmation is older than the grace period, removes them from the Dropbox folder, and records the revocation. Owners get a Teams heads-up naming exactly who was removed and why.
When to use it
Use it when reconfirmation requests pile up and access lingers indefinitely. This enforces an expiry policy automatically — access that nobody re-approves within the window is pulled, keeping sensitive folders clean without manual chasing.
How it works
- 1A weekly schedule triggers the sweep.
- 2Postgres returns external collaborators whose reconfirmation has lapsed past the grace window.
- 3A logic step separates truly-expired entries from those still inside grace.
- 4Dropbox removes each expired collaborator from the folder.
- 5The revocation is written back to the Postgres ledger.
- 6A Teams message notifies each affected owner of the removals.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 2Connect DropboxFiles and folders.
- 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
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.