A token and queue management system for anywhere people wait in line. Customers register at a form or kiosk, get a token, and watch a display screen for their number. Operators call the next person from their counter. Admins configure the services and the counters. All of it on Google Sheets with a React front end.
The dashboard shows every counter at once with its current state, and the auto-assignment algorithm routes the next waiting person to whichever counter frees up first. That is the whole point of a queue system — one line feeding several desks beats several lines where one moves and the others do not.
Behind them sits the admin panel with full CRUD on counters, service categories and staff accounts, all gated by role-based access control.
Not every counter handles every task. Services are defined as categories, customers choose theirs at sign-up, and the routing respects it — so a person needing one service is not sent to a desk that cannot help them. Waiting list management shows live position, and the status updates as tokens move.
Clinics and hospital departments managing patient flow, bank branches and service counters, government and municipal offices, retail service desks, and any office that has people waiting and more than one person serving them.
Copy the sheet, deploy the script, define your counters and services. The display screen is just the web app on a second monitor or TV, and the interface is responsive across phone and display. No hardware, no server and no per-counter licence. The video walks through every screen, and support is free if you get stuck.
| Version | v1.0 |
| Published | Dec 16, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Booking & Appointments, Tools & Utilities |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
What We Customize
20-30% advance to start • Clear quote before work begins • Support included after delivery
What buyers of this file added to the same order
What buyers and viewers say about How to Build Advanced Public Queue System with Google Sheet & Apps Script | D48.