IT OPS
Daily Cloudflare Access vs HR Roster Reconciler
Each morning, pulls every Cloudflare Access app grant, compares it against the active-employee roster in your HR Postgres table.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule (07:00 local)
- ActionList Cloudflare Access apps and user grantsCloudflare
- ActionQuery active employees from HR Postgres tablePostgres
- LogicDiff grants vs roster; classify orphaned access
- ActionWrite grant snapshot to Postgres for audit historyPostgres
- OutputPost orphaned-access report to SlackSlack
What it does
Reconciles who *can* reach your internal apps through Cloudflare Access against who *should*, using your HR system as the source of truth. It surfaces grants tied to people who have left the company or were never on the roster, so orphaned access never lingers.
When to use it
Run this when you need a recurring, auditable check that access follows employment status. Ideal for SOC 2 / ISO access-review evidence and for catching offboarding gaps before an auditor (or attacker) does.
How it works
- 1A daily schedule fires the workflow.
- 2It calls Cloudflare to list Access applications and their assigned users/policies.
- 3It queries the HR Postgres table for all employees with status `active`.
- 4A logic step diffs the two sets, classifying each grant as matched, terminated, or unknown-identity.
- 5If any orphaned grants exist, it posts a formatted Slack report listing the app, the email, and the reason.
- 6The full grant snapshot is written back to Postgres for trend history and audit evidence.
Set it up
What you configure once, before turning it on.
- 1Connect CloudflareWorkers, Pages, R2, KV — the edge stack.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 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.