How to run event registration and QR check-in with a Google Sheet
Sign-ups into a Google Sheet, a QR code per registrant, check-in at the door with any phone camera. The free Google Forms route first, and where it stops.
Short answer
You can run registration and check-in around one Google Sheet by collecting sign-ups with a form that writes each submission as a row, then generating a unique QR code for every registrant and scanning it at the door.
Google Forms handles the sign-up half for free but cannot issue a per-person QR code or record arrivals, so the check-in half needs either an Apps Script build or a tool that does both.
QR to Sheets does both in one workspace: the form writes the sign-up row to your Google Sheet and emails the registrant their QR code, and the door scan records the arrival time in QR to Sheets, not the sheet. It costs 7 USD per scanning phone per month.
Event registration and event check-in are usually sold as two products. You collect sign-ups in one tool, export a list, import it into a second tool, and hope the two agree on the day. The join between them is a CSV, and the CSV is where the errors live: a name spelled differently, a late registrant who never made it into the second export, a duplicate that shows as two people.
It does not have to work that way. If the sign-up writes straight to your Google Sheet and the QR code is issued by that same submission, there is no export and no import: the code at the door is the registration itself, so a late registrant cannot be missing from the door list.
The free route: Google Forms
Start here, because for a lot of events it is genuinely enough and it costs nothing. Google Forms collects the sign-up, writes each response to a linked Google Sheet, and can email a confirmation with Apps Script. If all you need is a list of who intends to come, stop reading and use Forms.
Where it stops is the door. Google Forms has no concept of a per-person code, and no way to record that a specific registrant arrived. To get from a response row to a scannable check-in you have to build three things yourself in Apps Script: generate a unique token per response, render it as a QR image and attach it to the confirmation email, and then build a second surface that reads a scanned token and writes an arrival back to the right row.
That is a real weekend of work, and it is the fragile kind. The Apps Script quota on a consumer account limits how many emails you can send per day. The QR image needs hosting somewhere that will still be up on the morning of the event. And the scanning surface has to work on a phone belonging to a member of staff who has never seen it before, on venue wifi, without you standing next to them.
What the paid route buys you
The honest answer, for QR to Sheets Forms: the three things above, already built and already tested, plus the thing nobody thinks about until it goes wrong — retries. A confirmation email that fails to send is retried automatically rather than silently lost, which matters when the email is the only copy of the QR code the registrant has. If your guest list already lives in a Sheet rather than a form, QR event check-in from a guest list covers that route.
| Capability | Google Forms / Apps Script (DIY) | QR to Sheets |
|---|---|---|
| Collect sign-ups to a Google Sheet | Yes, and it is free | Yes |
| Unique QR code per registrant | Apps Script build: generate a token, render an image, host it | One toggle; the code appears on screen and in the email |
| Record who actually arrived | Not supported; needs a second Apps Script surface | Scan the code with any phone camera; the arrival is kept in QR to Sheets, not written to your sheet |
| Design the form in your own colours | Limited themes | Full colour control, or one of eight ready palettes |
| Embed on your own landing page | Yes, iframe | Yes, iframe or an auto-height snippet |
| Change fields after sign-ups have started | Yes, but old responses keep the old columns | Yes; each response stores the fields as they were at the time |
| Trigger Zapier or Make on each sign-up | Apps Script trigger | Paste a webhook URL |
| Cost | Free, plus your build time and Apps Script quotas | 7 USD per scanning phone per month; free for 1 form and 10 submissions |
Disclosure: this guide is published by QR to Sheets, so treat the right-hand column as a vendor claim and the left-hand one as the honest free alternative. If Google Forms covers your event, use Google Forms.
Designing a form people finish on a phone
Almost every registration is completed on a phone, often in a few seconds of spare attention. Two practical consequences. First, every optional field measurably costs you completions, so ask for what you will actually use at the door and nothing else. Second, put the email field early: it is the field that carries the QR code, so a form abandoned after the email is still recoverable, while one abandoned before it is not.
If you need a session, a ticket type or a dietary requirement, a dropdown beats free text every time. A dropdown gives you values you can filter on; free text gives you forty spellings of the same thing. A session picked on a form is not a session attended, though; per-session attendance with badge scans covers recording who was actually in each room.
The four details that catch people out
Set the timezone to the venue
If you are organising from another city, set the workspace timezone to where the event actually is. Otherwise the arrival timestamps read in your time, and the 9am rush looks like it happened at 5am.
Count phones, not staff
Scanning is licensed per phone that scans, not per person on your team. Two hostesses sharing one phone is one licence. One hostess with a work phone and a personal phone is two, if she scans on both.
Send one test registration before you publish
Register yourself, receive the email, and scan your own QR code at the door you will actually use. It takes two minutes and it is the only rehearsal available. Do it from the phone the staff will use, on the venue wifi if you can.
Decide what a second scan means
Someone will present the same code twice — they stepped out for a call, or a colleague scanned them already. Scanning again reports the original arrival time rather than overwriting it, so your record of when they actually got there survives an honest mistake at the door.
Reconciling registered against arrived
Be clear before the event about what lands where. The registration rows are in your Google Sheet. The arrival is confirmed at the door on the check-in page, which records the time in QR to Sheets and shows the original time if the code is scanned again, but it is not written back to your sheet.
So on this route, registered against arrived is not a formula over your sheet. If you need both facts as columns in one spreadsheet, for a no-show rate or a list of who did not come, the QR to Sheets Events add-on does that: it imports a guest list from a Google Sheet, emails each guest a code, and writes every check-in back to that guest's row. It costs 25 USD per month on top of a paid plan.
Neither route keeps a live currently-inside count for you. Where the arrivals are in your sheet, through the Events add-on or your own Apps Script build, that count is a COUNTIF over the arrival column, and it belongs in your spreadsheet where you can see how it is calculated.
When this is the wrong tool
If you are selling tickets, you want a ticketing platform: payment, refunds, seat allocation and transfers are a different problem, and per-ticket fees buy you real infrastructure. If your event is free and your question is simply who signed up and who turned up, a form plus a QR code plus your own spreadsheet is the whole job. Our event check-in apps comparison puts the ticketing, add-on and form routes side by side with their prices.
Exhibitors scanning visitor badges at a stand have a different job: the badge already holds a code, so there is nothing to register. See trade show lead capture into Google Sheets.
Step by step
- 1
Decide what you need at the door
A name on a list is enough if you only need a headcount. If you need to know who actually turned up, and when, then every registrant needs something unique to present — which is what the QR code is for.
- 2
Build the registration form
Start with name, email and phone, then add only what you will genuinely use on the day. Every field you add is a field a person fills in on a phone, often while standing up.
- 3
Point the form at your Google Sheet
Sign-ups should land in a spreadsheet you own, not in a vendor dashboard you have to export from later. One row per registrant, timestamped in your own timezone.
- 4
Turn on the per-submission QR code
Each registrant gets their own code on the confirmation screen and in their confirmation email. Save-to-phone or print both work; there is nothing for them to install.
- 5
Scan arrivals at the door
Any phone camera opens the code, which shows door staff the registrant's name and contact details, and one tap on Check in records the arrival time. The arrival is recorded in QR to Sheets rather than written to your sheet, and scanning the same code again shows the original arrival time.
- 6
Decide where the arrival record has to live
Your sheet holds who registered. The arrival is confirmed on the check-in page and kept in QR to Sheets, not written back to the sheet, so if you need registered and arrived as two columns in one spreadsheet, choose that route before the day.
Frequently asked questions
Can each sign-up go straight into my CRM instead of just a spreadsheet?+
Yes, and this is usually the reason a business outgrows a free form builder. Once you add a webhook URL, every submission fires an HTTPS webhook the moment it is submitted, so the registration reaches your CRM, Slack or email tool in real time rather than after an export. Paste a Zapier, Make or n8n catch hook and route it to HubSpot, Salesforce, Pipedrive or anything those tools reach. Each field arrives keyed by both its id and its visible label, dropdown answers included, so the automation shows readable names rather than raw ids. A delivery that fails is retried with backoff, so a brief outage on your side delays the lead rather than losing it. Google Forms can do something similar with an Apps Script trigger, but you are writing and maintaining the script yourself.
Can I use Google Forms for the sign-up and something else for check-in?+
Yes, and it is a reasonable split. The friction is the join: you export the Forms responses and import them into the check-in tool, and anyone who registers after that export is missing at the door. If sign-ups close well before the event, this works fine. If people register on the day, you will feel it.
Does each registrant need an app to show their QR code?+
No. The code appears on the confirmation screen and in the confirmation email, so a screenshot, the email itself or a printout all work. The staff scanning it use a phone camera, not an app.
What if a registrant never receives the confirmation email?+
The QR code is also shown on screen immediately after they submit, so most people already have it. A failed send is retried automatically rather than dropped, and you can see which submissions have not been delivered.
Can two people check in with the same QR code?+
The code records one arrival. Scanning it a second time reports that this person already arrived, and shows the original arrival time rather than replacing it, so a duplicate scan at a busy door cannot corrupt the record.
Can two people register with the same email address?+
Yes. On a QR to Sheets form with "Generate a QR code for each submission" turned on, each submission gets its own QR code, so two people who submit separately with one address each have a code of their own. If you are inviting from a guest list instead, the Events add-on (25 USD a month on top of Premium) gives every row its own code when you choose a ticket or attendee number as the Guest ID column. Without one, it treats each email address as one guest.
Can I add a field after people have started registering?+
Yes. Add, reorder, hide or delete fields at any time; responses already collected keep the fields as they were when they were submitted, so your history stays readable rather than being reinterpreted by the new layout.
How much does this cost for a 200-person event?+
Cost is driven by scanning phones, not attendees. Two phones on the door is 14 USD for the month regardless of whether 200 or 2,000 people register. There is no per-attendee or per-ticket fee.