Role guide · Hospitality ops · Gemini · Workspace · Oct 2026
Gemini for hospitality ops (Oct 2026): Sheets pickup reports, Docs SOPs, and Gmail group replies
Hospitality ops role guide for front-office, reservations, and revenue coordinators whose company runs on Google Workspace — Gemini lists pickup drops in a sanitized Sheet, turns approved policies into SOP drafts in Docs, and drafts group/event replies in Gmail. You check ten rows by hand before anyone changes a forecast, the revenue owner makes every rate change in the RMS/PMS, and a named person sends every guest or group email. Companion to ChatGPT for hospitality ops and Stack map for hospitality ops.
Who this guide is for
Front-office managers, reservations leads, revenue coordinators, and GMs — the person who exports pickup into a Sheet, keeps SOPs in a Doc, and emails group contacts — at a company that already pays for Google Workspace. If your PMS/RMS already flags pickup and drafts guest messages from live data, use that first: see Mews AI, Cloudbeds AI, Duetto AI, or Canary Technologies AI. If your team drafts in ChatGPT instead, see ChatGPT for hospitality ops.
What Google documents (its Gemini in Sheets, Gemini in Docs, and Help me write help pages and its pricing page, read 14 October 2026): in Sheets, the Ask Gemini side panel can create tables and formulas, analyze the sheet, and take actions such as conditional formatting, pivot tables, dropdowns, sorting, and filters, and Undo reverses an action. In Docs, Gemini shows edits as suggestions you accept or reject, and you can add your own files as Sources. In Gmail, Help me write drafts or polishes a message. Google's pricing page lists Gemini in Gmail on every Business plan, and Gemini in Docs and Sheets on Business Standard and above.
Ground rules for every section below: Gemini never sends a guest message, never changes or pushes a rate, never moves a room, and never posts a folio charge. It lists, drafts, and suggests; the revenue owner or FO manager makes each change in the PMS/RMS, and a named person sends each email. Work from sanitized exports — date, room type, pickup, occupancy — with no guest names, phone numbers, emails, folio details, card numbers, or passport / ID data. Hotel permits, occupancy taxes, and consent rules for messaging are local.
Major features (with how someone uses them)
Examples at a glance: each feature has a concrete example from a real job plus a short Try this you can run this week.
1. Pickup Sheet: week-over-week drops (primary)
What it is: Export recent pickup (or occupancy by date) from the PMS/RMS, open it as a native Google Sheet, and strip it down to stay date, room type, rooms sold / pickup, and occupancy — no guest names, no company names if they identify a VIP. Then open Ask Gemini and ask it to list dates where pickup dropped week over week. Before anyone changes a rate or sends a sales blast, check ten rows by hand against the export: pick some it flagged and some it didn't.
A pickup drop in the Sheet is a question, not a rate decision. The revenue owner knows whether a group block slipped or a channel closed — and makes any rate change in the RMS.
Primary workflow:
In a sanitized pickup Sheet, ask Gemini to list dates where pickup dropped week over week. Check ten rows by hand.
2. Occupancy Sheet: soft nights highlighted
What it is: From a sanitized occupancy Sheet — stay date, occupancy %, rooms available, and booking pace band — ask Gemini for a pivot of soft nights (for example under 70% occupancy) by day of week, then ask it to highlight dates inside 14 days. On your own copy, add a Manager decision column. Use Undo if an action touched the wrong rows. Insert the pivot into the Sheet; Google says side-panel history can be lost on reload.
The pivot shows where to look; it does not set rates. Floors and ceilings stay with the revenue owner.
Pivot, then decide:
On a copy of a sanitized occupancy Sheet, ask Gemini for a pivot of soft nights by day of week and add a Manager decision column. Undo anything that invents rates.
3. SOP drafts in Docs from approved sources
What it is: In Docs, add the approved sources — current front-desk SOP, emergency procedure, house rules — as Sources, and ask Gemini for a draft with the source under each step and a list of anything the sources do not cover. Google's Docs help page says Gemini shows edits as suggestions you accept or reject. The FO manager approves the final text before it reaches the desk.
Mark, don't fill. Ask Gemini to label any step it cannot tie to a source as Not in sources — manager to confirm.
Source every step:
Add your current front-desk SOP as a Source in Docs and ask Gemini for a checklist that names the source under every line. Confirm every line marked not in sources before it reaches the desk.
4. Group and event reply drafts in Gmail
What it is: For a group or event inquiry, draft with Help me write from sanitized facts you already confirmed in the PMS — dates, room block size, meeting room names, published package names — not from pasted guest card data. Open Sources, remove anything that pulled the wrong Drive file, and have a named reservations or sales person send the email.
Gemini drafts; humans send. Never paste passport scans, card numbers, or folio balances into Gmail prompts.
You send:
Draft one group reply with Help me write from sanitized PMS facts only. Open Sources, remove extras, check rates in the PMS, and have a named person send it.
5. Which Workspace plan includes Gemini in Sheets
What it is: As listed on 14 October 2026, Google's pricing page shows Business Starter at $7 per user per month, Business Standard at $14, and Business Plus at $22 (list prices; intro offers may also appear). Gemini in Docs and Sheets is on Business Standard and above; Gemini in Gmail is on all Business plans. Enterprise is via sales.
If your team is on Business Starter, pickup analysis in Sheets needs an upgrade path or another tool — check before you promise the workflow.
Check the plan grid:
Open workspace.google.com/pricing and confirm whether your hospitality leads are on Business Standard or above before you standardize on Sheets Gemini workflows.
6. Sanitized exports and privacy
What it is: Google's generative AI privacy page says Workspace data is not used for generative AI model training outside your domain without permission (confirm current language on Google's privacy page). That does not make it safe to paste guest PII. Keep passports, card numbers, and folio details out of prompts. If someone pastes guest PII, delete the copy, tell whoever owns guest data, and re-export a sanitized file.
Deleting a prompt does not undo an exposure. Guest records belong in the PMS and messaging tools under hotel policy.
Strip before you prompt:
Before any Gemini prompt, open your export and delete guest names, emails, phones, folio amounts, card data, and passport fields. Keep dates, room types, and counts only.
Pricing context (October 2026)
As listed on 14 October 2026 at workspace.google.com/pricing: Business Starter $7, Business Standard $14, Business Plus $22 per user per month (list). Gemini in Docs/Sheets requires Business Standard or above; Gemini in Gmail is on all Business plans.
Intro discounts may appear on the pricing page; budget from your invoice and the plan grid, not from memory.
Uncertainty: Workspace list prices and promo bands change. Confirm the live pricing page and your admin console before budgeting. Gemini suggests; it does not send guest mail or push rates.
When it’s useful (honest take)
Useful when your hotel already works in Google Workspace on Business Standard or above and the revenue owner will decide in the RMS.
Less useful when your PMS/RMS already owns pickup alerts (Cloudbeds AI, Duetto AI, Mews AI), or leads are stuck on Business Starter without Sheets Gemini.
Paying for Gemini and a few other AI tools? The $9 AI toolkit spreadsheet lists every AI subscription you have, what each one costs, and how fast it pays for itself, so you can see which ones are worth the money.
Want someone to do it for you? AI toolkit audit — $19
Related options (educational)
| Need | Better home | Why |
|---|---|---|
| Pickup lists in Sheets | Gemini for hospitality ops (this page) | Business Standard $14+ |
| SOP drafts in a Project | ChatGPT for hospitality ops | Business seats |
| Native RMS Autopilot | Cloudbeds AI | Plan quote |
| Hotel RMS suggestions | Duetto AI | Quote |
| Property-ops twin guide | Gemini for property ops | Workspace Standard+ |
FAQ
How should a hotel team start with Gemini?
Start with a sanitized pickup export in a native Google Sheet: stay date, room type, pickup, occupancy — no guest details. Ask Gemini to list dates where pickup dropped week over week and check ten rows by hand. The revenue owner makes any change in the RMS.
Can Gemini send group replies or guest messages for us?
Not in this guide. Gemini drafts with Help me write; a named person checks the facts in the PMS, opens Sources, reads the email, and sends it.
Which Workspace plan do we need for Gemini in Sheets?
As listed on 14 October 2026, Google's pricing page shows Gemini in Docs and Sheets on Business Standard ($14 per user per month), Business Plus ($22), and Enterprise, but not on Business Starter ($7), which gets Gemini in Gmail. Check workspace.google.com/pricing before budgeting.
Is our hotel data used to train Gemini?
Google's privacy page says Workspace data is not reviewed by humans or used for generative AI model training outside your domain without permission. That covers the company account; personal accounts have different terms. Still never paste guest PII.
What if someone pastes a passport scan or card number into a prompt?
Delete the copy, tell whoever owns guest data, and re-export a sanitized file. Deleting a prompt does not undo the exposure. Guest records belong in the PMS — the Sheet should hold dates, room types, and counts only.
Optional next step (if seats overlap)
If hospitality ops pays for Gemini, a chat assistant, a PMS with its own AI, and a messaging tool that all look at the same pickup and draft the same group replies, fix that overlap before adding another seat. Map the overlap with the $19 AI toolkit audit or the $9 AI toolkit spreadsheet. Email Audit $19 or Toolkit spreadsheet $9.
Checkout is live via Stripe. After you pay, we email delivery (spreadsheet) or intake next steps (audit).