Gym Management System with Claude Code & Google Apps Script

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 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 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. 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. Requirements A Google account (Gmail or Google Workspace). Google Sheets as the database — no server or MySQL needed. Google Apps Script web app deployment access. Gmail quota for membership expiry reminder emails. Authorisation of the Apps Script daily trigger for automated emails. Modern browser (Chrome, Edge, Firefox or Safari). What's Included Full Apps Script source code (Code.gs + index.html). Leads and enquiries with lead-to-member conversion. Members, membership plans and subscriptions. Payments, outstanding dues and invoicing. Classes, schedule and session booking. Check-in desk with visit history. Expenses and reports. Email reminder automation with installable trigger. Five preset roles with a live permission matrix. CSV import templates for leads, members and plans. Full video walkthrough. The AI prompt used to build the system. Free support and paid customization on request.

• Subscriptions that show the member's prior membership history and any dues before you sell them a ne
• Renew, freeze, hold or cancel an existing subscription.
• Classes with capacity, a schedule showing booked versus available, a printable timetable and per-ses