Build a Gym Management System with Claude Code & Google Sheets

A gym membership management system running on Google Sheets — leads, members, plans, subscriptions, payments, classes and check-ins in one dashboard, with the check-in desk built right into the home screen so the person on reception never leaves it.

What it does

An enquiry starts as a lead. When they sign up, converting the lead creates the member record, generates their username and password, activates the membership plan and takes the first payment — in a single step. If they pay part of the fee, the balance posts as outstanding and shows on their profile until it is collected. Each member then carries a 360 view: active plan, payments, lifetime paid, outstanding balance, classes booked and gym attendance.

The dashboard is the product

Type a membership ID and the member is checked in. The dashboard shows who is in the gym right now, revenue over the last six months, peak hours, active members, and — the number that actually drives a gym's revenue — renewals falling due in the next 7, 15 and 30 days. A global search reaches across leads, members, plans, subscriptions, payments and expenses at once.

Highlights

• Subscriptions that show the member's prior membership history and any dues before you sell them a new plan
• Renew, freeze, hold or cancel an existing subscription
• Classes with capacity, a schedule showing booked versus available, a printable timetable and per-session booking
• Check-in desk with check-out and a visit history recording time spent
• Email automation on a daily trigger, reminding members a set number of days before their plan expires
• CSV import that skips records already present, so migrating from an old system is safe to re-run
• Five roles — owner, manager, trainer, receptionist, member — with a live permission matrix

Who it is for

Independent gyms, fitness studios and training centres that are tracking memberships in a spreadsheet and losing renewals because nobody sees them coming.