All guides
Membership guide

Gym, studio and class check-in with QR codes and Google Sheets

Class and membership check-in in a Google Sheet you own: no member app, no per-member licence, and scans wait on the phone if the studio wifi drops.

By the QR to Sheets team 10 min readUpdated

Short answer

Gym and class check-in works by giving each member a QR code holding a member ID, then scanning it at the desk with one device so each visit appends a row to a Google Sheet.

A free Google Form linked to a Sheet costs nothing but creates a queue, because twenty people each filling a form before a class starts on the hour does not work in practice.

A register in a spreadsheet does not take payments, hold bookings, or stop a lapsed member scanning in; it records the visit and a formula in the Sheet flags the problem afterwards.

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.

Is a free Google Form enough for gym check-in?

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, up to 500,000 responses per form.
  • 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. A tablet left at the desk works too; a QR check-in kiosk on a shared tablet covers that setup.

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 phone 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.

Google Forms / Apps Script (DIY) compared with QR to Sheets
CapabilityGoogle Forms / Apps Script (DIY)QR to Sheets
Pricing basisFreePer scanning phone
Cost at 200 membersFree$7 per month, one desk device
Check-in speedForm fill per personOne scan per person
Member app neededNoNo
Keeps scans when wifi dropsNoYes, while the scanner is open; sent when signal is back
Attendance by classOnly if they select correctlyOne link per class
Where data livesYour Google SheetYour 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. If members scan twice by accident, handling duplicate QR scans shows how to count each visit once.

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

Try it on your own Google Sheet

Connect Google, create a scanner link, and open it on the phone that will scan. Have that phone at hand: setup takes a few minutes and ends with your first row in the Sheet. Free covers 300 scans on one phone, and the people you scan never install anything.

Start for free

No credit card required

Taking attendance? See QR code attendance: who holds the phone, what is free, what a second phone costs

A second door, booth or classroom is a second phone

Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).

How many phones will scan at the same time?

$7 x 2 = $14 a month

Sign in with Google and, on the free plan, the billing page opens with this choice. Nothing is charged until you confirm the card checkout, and you can change the number of phones later.

Keep reading