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.