OTHER
Weekly Desk Utilization Report
Compiles a weekly facilities report comparing reservations, actual badge-confirmed usage, and no-show rates per floor and team.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly Monday schedule for prior week
- ActionAggregate bookings, usage, no-shows by floor/teamBigQuery
- LogicCompute utilization and rank worst zones
- ActionWrite weekly rollup to reporting tableBigQuery
- OutputPost utilization digest to leadership channelSlack
What it does
Once a week this workflow rolls up the reconciliation data into a leadership-ready report: how many desks were booked, how many were actually used (confirmed by badge-in), the no-show rate, and utilization broken down by floor and team. It writes the rollup to a reporting table and posts a digest so facilities can right-size floors and spot chronic over-booking.
When to use it
Use it when you need recurring evidence for space-planning, lease, or return-to-office decisions instead of one-off ad hoc pulls. It turns daily badge-vs-booking data into a trend.
How it works
- 1A weekly scheduled trigger runs Monday morning for the prior week.
- 2Query BigQuery aggregating reservations, badge-confirmed usage, and no-shows by floor and team.
- 3A logic step computes utilization and no-show percentages and ranks the worst-performing zones.
- 4Write the computed weekly rollup back to a BigQuery reporting table for dashboards.
- 5Post a formatted digest of the week's utilization and top no-show teams to the facilities leadership Slack 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.