QR code event check-in that writes to your Google Sheet — no app for staff
Free QR event check-in is a Google Form behind a QR code poster, and QR to Sheets covers what a poster cannot: door staff scanning each guest's own code from any phone browser. Every scan appends a timestamped row to your own Google Sheet, with no app, no staff accounts and no per-attendee fees. The Events add-on goes further, emailing each guest a personal QR invite and writing the check-in time back to their row on your guest list.
Free for your first 300 scans on one phone, no card needed.
Updated
Which QR check-in setup fits your event?
Six setups cover almost every event. A Google Form and an Apps Script page are free, and a USB scanner is one-off hardware; the other three are QR to Sheets, so weigh the table with that in mind.
| Workflow | What it records | Best fit | Limit |
|---|---|---|---|
| Self check-in posterGoogle Form (free) | Whatever each guest types, with the submission time, in a Google Sheet linked to the form | Free, informal events where every guest has a phone and signal | Self-reported, nothing is checked against your guest list, and a submission made with no signal is lost rather than queued |
| Scanner page you buildGoogle Apps Script web app (free) | Whatever your script appends, usually the code and a time, in your Google Sheet | Someone who writes code and wants it free on any number of phones | You build and maintain it. Since February 2026 some Apps Script web apps cannot open the camera inside Google's page, and a scan made with no signal fails unless you queue it |
| Laptop at the doorUSB or Bluetooth scanner (hardware) | The code typed into the selected cell; no time unless a formula or script adds it | One fixed desk with the Sheet open | Tethered to the laptop. QR tickets, and codes on phone screens, need a 2D imager scanner, not a 1D laser |
| Staff scan each guest's codeQR to Sheets scanner link | One new row per scan: the code, the scan time and the link it came through, in your own Google Sheet | Staffed doors, printed tickets or badges, venues with weak signal | Appends rows rather than ticking off your list, so match arrivals to the list with a formula. Free for 300 scans on one phone, then 7 USD per phone per month |
| Personal invites, check-in written back to your guest listQR to Sheets Events add-on | The check-in time on each guest's own row in the list you imported, plus checked-in against invited | RSVP events, galas and conferences with a known guest list | 25 USD per month on top of Premium; walk-ins have to be added to the list or scanned on a separate link |
| Register online, get a passQR to Sheets Forms | Each registration as a row in your Google Sheet, and a QR pass emailed to every registrant | Public events where people sign themselves up | The door check-in is recorded in QR to Sheets, not written to the Sheet |
For named tools side by side, see free event check-in apps for Google Sheets, compared. Running a school event with registered and walk-in families? See school open day check-in with QR codes. For a graduation with a ticket limit per graduate, see graduation guest check-in with QR codes. Want guests to register themselves first and get a pass? That is QR to Sheets Forms. Taking attendance for a class, a training or a shift rather than an event? See QR code attendance.
Why event coordinators switch to QR to Sheets
Dedicated check-in apps that charge per attendee or per event
Flat $7/phone/month — scan as many guests as you want
Staff download and learn a new app before every event
Staff open a URL. That's it. Works on their own phone in 10 seconds.
Attendance data trapped in the platform's database
Every check-in writes to your Google Sheet — you own the data
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.
Built for event coordinators, not software teams
No integrations to configure, no developer needed, no new platform to learn.
Staff scan from any phone — no app
Door staff open a QR to Sheets scanner link on any phone or tablet. No app install, no shared login, no training needed. If they can open a website, they can run check-in.
Check-in data lands in your Google Sheet
Every scan appends a timestamped row with the guest's code and the link it came through, so your spreadsheet becomes a live arrivals log you own. With the Events add-on, the time is written to the guest's own row instead.
Fast: under 1 second per guest
Open camera, scan, confirmed. Each check-in takes under a second. Multiple staff can scan simultaneously from separate phones — no queue, no bottleneck at the door.
Works when signal drops
If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back, each with its original scan time. Useful at venues with patchy WiFi or basements.
Your data stays in your spreadsheet
Unlike event platforms that lock attendee data in their own database, every check-in writes to a Google Sheet you own. Export, analyse, or share it — no vendor lock-in.
Live check-in stats as it happens
Watch arrivals land in your Google Sheet as guests are scanned, and open the admin dashboard for the running totals. The Events add-on also counts checked-in against total invited for your guest list.
From guest list to live check-in in four steps
Add your guest list to a Google Sheet
Name, email, ticket reference, in any format. With a scanner link, check-ins arrive as new rows and a COUNTIF against your list shows who has arrived. With the Events add-on, QR to Sheets imports the list and invites each guest.
Create a scanner link for the door
Create one scanner link for your door staff. The link opens a camera scanner in any phone browser. No app, no shared password — just a URL they bookmark.
Guests show their QR code or ticket
If you use the Events add-on, each guest receives a personalised QR invitation. Or scan any printed ticket, badge, or QR code tied to your guest list.
Each scan writes instantly to your sheet
A scanner link appends one row per scan with the check-in time, so your sheet updates in real time with no import after the event. With the Events add-on, the time is written back to the guest's existing row instead.
Watch the four-minute walkthrough
Also need to send QR invitations to guests?
The Events add-on handles the full lifecycle: import your RSVP list from Google Sheets, send each guest a personalised QR invitation by email, then scan them in at the door. Check-in timestamps write back to your original RSVP row automatically.
Learn about the Events add-onCan I check guests in against a guest list I already have in Google Sheets?
Yes, in two ways, and they differ in where the check-in lands. A plain scanner link does not tick off your list: every scan appends a new row with the code and the time. Put each guest's ID or email in their QR code (the free bulk QR code generator makes one per row), keep the guest list on its own tab, and a formula beside each guest, such as =COUNTIF(Arrivals!B:B, A2)>0 or a MATCH, pointed at the column that holds the scanned code, marks who has arrived. A guest scanned twice is still saved and flagged on screen, and the formula counts them once.
The Events add-on (25 USD per month, on top of Premium) works from the list itself: QR to Sheets imports your guest list from the sheet, emails each guest a personal QR invite, and writes the check-in time back to that guest's own row, with checked-in against invited on the dashboard.
Walk-ins are where the two differ most. On a scanner link a walk-in is just another row: scan a spare numbered pass or type their name with manual entry, and the formula shows them as not on the list. With the Events add-on, add the walk-in to your sheet and re-sync, which emails only guests who have not been invited yet, or keep a plain scanner link at the desk for people who are not on the list.
Running check-in when you are not there
Because a scanner link is just a URL, the person scanning does not need an app, an account or a licence. That is what makes it practical to run a company event in another city or another country without flying out to set up anyone's phone.
- Create one link per door before you travel, named after the place it will be used.
- Send each link to the hostess or steward working that door by WhatsApp, SMS or email.
- They open it, allow the camera once, and scan. Nothing is installed.
- Set the workspace timezone to the venue so timestamps match the clock on site.
- Watch rows land in your Google Sheet in real time from wherever you are.
- Revoke the links afterwards — no accounts were created, so nothing is left behind.
Billing counts scanning phones rather than people, so four doors on four phones is four devices at $7 each per month. Ask each person for one throwaway test scan before the doors open; it is the only rehearsal available from another country, and it confirms the link, the camera permission and the venue signal in one message.
Read the full remote check-in guideCommon questions
What is the easiest way to scan event attendance QR codes into Google Sheets?+
With no code to write, a scanner link: in QR to Sheets, door staff open a link in any phone browser and each guest's QR code they scan becomes a timestamped row in your Google Sheet, with no app or staff accounts. Free for 300 scans on one phone; several doors at once cost $7 per phone per month. Free alternatives: an Apps Script scanner page you build, or a USB scanner at one laptop.
Do door staff need to download an app?+
No. With QR to Sheets, staff open the scanner link in any phone browser, iPhone or Android: nothing to install, no account to create and no training. If they can open a website, they can run check-in.
How do I check in guests with QR codes without an app?+
Give each guest a QR code they can show on paper or on their phone, and have door staff scan it with a QR to Sheets scanner link opened in Safari or Chrome: neither the guests nor the staff install anything, and each scan becomes a timestamped row in your Google Sheet. Paste your ticket numbers into the free bulk QR code generator to print one code per guest, or let the Events add-on, $25 a month on top of Premium, email every guest a personal QR invitation from your guest list. Scanning is free for 300 scans on one phone, then $7 per phone per month.
Can exhibitors scan attendee badges into a Google Sheet?+
Yes. Booth staff open a QR to Sheets scanner link in their phone browsers and scan each visitor's badge, and every scan adds a timestamped row to your Google Sheet. It reads QR codes, PDF417, Data Matrix, Aztec and Code 128, and the row holds exactly what the badge code holds, so scan one badge before doors open and look at the row. With Staff sign-in on the link and each booth staff member invited to your workspace, each row records the email of the staff member who scanned, in place of the link name. Free for 300 scans on one phone, then $7 per phone per month.
How much does trade show lead capture cost per event?+
With QR to Sheets there is no per-event, per-lead or per-exhibitor fee: it charges per scanning phone. Free covers 300 scans on one phone; after that it is $7 per phone per month, so a stand with three reps scanning badges into one Google Sheet is $21 a month.
Is there an event check-in app that writes to Google Sheets?+
Yes. QR to Sheets is an event check-in web app that writes every scan as a row in your own Google Sheet: door staff open a scanner link in Safari or Chrome, so nobody installs anything. Scanning tickets at the door with a scanner link is free for 300 scans on one phone, then $7 per phone per month; emailed QR invitations with check-ins written back to the guest list are the Events add-on, $25 a month on top of Premium. If you already sell tickets on Eventbrite, a Zapier Zap can copy each Eventbrite check-in into a Google Sheet as a new row.
Can several staff scan at different doors into one Google Sheet?+
Yes. With QR to Sheets, one scanner link works on any number of phones at the same time, so staff at every door scan into the same Google Sheet, one row per scan, with no account and no app. Each phone that scans counts as one device: Free covers one phone, and Premium is $7 per phone per month, so three doors on three phones cost $21 a month. To see which door each row came from, give each door its own scanner link, which needs Premium.
How many phones do I need?+
One for each person scanning at the same time, such as one per door, desk or aisle; with QR to Sheets they all open the same scanner link and write to the same Google Sheet, and staff need no account. Each phone that scans counts as one device. Free covers one phone; Premium is $7 per phone per month. People being scanned never open the link and need nothing. For example, 3 phones cost $21/month or $210/year, and 6 phones cost $42/month or $420/year.
Does it work if the venue has bad WiFi?+
Yes, once the scanner page is open. If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back, each with its original scan time. Open the link at the door before guests arrive, and keep the page open: reloading it with no signal will not work.
What if a guest doesn't have their QR code?+
Staff can type a guest's name or reference manually using the manual entry fallback on the scanner screen. No guest gets turned away due to a missing QR code.
Can I see a live count of who has checked in?+
Yes. Rows land in your Google Sheet as guests are scanned, so a COUNTA over the arrivals column is a live count, and the admin dashboard lists them. Share a view-only link to the sheet with event managers who want to watch. The Events add-on adds a checked-in against invited count for your guest list.
Do I need the Events add-on for check-in?+
No. Basic check-in scanning works on any plan — you create a scanner link, staff scan QR codes, and results go to your sheet. The Events add-on adds personalised QR invitations per guest and write-back to the guest's original RSVP row. The Events add-on ($25/month) requires Premium.
Can two guests who share one email address each get their own QR code?+
Yes, with the QR to Sheets Events add-on, which costs $25 a month on top of Premium. Give each guest their own row in the guest list Sheet with a unique ticket or attendee number, and choose that column as the Guest ID column when you import. Every row then gets its own QR code and its own email naming the guest it is for, so an employee can forward their guest's invitation as it is. At the door each code checks in once, and the time is written to that guest's own row. Without a Guest ID column, QR to Sheets treats each email address as one guest, so rows that share an address get one QR code between them.
Can I run check-in without being at the venue myself?+
Yes. You create the scanner links from anywhere, send each one to the person working that door by WhatsApp or email, and watch rows land in your Google Sheet in real time. Because the people scanning need no app, no account and no licence, there is nothing for you to install or configure at the venue — which is what makes running an event in another country practical. Revoking the links afterwards is also remote and immediate.
What does a multi-door event cost?+
Billing counts scanning devices, not people or links. Four doors covered by four phones is four registered phones at $7 per phone per month, so $28/month, or $280/year paid yearly by card. The staff holding those phones never need accounts of their own, so you are not buying anyone a seat.
Also included
No code to scan? Collect it with a form instead.
Door check-in is a scan, but the guest list has to come from somewhere. Collect the RSVPs yourself, and every registrant can be issued the QR code you will scan when they arrive.
Build a form, share the link or embed it on your own page, and every submission lands as a row in the same Google Sheet and fires a webhook the moment it arrives, so Zapier, Make, n8n or your CRM picks it up in real time. Each person can get their own QR code by email, which you scan to record their arrival. Included with the paid plan; the free plan covers one form and ten submissions.
How forms and check-in fit togetherRelated guides
- How to run QR code event check-in from a Google Sheet, starting freeRun QR event check-in from a Google Sheet, starting free: guest codes, scanning at the door, handling the queue, and surviving bad venue wifi.Read the guide
- QR code sign-in sheet: replace the paper clipboard with Google SheetsMake a QR code sign-in sheet in minutes: a free printable poster that opens a Google Form linked to a Sheet, plus sign-out and who is still in.Read the guide
- QR check-in kiosk on a shared tablet or phoneOne tablet at the door, everyone scanning, one billed device. How to set up a shared QR check-in station for Google Sheets, and what it cannot tell you.Read the guide
- Check in / check out with QR codes and Google SheetsA check in / check out QR code for people or equipment: two scans, one Google Sheet, and one formula that lists who or what is still out. Free to build.Read the guide
- Free event check-in apps for Google Sheets, compared: guest lists, QR tickets and the doorGoogle Forms, QR Code Ticket Per Row, Jotform, TicketSignup, QRLynx, QRWink and QR to Sheets compared for checking guests in from a Google Sheet.Read the guide
- How to run school open day check-in with QR codes and a Google SheetCheck families in at a school open day with QR passes and Google Sheets: registered and walk-in queues, the follow-up list, and when a visitor system fits.Read the guide
- How to check in graduation guests with QR codes and Google SheetsCheck in graduation guests from a Google Sheet: one QR ticket per guest, a limit per graduate, each ticket scanned once at the door. Free route first.Read the guide
Run your next check-in from a Google Sheet
Free to start. No credit card. No app for your team.