If you run a small gym or want to sell automation services to local gym owners, this system will save a lot of time and money.
The idea is simple. Keep all member data in one Google Sheet. Let n8n handle the boring daily work — new member entry, expiry reminders on WhatsApp, payment status updates, and a daily report for the owner.
This guide shows you exactly how to build the full system step by step. No heavy coding is required. You only need to copy-paste a few small JavaScript snippets.
Who This Is For?
- Beginners who know how to open Google Sheets but have never built automation
- Freelancers who want to sell simple automation services to gyms, coaching centres, or salons
- Gym owners or managers who want to stop tracking renewals manually
What You Will Build
Four connected workflows:
- New Member Entry – Form se details aate hi Google Sheet mein row ban jati hai
- Expiry Reminder – Roz subah system check karta hai aur jo members expire hone wale hain unhe WhatsApp message bhejta hai
- Payment Update – Payment hote hi status “Paid” ho jata hai aur expiry date aage badh jati hai
- Daily Report – Owner ko roz active, expired aur pending payments ki summary milti hai
Tools You Need
1. n8n
- Cloud Starter (around €20–24/month) – easiest for beginners
- Cloud Pro – if you handle multiple gyms
- Self-hosted Community Edition – free software, but you manage the server
For one gym, the free trial or Starter plan is usually enough because the heavy workflows (reminder + report) run only once a day.
2. Google Account
Create a fresh Google account in the gym owner’s name. This keeps the data with the client.
3. WhatsApp Business Platform (Cloud API)
This is the official way. You need Meta Business verification and approved message templates. Unofficial WhatsApp web wrappers are risky and can get the number banned — avoid them.
4. Razorpay (optional but recommended)
For online payments. If the gym only takes cash/UPI, there is a simple form-based alternative.
Google Sheet Design (The Heart of the System)
Create a Google Sheet named “Gym Manager” with two tabs.
Tab 1: Members
Exact column headings (do not change the spelling later):
- member_id
- name
- phone (format: 919876543210 — no + or spaces)
- plan
- plan_months
- fee
- start_date (YYYY-MM-DD)
- expiry_date (YYYY-MM-DD)
- payment_status (Pending / Paid)
- last_payment_date
- last_reminder_date
- last_payment_ref (add this later for payment tracking)
Important rule: Format all date columns as Plain Text. This prevents date comparison errors in n8n.
Tab 2: Dashboard (only formulas)
Example formulas (adjust column letters if needed):
- Total members →
=COUNTA(Members!A2:A) - Active members →
=SUMPRODUCT((Members!H2:H<>"")*(Members!H2:H>=TEXT(TODAY(),"yyyy-mm-dd"))) - Expired members →
=SUMPRODUCT((Members!H2:H<>"")*(Members!H2:H<TEXT(TODAY(),"yyyy-mm-dd"))) - Pending payments →
=COUNTIF(Members!I2:I,"Pending")
Workflow 1: New Member Entry
Flow: Form Trigger → Code → Google Sheets (Append or Update Row)
- Create a new workflow named “1 – New Member Entry”.
- Add Form Trigger. Fields: Name, Phone, Plan (dropdown), Fee, Start Date.
- Add Code node and paste this:
const planMonths = { 'Monthly': 1, 'Quarterly': 3, 'Half-yearly': 6, 'Yearly': 12 };
function addMonths(isoDate, months) {
const [y, m, d] = isoDate.split('-').map(Number);
const total = (m - 1) + months;
const ny = y + Math.floor(total / 12);
const nm = total % 12;
const lastDay = new Date(Date.UTC(ny, nm + 1, 0)).getUTCDate();
const nd = Math.min(d, lastDay);
return ny + '-' + String(nm + 1).padStart(2, '0') + '-' + String(nd).padStart(2, '0');
}
return $input.all().map(item => {
const f = item.json;
let phone = String(f['Phone']).replace(/\D/g, '');
if (phone.length === 10) phone = '91' + phone;
const months = planMonths[f['Plan']] || 1;
const start = String(f['Start Date']).slice(0, 10);
return {
json: {
member_id: 'GYM-' + String(Date.now()).slice(-6),
name: f['Name'],
phone: phone,
plan: f['Plan'],
plan_months: months,
fee: f['Fee'],
start_date: start,
expiry_date: addMonths(start, months),
payment_status: 'Pending'
}
};
});- Google Sheets node → Append or Update Row → match on phone column (prevents duplicates).
- Test the form, then publish and bookmark the production URL for the front desk.
Workflow 2: Expiry Reminder
Flow: Schedule Trigger → Google Sheets (Get Rows) → Code (filter) → WhatsApp (Send Template) → Google Sheets (Update Row)
First create and get approval for a WhatsApp Utility template, for example:
Namaste {{1}}, aapki gym membership {{2}} ko khatam ho rahi hai. Renew karne ke liye gym par aayein ya hamse sampark karein. Dhanyavaad!
Schedule the workflow daily at 9 AM (timezone: Asia/Kolkata).
Filter code (sends only on day 3 and day 0, and only once per day):
const REMIND_DAYS = [3, 0];
const today = new Date().toLocaleDateString('en-CA', { timeZone: 'Asia/Kolkata' });
function toUtc(iso) {
const [y, m, d] = iso.split('-').map(Number);
return Date.UTC(y, m - 1, d);
}
return $input.all().filter(item => {
const r = item.json;
if (!r.expiry_date || !r.phone) return false;
if (r.last_reminder_date === today) return false;
const daysLeft = Math.round((toUtc(r.expiry_date) - toUtc(today)) / 86400000);
return REMIND_DAYS.includes(daysLeft);
});Always get consent (add a checkbox in the registration form).
Workflow 3: Payment Update
Two options:
Option A – Razorpay Payment Links (recommended)
Webhook → IF → Code → Google Sheets → Code → Google Sheets (Update)
When payment is successful, the system marks the member Paid and extends the expiry date correctly (handles both active and already-expired members, and prevents double processing).
Option B – Cash / UPI
Simple Form Trigger where the owner just selects the member and confirms payment. Same update logic runs.
Add a last_payment_ref column so the same payment is never processed twice.
Workflow 4: Daily Owner Report
Flow: Schedule Trigger → Google Sheets → Code → Email (or WhatsApp)
Code that generates the summary:
const today = new Date().toLocaleDateString('en-CA', { timeZone: 'Asia/Kolkata' });
const rows = $input.all().map(i => i.json).filter(r => r.member_id);
const active = rows.filter(r => r.expiry_date >= today);
const expired = rows.filter(r => r.expiry_date && r.expiry_date < today);
const pending = rows.filter(r => r.payment_status === 'Pending');
const names = list => list.length ? list.map(r => r.name).join(', ') : 'Koi nahi';
const text =
'Gym report ' + today + '\n' +
'Active members: ' + active.length + '\n' +
'Expired memberships: ' + expired.length + ' (' + names(expired) + ')\n' +
'Pending payments: ' + pending.length + ' (' + names(pending) + ')';
return [{ json: { date: today, active: active.length, expired: expired.length, pending: pending.length, text } }];Start with email — it is simpler and does not need a WhatsApp template.
Testing, Errors & Privacy
- Always test on a dummy sheet with your own numbers first.
- Create an Error Trigger workflow so you get notified if something fails.
- Keep the sheet in the gym owner’s Google account.
- Take proper WhatsApp consent.
- Never share the sheet publicly.
How to Sell This Service?
You are not selling n8n or Google Sheets. You are selling:
- Time saved every day
- Fewer missed renewals
- Clear view of pending payments
- Professional WhatsApp reminders
Suggested pricing example:
- Setup fee: ₹10,000 – ₹15,000 (one-time)
- Optional monthly maintenance: small fixed amount
- Running costs (n8n + WhatsApp messages) stay on the client’s accounts
Do a clean 10-minute live demo with a dummy sheet. Show new member entry, a real reminder arriving on your phone, payment update, and the daily report.
Final Checklist
- n8n ready (Cloud or self-hosted)
- Google Sheet with correct columns + Dashboard
- Dates in YYYY-MM-DD plain text
- All 4 workflows built and tested
- WhatsApp template approved
- Consent checkbox in form
- Error Trigger set up
- All workflows published + Asia/Kolkata timezone
- Client has ownership of accounts + handover document
This system works.
Build it once for yourself with 5–10 fake members.
Once it runs smoothly for a week, start showing it to gym owners in your city.




