Hotel Management System with Food Orders – Google Sheets

A property management system for a small hotel or guest house, running on Google Sheets: the front desk, the kitchen, housekeeping and the billing, each with its own screen, all reading one set of rooms.

The front desk

Rooms carry a live status you can read as a Kanban board or an interactive calendar — who is in, what is free tonight, what is being cleaned. Reservations, group bookings and walk-ins are all handled, guests are checked in and out with their ID card photographed front and back into Drive, and anyone you cannot fit goes onto a waitlist instead of being lost.

The kitchen and the floor

A food menu with ordering and a cart lets guests' orders reach a kitchen dashboard that announces new ones with a voice alert — the difference between a screen somebody remembers to look at and one that tells them. Cleaning requests raise on the housekeeping dashboard as a priority queue, and staff are assigned to rooms.

Getting paid

Quotes are generated and can be converted straight to invoices — no retyping when a booking is confirmed. Both print with a preview and email to the guest. Payment methods are configurable, partial payments are supported, and transaction history stays attached to the booking.

The rest of it

A public hotel landing page showcases rooms with images and pricing, so the system carries the front of the business as well as the back. Behind the desk: an AI chat assistant on Google Gemini, OTP password reset, activity logging with an audit trail, and Drive-hosted images throughout.