OTHER

Reservation vs. Calendar Conflict Sync

Compares each desk reservation against the holder's calendar and badge data, then cancels desks held by people who are out-of-office or on all-day remote.

CategoryOther
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerEarly-morning schedule before office open
  • ActionQuery today's reservations with holdersGoogle BigQueryBigQuery
  • ActionRead holder calendars for OOO/PTO/remoteGoogle CalendarGoogle Calendar
  • LogicFlag reservations conflicting with absence
  • ActionCancel conflicting holds via booking APIHTTP webhook
  • OutputDM holders confirming cancellationSlack

What it does

This workflow catches desks reserved by people who clearly won't use them: anyone whose Google Calendar shows an all-day out-of-office, PTO, or remote block for the day. Early each morning it cross-checks reservations against calendars and recent badge history, cancels the conflicting holds, and notifies the holders so capacity is freed before colleagues start hunting for seats.

When to use it

Use it when standing reservations or recurring desk bookings pile up while people are traveling, on leave, or working from home, quietly locking out in-office staff.

How it works

  1. 1An early-morning scheduled trigger fires before office open.
  2. 2Query BigQuery for today's reservations with holder identifiers.
  3. 3For each holder, read Google Calendar for all-day OOO, PTO, or remote events.
  4. 4A logic step flags reservations that conflict with an out-of-office or remote block.
  5. 5Call the booking API webhook to cancel each conflicting hold and free the desk.
  6. 6DM each holder on Slack confirming the cancellation and that they can re-book if plans changed.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect Google CalendarEvents, attendees, availability.
  3. 3
    Connect HTTP webhookTrigger any URL on agent actions.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.