Skip to content

Daily Arrivals and Departures Briefing

Example prompt: "Every morning at 7am, read the 'Bookings' tab of our property Google Sheet and pull every booking where arrival_date is today or departure_date is today. For each, gather the room name, guest name, party size, arrival or departure time if known, any special requests (cot, accessible room, late check-in, anniversary), and any dietary notes from the breakfast column. Group rows into three sections: 'Departures Today' (in order of check-out time), 'Arrivals Today' (in order of expected arrival), and 'Stays Continuing' (guests already in-house who have requests on for today). Build a tidy one-page Google Doc in our 'Daily Briefings' Drive folder, named with today's date — bullet lines, not paragraphs, so housekeeping can act on it without reading it twice. Email the doc as a link to the breakfast cook, the housekeeper, and the front desk via Gmail, and post a Slack message in #front-desk with the same link and a one-line summary (e.g. 'Today: 3 in, 2 out, 1 cot, 1 gluten-free breakfast')."

The Problem

The morning briefing is the difference between a smooth day and one where the cot did not get put up, the gluten-free breakfast turned up wheaten, and the family arriving at three got given the room next to the wedding party. We know the information, it is all in the bookings sheet, but nobody has time at 7am to compile it into something the housekeeper can read while the kettle is on. So small things slip, and a small slip with a guest is rarely small.

How GloriaMundo Solves It

We build a workflow that runs at 7am every morning, reads the bookings sheet, and produces a one-page briefing. The arrivals and departures are pulled by date match, the special requests and dietary notes are read from the rows, and an LLM step turns the lot into clean bullet lines grouped by section. The briefing is saved as a Google Doc in our daily-briefings folder, emailed to the small team that needs it, and a Slack message goes out with a one-line summary. Glass Box preview shows us the doc before it lands in the team's inbox.

Example Workflow Steps

  1. Trigger (schedule): Every morning at 7am.
  2. Step 1 (integration): Read the 'Bookings' tab and find rows where arrival_date is today or departure_date is today.
  3. Step 2 (integration): For each row, pull room name, guest name, party size, expected arrival or departure time, special requests, and dietary notes.
  4. Step 3 (integration): Read the 'Stays In-House' tab for guests already on-site who have anything booked or noted for today.
  5. Step 4 (llm): Compose the briefing in three sections — Departures, Arrivals, Stays Continuing — with bullet lines and the one-line headline summary.
  6. Step 5 (integration): Save the briefing as a Google Doc in our 'Daily Briefings' Drive folder, named with today's date.
  7. Step 6 (integration): Email the document link to the cook, the housekeeper, and the front desk via Gmail.
  8. Step 7 (integration): Post a one-line summary in #front-desk on Slack with the link to the full briefing.

Integrations Used

  • Google Sheets — the bookings register and the in-house stays list
  • Google Docs — the daily briefing document
  • Google Drive — the 'Daily Briefings' folder for the morning archive
  • Gmail — sends the link to the on-shift team
  • Slack — the front-desk channel where the one-line headline lands

Who This Is For

Small hotel owners, B&B hosts, and guesthouse managers who already keep bookings in a spreadsheet, who run with a small team where the same person often takes both the booking and the breakfast order, and who would rather their housekeeper read a tidy bullet list at 7am than be told things in passing on the stairs at 9.

Time & Cost Saved

Compiling the briefing by hand takes twenty to thirty minutes at the start of the day, more if it gets done while someone is also greeting yesterday's late arrival. Across the week that is two to three hours of the busiest part of the day. The workflow does the compiling overnight effectively, so the host can spend the first thirty minutes of the day on the floor rather than at the desk. The real saving is the request that did not get missed.