All guides
Registration guide

How to give every form submission its own QR code for check-in

Give every form submission its own QR pass: the free Google Forms plus Apps Script route, where it stops, and how to issue, deliver and scan a unique code.

By the QR to Sheets team 10 min readUpdated

Short answer

A form submission gets its own QR code when the form generates a unique token for that response and encodes it in an image shown on the confirmation screen and emailed to the person, which is then scanned at the door to record their arrival.

Google Forms cannot do this on its own because it has no way to generate a per-response image, so the free route needs an Apps Script that builds a QR URL and emails it after each submission.

QR to Sheets Forms issues every submission its code on screen and by email and writes the sign-up to a Google Sheet; the arrival is recorded in QR to Sheets, not the sheet. It is included in Premium, from 7 USD a month, after a free trial of 10 submissions.

There are two halves to any registration workflow: collecting who is coming, and recording who actually turned up. Most tools do one or the other well. A form collects names into a spreadsheet; a ticketing platform issues passes but wants to own the whole event and take a cut. The gap in the middle is where most small events sit, from a club meetup to a school open day with registered families and walk-ins.

This guide covers the free route honestly before the paid one, and is written by people who sell one of the options. The bias is disclosed.

Why a Google Form cannot do this alone

A Google Form writes each response as a spreadsheet row, which is genuinely most of the job. What it cannot do is produce something unique for that person to present later. There is no per-response image, no confirmation email with an attachment, and no concept of a code that can be checked off.

The free workaround is an Apps Script bound to the response sheet. On each submission it builds a URL containing the row's unique id, points a QR image service at that URL, and emails the result with MailApp. This works and costs nothing, and for a one-off event with a technical organiser it is a reasonable choice.

Three things tend to bite. MailApp has a daily quota that is lower on a consumer Gmail account than on Workspace, so a form that performs well stops emailing partway through. The script runs on Google's trigger schedule, so a failure is silent and the registrant simply never receives anything. And critically, generating the code is only half the problem: you still have nothing to scan it with, so the check-in half needs a second build.

If you build the Apps Script route, log the outcome of every send into a column on the same row. A registrant who never received their code is invisible otherwise, and you find out at the door.

What a per-submission code actually needs to be

  • Unique to one submission, so two people cannot present the same pass.
  • Meaningless on its own, so a photographed code reveals nothing about the person.
  • Reachable without an app, because a stranger will not install one to attend your event.
  • Idempotent on scan, so scanning twice does not double-count or read as a second arrival.
  • Recorded somewhere you own, not inside a vendor dashboard you have to export from.

That last point is the one people regret skipping, and it is where QR to Sheets Forms currently falls short: the sign-up lands in your sheet, but the arrival is recorded in QR to Sheets and is not written back to the sheet. If you need registered against arrived as two columns in one spreadsheet, the QR to Sheets Events add-on writes each check-in back to the guest's row, and an Apps Script build can write the arrival wherever you choose.

How this works in QR to Sheets

Each submission generates its own token and a QR code encoding a check-in URL for that token. The code appears on the confirmation screen immediately and, when the confirmation email is switched on, in the email as well. Nothing is installed by the registrant, and nothing is installed by the person scanning. For a guest list that already lives in a Sheet, QR event check-in with emailed codes is the other route.

The check-in code deliberately points at a separate check-in route, not at a scanner link. That means checking in a registrant never consumes a device licence and never touches the per-device paywall, so the number of people you check in has no effect on what you pay.

Scanning is idempotent. If a code is scanned twice, the second scan reports that the person is already checked in and returns the original arrival time rather than overwriting it. On a busy door where two volunteers both scan the same guest, that is the difference between an accurate head count and a wrong one.

Google Forms + Apps Script (DIY) compared with QR to Sheets
CapabilityGoogle Forms + Apps Script (DIY)QR to Sheets
CostFree, within Apps Script and Gmail quotasFree for 10 trial submissions, then Premium, from 7 USD a month
Unique code per registrantPossible, but you write and maintain the scriptGenerated automatically for every submission
Delivery to the registrantMailApp, subject to a daily quota that differs by account typeShown on the confirmation screen and emailed
Scanning at the doorNot included — needs a second buildAny phone opens a link; no app, no account for the person scanning
Scanning the same code twiceWhatever you build it to doReports already checked in and keeps the original time
Where arrivals landWherever your script writes themRecorded in QR to Sheets; not written to your sheet
Does check-in cost a device licenceNot applicableNo — check-in uses a separate route that consumes no device slot

