OTHER
Ghost Occupancy Detector
Flags the reverse problem: people who badged into the building and are sitting at desks but never made a reservation.
How it runs
The automated pipeline, trigger to output.
- TriggerMid-morning schedule after arrivals
- ActionQuery badge-ins left-joined to reservationsBigQuery
- LogicExclude exempt roles and de-duplicate
- ActionPrompt ghost occupants to claim a desk on SlackSlack
- ActionLog unreserved attendance to audit tableBigQuery
- OutputPost ghost-occupancy count to ops channelSlack
What it does
This workflow finds "ghost" occupancy: employees present in the building (badge-in recorded) who have no desk reservation for the day. It identifies them, nudges each one over Slack to claim or confirm a desk, and logs the unreserved attendance so facilities sees true vs. booked occupancy.
When to use it
Use it when reservation compliance is low and your floor-plan data can't be trusted because half the people in the office walked in and grabbed any open seat. It closes the gap between badge data and booking data.
How it works
- 1A scheduled trigger runs mid-morning after most arrivals.
- 2Query BigQuery for today's badge-in events left-joined to reservations, keeping employees with a badge-in but no booking.
- 3A logic step de-duplicates and excludes employees on approved no-desk roles (visitors, on-floor staff).
- 4Send each ghost-occupancy employee a Slack prompt with a one-click link to claim a desk.
- 5Write the unreserved-attendance records back to a BigQuery audit table for occupancy reporting.
- 6Post the day's ghost-occupancy count to the facilities ops channel.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 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 Other workflows
Sweep stale visitor check-ins, auto-checkout, and flag overdue guests
On a recurring schedule this finds visitors still marked on-site past their expected departure, auto-checks-out anyone past end-of-day.
Pre-register a visitor, email a QR badge, and alert the host on arrival
When a host submits a visitor pre-registration form, this creates a visitor record, emails the guest a scannable QR badge with arrival instructions.
Build a daily expected-visitor roster and send it to the front desk
Every morning this pulls the day's pre-registered visitors from Airtable, builds a sorted arrival roster with hosts and times.
Agent-Driven Full IVR Re-Voicing for a Rebrand
An agent takes a rebrand brief from Notion, audits every IVR prompt for old naming, rewrites and re-synthesizes the affected ones with ElevenLabs, archives them to Dropbox.
Sync IVR Prompt Registry in Airtable to Fresh ElevenLabs Audio
Runs nightly against an Airtable IVR prompt registry, finds rows whose script text changed since last synthesis, regenerates only those ElevenLabs clips.
Slack-Approved IVR Re-Voicing After a Product Rename
On demand from Slack, drafts updated IVR prompt scripts for a renamed product, posts them for human approval.
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.