OTHER

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.

CategoryOther
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily 7:30am schedule
  • ActionQuery today's pre-registered visitorsAirtableAirtable
  • LogicSkip if no visitors expected
  • ActionEmail roster to receptionGmailGmail
  • OutputPost roster to front-desk Teams channelMicrosoft Teams

What it does

Gives reception a single, accurate list of everyone expected that day, grouped by arrival time with the host and visit purpose, so nobody is caught off guard at the desk.

When to use it

Use it when visitors are pre-registered throughout the week but the front desk needs a clean same-day briefing. Ideal for offices with a staffed reception that prints or screens a daily roster.

How it works

  1. 1A scheduled trigger runs each weekday at 7:30am local time.
  2. 2The flow queries Airtable for visitor records whose visit date is today and status is `Pre-registered`.
  3. 3A branch checks whether any visitors are expected; if none, the run ends quietly with no email.
  4. 4The matching records are sorted by expected arrival time and formatted into a readable roster table including host, company, and purpose.
  5. 5The roster is emailed via Gmail to the reception distribution list, with a count in the subject line.
  6. 6The same summary is posted to the front-desk Teams channel so the on-shift greeter sees it without checking email.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect GmailRead, draft, send, label.
  3. 3
    Connect Microsoft TeamsChannels, chats, files.
  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.