IT OPS
Outlook Room Nightly Double-Booking Audit
Runs every night across all managed room mailboxes, finds every overlapping reservation for the next 14 days, writes them to a Postgres conflicts table.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule fires
- ActionPull 14-day bookings for all room mailboxesOutlook
- LogicCompute pairwise overlaps per room
- ActionUpsert conflicts into Postgres tablePostgres
- OutputEmail prioritized morning digest to facilitiesOutlook
What it does
This is the scheduled safety net that catches conflicts real-time triggers miss — bookings made offline, imported from migrations, or created before monitoring was enabled. Each night it sweeps every room mailbox for the next two weeks, identifies all overlapping reservations, persists them to a Postgres table for tracking and trend reporting, and sends facilities a ranked digest of what needs fixing before the day starts.
When to use it
Use it as a daily reconciliation pass alongside or instead of real-time detection, especially when you need an auditable record of conflicts over time. Ideal for IT-Ops teams reporting on room-utilization health.
How it works
- 1A nightly schedule kicks off the audit.
- 2The flow pulls upcoming bookings for every managed room mailbox across the next 14 days.
- 3It computes all pairwise time overlaps per room.
- 4Each conflict is upserted into a Postgres `room_conflicts` table with a stable key so repeats aren't duplicated.
- 5A digest, sorted by soonest collision and number of attendees affected, is emailed to the facilities distribution list.
Set it up
What you configure once, before turning it on.
- 1Connect OutlookMail, calendar, contacts.
- 2Connect PostgresAny Postgres URL — query, write, migrate.
- 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.