# Gym Membership Management System – Google Sheets Apps Script

> Gym Membership Management System – Google Sheets Apps Script is a Google Apps Script web application that runs on your own Google account, sold with complete source code by Rameez Scripts. Gym management system in Google Sheets: member check-in, subscriptions, renewal reminders, dues and class booking. Full source code, setup video and support.

- Product page: https://rameezscripts.com/source-code/gym-management-system-google-sheets-appscript-dashboard
- Video demo: https://www.youtube.com/watch?v=lCvJpQwhCDw
- Category: Salon Gym & Wellness
- Stack: Google Apps Script + Google Sheets
- File code: F22
- Version: 1.0
- Price: One-time payment, full source code included — current price on the product page
- Seller: Rameez Scripts (https://rameezscripts.com)

## What it does

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.

## Features

- Member check-in straight from the dashboard by membership ID
- Live who-is-in-the-gym-now list with visit history and session duration
- Renewals due in 7 15 and 30 days surfaced on the dashboard
- Revenue over the last six months and peak-hour analysis
- Global search across leads members plans subscriptions payments and expenses
- Leads and enquiries with follow-up tracking
- Convert a lead to a member creating the login subscription and first payment in one step
- Custom username and password at conversion or auto-generated credentials
- Member 360 profile with active plan payments lifetime paid outstanding classes and attendance
- Membership plans with plan code class credits and unlimited option
- Subscriptions showing the member's prior membership history and dues before you sell
- Sell a subscription and collect payment in the same action
- Renew freeze hold or cancel a subscription
- Partial payment posting the balance as an outstanding credit
- Collect outstanding dues with an invoice generated automatically
- Classes with duration default capacity and description
- Class schedule with capacity versus booked and a printable timetable
- Session booking by member
- Expense tracking for the gym
- CSV import that skips records already present so migration is safe to repeat

## 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

## FAQ

### What happens when I convert a lead to a member?

One action creates the member record, generates their username and password, activates the chosen membership plan and records the first payment. You can set a custom username and password or let the system generate them.

### Can a member pay only part of the fee?

Yes. Enter what they actually paid and the remainder posts as an outstanding balance against their profile. Collect it later from the payments screen and an invoice is generated automatically.

### How do members check in?

Enter their membership ID on the dashboard or the check-in desk. The system shows who is currently in the gym, and checking out records the session duration in their visit history.

### Does it remind members before their membership expires?

Yes. Enable email automation in settings, set the time of day and how many days before expiry to send, and save — that installs a daily trigger which emails only the members matching the criteria.

### Can I stop a trainer deleting members?

Yes. The permission matrix covers view, add, edit and delete per module across owner, manager, trainer, receptionist and member. Untick delete on members for the trainer role and it applies straight away.

### Can I import my existing members and plans?

Yes. Leads, members and plans all have CSV import with a downloadable template. Records already present are skipped rather than duplicated, so you can re-run the import safely.

### Can members book classes?

Classes carry a duration and capacity, and the schedule shows booked against available seats. Bookings are made by picking the session and the member, and the timetable can be printed for the gym wall.

### Do I need hosting?

No. It runs as a Google Apps Script web app with Google Sheets as the database, inside your own Google account, with no monthly cost.

### What is Build a Gym Management System with Claude Code & Google Sheets?

Build a Gym Management System with Claude Code & Google Sheets is a ready-made Salon Gym & Wellness — a Google Apps Script web application that runs on your own Google account, sold with complete source code by Rameez Scripts (file code F22). 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…

### How much does Build a Gym Management System with Claude Code & Google Sheets cost?

Build a Gym Management System with Claude Code & Google Sheets is sold as a one-time payment with no monthly fees — the exact price is shown on this page. Buyers in Pakistan and India see regional pricing on this page.

### Do I get the complete source code of Build a Gym Management System with Claude Code & Google Sheets?

Yes. You receive the complete, unencrypted source code of Build a Gym Management System with Claude Code & Google Sheets, so you can host it yourself, modify any part of it and extend it for your own business.

### Is there a live demo of Build a Gym Management System with Claude Code & Google Sheets?

Yes — a full video demo of Build a Gym Management System with Claude Code & Google Sheets is on this page, walking through every feature and screen before you buy.

### Does Build a Gym Management System with Claude Code & Google Sheets include support after purchase?

Yes — every purchase includes 14 days of direct WhatsApp setup support from the developer, covering setup, installation errors and questions about the code.

### Can Build a Gym Management System with Claude Code & Google Sheets be customized for my business?

Yes. Rameez Scripts builds custom changes on top of Build a Gym Management System with Claude Code & Google Sheets — extra modules, your branding, integrations and reports — as a separate custom development service arranged on WhatsApp.

### How is Build a Gym Management System with Claude Code & Google Sheets delivered after payment?

As soon as your payment is confirmed, the source code and setup video of Build a Gym Management System with Claude Code & Google Sheets are delivered to your account and shared with you on WhatsApp.

## Contact

- WhatsApp: https://wa.me/923435347417
- Email: contact@rameezscripts.com
- Full catalog for AI assistants: https://rameezscripts.com/llms-full.txt
