Booking System for Fitness Studios — Free, AI-Built
Every fitness studio owner knows the 6am math problem. The class caps at twelve. Fifteen people have claimed a spot across a group text, two DMs, and one shouted commitment after Thursday's session. Come Monday, eleven show up — including one who was never on any list — while two people who begged for spots sleep straight through them, and the member who got told "class is full" watches an empty bike appear on the studio's story.
A strength studio owner in Columbus was running exactly this: a Google Sheet holding the weekly timetable, a group text for signups, and her own memory for the waitlist. The sheet part worked — coaches checked it, PT sessions sat right alongside classes. The broken part was everything between a member's "I'm in" and a row in that sheet.
Booking platforms exist for this, priced per coach or per location with member caps at every tier. There's a cheaper route: keep the timetable sheet and let AI build the member-facing booking layer on top of it, free.
Step 1: The Timetable Sheet
Three tabs handle most studios:
- Timetable — every class and PT slot for the week
- Roster — who's booked into what
- Members — membership type, drop-in credits, contact info
The Timetable tab looks like this:
| Class/Session | Coach | Date/time | Capacity | Booked | Waitlist | Type | Room |
|---|---|---|---|---|---|---|---|
| 6am Strength | Leah | Mon Jul 27, 6:00 | 12 | 12 | 3 | Class | Main floor |
| Reformer Flow | Sam | Mon Jul 27, 9:30 | 8 | 5 | 0 | Class | Studio B |
| Squat technique | Leah | Mon Jul 27, 11:00 | 1 | 1 | 0 | PT | Rack 2 |
Capacity, Booked, and Waitlist are the columns that end the group-text era: once Booked equals Capacity, the class is full — mathematically, not socially.
Step 2: Sign Up (the Free Tier Is Enough)
A free account at lovespreadsheets.com covers the whole build and daily operation. Paying unlocks your own domain — book.yourstudio.com — and staff logins, neither required on day one.
Step 3: Write the Studio's Rules in Plain English
Pick the Website template. For texts — your weapon against 6am ghosting — set up Twilio and keep three values handy: the Account SID, the Auth Token, and a WhatsApp-enabled number. Figure roughly a penny per message.
Then describe how your studio actually operates:
"Members see this week's timetable and tap a class to reserve a spot. Never let a class go past its Capacity number — when it's full, new names go to the Waitlist column in order. PT sessions are different: those are one-on-one, so show Leah's open PT slots separately and book them like appointments, not classes. Every reservation writes a row to the Roster tab and bumps the Booked count."
Studio-specific asks worth making:
- Automatic waitlist promotion — when someone cancels the 6am, the first name on the waitlist inherits the spot and gets a text saying so, without anyone at the studio touching a thing
- Two flows, one page — group classes with capacity counts and solo PT bookings shouldn't share a form; members grab a class off the grid, PT clients pick a time off a calendar
- Reminders tuned for the 6am problem — an 8:30pm text the night before with a one-tap cancel link turns silent no-shows into open spots the waitlist can absorb
Hit AI Optimize if the description feels loose, field a clarifying question or two, and roughly twenty minutes later the page exists.
Step 4: A Monday That Runs Itself
Sunday evening, members open the link from your bio and grab their week. The 6am fills to twelve, three more join the waitlist, and everyone can see exactly where they stand — no DMs required. At 8:30 someone bails via their cancel link; the top waitlisted member learns she's in before she's picked a bedtime.
The sheet stays the studio's source of truth throughout. Cancel Thursday's Reformer Flow by deleting its row and it's gone from the booking page instantly; every reservation flows the other way as a Roster row your coaches read at the front desk.
Why Studio Owners Keep the Sheet
Capacity becomes law instead of etiquette. Thirteen people can promise to come; only twelve can book. The overflow lands in an ordered waitlist, not in your DMs.
Coaches already live in the sheet. Leah checks tomorrow's roster in the same place she always has — it just fills itself now.
No per-member pricing tiers. Class-booking platforms price by member count or coach count. A spreadsheet's row limit is not a business model.
Common Questions from Studio Owners
How do memberships vs drop-ins work? Keep the type in the Members tab and describe the rule — unlimited members book anything, drop-ins burn a credit per class and get told when they're out. The page enforces whatever you write.
Can I cap how far ahead members book? Yes — "classes open for booking seven days out" is a one-sentence rule, and it stops September's 6am from filling in July.
What if I change a class time in the sheet? The booking page updates immediately, and you can ask the system to text everyone on that roster about the change rather than hoping they notice.
Build Yours
The timetable in your sheet is already the studio's real schedule — it's just invisible to members. Bring it to lovespreadsheets.com, describe your caps and your waitlist rules, and by tomorrow's 6am the class fills, closes, and backfills itself.
The team turning other people's spreadsheets into software they actually trust — one sheet at a time.