Printing and screen: what actually fails on the day

A QR code only scans reliably as dark modules on a light background. If you place the code into a branded email or a printed pass, keep the code itself dark on near-white and leave the blank margin around it intact. Cropping that quiet zone to make a design fit is the single most common reason a code stops reading.

Phone screens are usually fine, with two exceptions worth telling registrants about: auto-brightness turned right down, and a cracked screen across the code. Both are solved by having the email as a fallback, which is why delivering the code twice matters.

When this is the wrong tool

If you are selling tickets, use a ticketing platform. This is not one: there is no payment collection, no seat allocation, no ticket transfer and no refunds. Trying to bolt payment onto a form is how people end up reconciling a spreadsheet against a payment processor by hand. Our event check-in apps comparison covers a ticketing platform with a free door app and the per-ticket Sheets add-ons.

If your event is small enough that a printed list and a pen works, that also genuinely works, and it does not fail when the venue wifi does. The case for codes starts when the queue matters, when you need arrival times, or when the person on the door does not know the guests by sight.

Step by step

  1. 1

    Decide what the code has to prove

    Usually it proves that this specific person registered. That means the code must be unique per submission, not one shared code printed on a poster, which proves only that somebody found the poster.

  2. 2

    Turn the QR code on when you build the form

    The per-submission QR code is a switch on the form, and it is off by default. A form built without it collects responses perfectly well but issues nobody a pass, which is only discovered on the day.

  3. 3

    Deliver the code twice

    Show it on the confirmation screen for people who register on their phone, and email it for everyone else. Someone who registers on a laptop at work needs it on the phone they will actually bring.

  4. 4

    Decide who scans, and on what

    The person on the door scans each code with their own phone camera, which opens that registrant's check-in page. They need no account and install nothing, so a volunteer or venue staff member can be handed the job an hour beforehand.

  5. 5

    Test the whole loop before you publish the form

    Submit the form yourself, open the email, and scan your own code at the door setup. This takes two minutes and is the only test that proves registration, delivery and check-in all connect.

  6. 6

    Know what the sheet shows on the day

    Sign-ups land as rows in your spreadsheet, and anyone you have shared it with can watch registrations come in from anywhere. Arrivals are confirmed on each registrant's check-in page and kept in QR to Sheets; they are not added to the sheet.

Frequently asked questions

Can Google Forms send a QR code to each person who submits?+

Not by itself. Google Forms has no per-response image generation and no confirmation email with content you control, so it requires an Apps Script that builds a QR URL and sends it with MailApp, subject to that account's daily sending quota.

Does the registrant need an app to use their QR code?+

No. The code is delivered as an image on the confirmation screen and in the confirmation email. They show it on their phone screen or on paper, and the person scanning uses a browser link with no app either.

What happens if the same code is scanned twice?+

The second scan reports that the person is already checked in and returns the original check-in time rather than overwriting it, so a double scan on a busy door cannot corrupt the head count.

Does checking people in use up my device licences?+

No. Form check-in uses a separate route from scanner links, so it never registers a device or consumes a device slot. Device licences are for scanner links, at 7 USD per phone per month.

Is the QR code turned on by default?+

No. The per-submission QR code is a switch on the form, Generate a QR code for each submission, and it is off when you create one, as are the webhook and the confirmation email. A new form does get its own Google Sheet, named after the form, with Sheet delivery already on. Turn on the QR code and the email before publishing.

Can I use this for paid tickets?+

No. There is no payment collection, seat allocation or ticket transfer. For paid tickets a ticketing platform is the right tool; this is for free registration and door check-in, with the sign-ups in your own spreadsheet.

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

Running an event? See event check-in, from door phones to QR invitations

Running one event? Price your door phones.

Premium is $7 per phone per month, so two door phones cost $14 a month. You can lower the phone count or cancel at any time on the Billing page, and the change takes effect at the end of the period you already paid for.

How many door phones?

$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