Gym Membership Management System – Google Sheets Apps Script
- Google Sheet link
- Source code file
- Resale rights
- Edit rights
- Setup guide
- AI setup help
- AI prompts used to build it

Mohammad Rameez Imdad
Founder of Rameez Scripts. I build these systems myself and help you set them up.
- 33K+YouTube subscribers
- 348+free tutorials
- 4+ yrsbuilding since 2022
Key Features
Description
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.
Requirements 6
- 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 13
- 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
Item Details
| Version | v1.0 |
| Published | Aug 11, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Salon Gym & Wellness |
| Video | Watch walkthrough |
| License | Regular License |
Need this customized for your business?
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
20–30% advance to start · Clear quote before work begins · Support after delivery
What we customize
- Features & functionsNew features, changes to existing scripts, custom formulas and automations
- API & integrationsWhatsApp, payment gateways, CRM and more
- Design & UI changesYour branding, layout redesign, dark mode, mobile layout
- Full custom projectsDashboards, billing, inventory, CRM, built from scratch
People choose these
What buyers of this file added to the same order
Vibe Coding Just Got FREE: This AI Builds Full Apps AND Dashboards From One Prompt (Google Sheets)
7 buyers took both
How to Build a Full HR & Payroll ERP with Google Apps Script and React | Salary Slip + Attendance
6 buyers took both
I Built a Salon Management System with ERP + CRM Dashboard & Web App - Google Sheets + Apps Script
6 buyers took both
Reviews & Feedback
What buyers and YouTube viewers say about this project.