Gym management platforms handle check-in well and charge per member for the privilege, bundled with billing, bookings and an app. If you are a large gym that is a reasonable trade. If you run a small studio, a martial arts club, a dance school or a community class, you are paying for a booking platform to solve a register problem, and the practical alternative is a clipboard.
This guide covers the middle ground: a proper attendance record in a spreadsheet you own, without a per-member licence.
The free version, and its real limit
A Google Form linked to a Sheet costs nothing. Print a QR by the door that opens it, and members type or select their name and submit. It works, and for a class of twelve regulars it may be enough.
- Free with no cap on responses.
- Nothing to install for anyone.
- Every member needs a phone, signal, and the patience to fill a form while others queue behind them.
- Members can submit for anyone, including people who are not there.
- No practical way to enforce a class cap or count sessions on a pass.
The queue is the thing that kills it. Twenty people each filling a form at the door before a class starts on the hour does not work, and they will stop bothering within two weeks.
Scanning at the desk instead
We build a tool in this category, so treat this as informed. Inverting the direction fixes the queue: one device at the desk scans each member's code as they walk past, which takes about a second per person and needs nothing from the member but their card.
The pricing shape is the reason this works for a small studio. QR to Sheets is free for 300 scans, one link and one device, then $7 per registered device per month with unlimited scans. One desk device is $7 regardless of whether you have forty members or four hundred. Per-member platforms scale their price with your membership list, which is exactly backwards when the membership list is the thing you are trying to grow.
| Capability | Google Forms / Apps Script (DIY) | QR to Sheets |
|---|---|---|
| Pricing basis | Free | Per scanning device |
| Cost at 200 members | Free | $7 per month, one desk device |
| Check-in speed | Form fill per person | One scan per person |
| Member app needed | No | No |
| Works when wifi drops | No | Yes, syncs later |
| Attendance by class | Only if they select correctly | One link per class |
| Where data lives | Your Google Sheet | Your Google Sheet |
What it will not do
Being clear about this saves you an evaluation. A scanner writing to a spreadsheet is a register, not a gym platform.
- It does not take payments or manage recurring billing.
- It does not stop an expired member scanning in — it records that they did, and your formula flags it.
- It does not hold class bookings or a waitlist.
- It does not enforce a class cap at the door; it tells you afterwards that you exceeded one.
If you need bookings and payments, buy a gym platform. If you have those solved and only need to know who actually turned up, a register in your own Sheet is a much smaller and cheaper problem.
Making the data answer business questions
- Attendance per class per week, to decide what stays on the timetable.
- Visits per member per month, which is the strongest early warning of a cancellation.
- First visit versus last visit, to find members who quietly stopped coming.
- Peak hours by day, for staffing.
- Sessions used against a pass, so a ten-pack is actually enforceable.
All of these come from one append-only log with a timestamp, a member ID and a class. Keep one row per scan and never edit it; derive everything else with a pivot table.
Privacy
Attendance records tie a named person to a place and a time, which makes them personal data. Encode member IDs rather than names on anything a member carries, keep the Sheet in a business account rather than a personal one, decide how long you keep the log, and be able to tell a member what you hold about them. Health and injury notes do not belong in the same sheet as a check-in log.
Step by step
- 1
Give every member a code once
A QR on a membership card, a printed keyring tag, or an image you email them to keep on their phone. Encode a member ID, never a name — a lost card should not identify anyone.
- 2
Put one phone or tablet on the desk
One device at the entrance, with the scanner link open. The member presents their code, the desk scans it, the row appears in your Sheet. No queue at a keypad.
- 3
Record the class, not just the visit
A separate scanner link per class or per room means the sheet tells you which sessions are full and which are not worth running, which is the number that changes your timetable.
- 4
Derive attendance limits with a formula
Class caps, remaining sessions on a ten-pack, and lapsed memberships are all lookups against the log. Do not try to make the scan itself enforce them.
- 5
Review the timetable monthly
The whole reason to record this is to see which classes justify their slot. Look at the pivot once a month or the data is just tidy for its own sake.
Frequently asked questions
Can I do gym check-in without a member app?+
Yes. Give each member a QR code on a card, keyring tag or phone image, and scan it at the desk with one device. Members install nothing and create no account; only the desk device runs anything.
How much does this cost compared with gym software?+
Gym platforms typically charge per member, so the cost grows with your membership. A per-device scanner link is $7 per month for one desk device whether you have forty members or four hundred. The trade-off is that it is a register, not a booking and billing platform.
Will it stop an expired member from checking in?+
No, and no spreadsheet-based approach should claim to. It records the scan and a formula in your Sheet flags that the membership has lapsed. If you need enforcement at the door, you need access-control hardware or a full platform.
Can I see attendance broken down by class?+
Yes, if you use a separate scanner link per class or per room. Each link writes the same Sheet with its own identifier, so a pivot table gives you attendance per session — which is the number that tells you what to keep on the timetable.
What happens when the studio wifi drops?+
A Google Form loses the submission. A tool that saves scans on the device keeps working and syncs when the connection returns, which matters because studio wifi and basement gyms are unreliable in exactly the same way.
Is a paper register really so bad?+
For attendance alone, paper works. It fails when you want to answer questions — which classes are underused, which members stopped coming, when the drop-off started. Those need data you can pivot, and transcribing paper into a spreadsheet later is the step nobody actually does.