FINANCE

Reconcile Desk Check-Ins Against Reservations in Real Time

Receives badge or QR check-in events and reconciles each against the day's desk reservations, flagging ghost bookings and unauthorized squatters for the facilities team.

CategoryFinance
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerCheck-in event webhook receivedHTTP webhook
  • ActionLook up today's reservation in AirtableAirtableAirtable
  • LogicBranch: match, walk-in, or mismatch
  • ActionConfirm occupancy or log exception in AirtableAirtableAirtable
  • OutputPost flagged exceptions to facilities SlackSlack

What it does

Keeps the desk-booking record honest as people actually arrive. Every check-in scan is matched to a reservation: legitimate arrivals are confirmed, desks with no matching booking are flagged as walk-ins, and reserved desks still empty by mid-morning are surfaced for release.

When to use it

Use this when you have a physical check-in signal (badge tap, QR poster, kiosk) and want live truth about who is sitting where. It turns raw scan events into a reconciled occupancy view without manual auditing.

How it works

  1. 1An incoming webhook fires on each desk check-in event (desk ID, badge ID, timestamp).
  2. 2The workflow looks up today's reservation for that desk in Airtable.
  3. 3A branch decides the case: matched reservation, walk-in with no booking, or wrong-person mismatch.
  4. 4Matched check-ins update the Airtable row to "occupied (confirmed)".
  5. 5Walk-ins and mismatches create a flagged exception row for review.
  6. 6Exceptions are pushed to the facilities Slack channel for a quick human decision.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect AirtableBases, tables, views, automations.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.