Videos

Watch how to scan QR codes to Google Sheets

Short videos showing QR to Sheets working end to end: a phone scans, the row lands in your Google Sheet. No app to install and no account for the people scanning.

In these videos, a device means a phone that scans: Free covers 300 scans on one phone, and Premium is $7 per phone per month or $70 per phone per year.

Updated

Step-by-step walkthroughs

From connecting your Google Sheet to your first scan, including teams, repeat scans and lost signal.

Scan QR Codes to Google Sheets with Any Phone (No App)

4:06 video · narrated

The full four-minute walkthrough: connect your Google Sheet, create a scanner link, scan from any phone's browser, share one link with a team, and what happens when a code is scanned twice or the signal drops.

Watch on YouTube
Read the transcript

Scan QR codes into Google Sheets with a phone

Here's how to scan QR codes into Google Sheets with any phone. No app to install, and no account for the people scanning. Point the phone at a code, and the row lands in your own Google Sheet. In the next few minutes, you'll set it up, share it with a team, and see what happens when a code is scanned twice, or the signal drops. Let's start with the Sheet.

Connect your Google Sheet and create a scanner link

Sign in at qrtosheets.com, and open Scanners. Click Connect Google, and approve it. We ask for the narrowest permission: only the spreadsheets you choose, and nothing else in your Drive. Once it says Google connected, create a scanner link. Name it after the place you'll scan, like Front door. Then choose where the rows go, right inside the same form. Open Google Picker to use a spreadsheet you already have, or click Create a sheet for me, and we'll set one up. Click Create link. You get a short scanner link, and its QR code. Copy the link to send it, or download the QR code, so workers can open the scanner with their camera.

Scan from any phone browser, no app or account

Now open that link on a phone. Any browser works, on Android or iPhone. There's nothing to install, and nobody has to sign in. Tap Start camera, and allow camera access when the browser asks. Hold a code inside the box. Beep. A green check, and it says: Recorded and synced to Google Sheets. Back in your Sheet, the row is already there. If a label is too damaged to scan, type the value into manual entry.

Share one link to multiple phones

Scanning with a team? You don't set anything up again. Send the same link by text, email or chat, and each phone opens the same scanner. Every scan lands in the same Sheet, in the order it happened. The free plan covers one phone. For a team, Premium is $7 per device per month. Each phone shows up under Devices, so you can see which phones are scanning.

What gets recorded in each row

So what's in each row? The time of the scan, the code's value, the link it came from, your workspace, and the type of device. Times are written in your workspace's time zone. You set it once, in Settings. If one code holds several values, like a badge number, name and ticket type, turn on column mapping. Split by separator, and each part gets its own column, right after the tracking columns.

What happens if a code is scanned twice

What happens if the same code is scanned twice? The scanner turns amber. Already scanned, two times on this link. It's a warning, not a block. The scan is saved anyway, and the row still lands in your Sheet. So a real second visit is never lost, and an accidental double scan is easy to spot.

Does it work without signal?

Does it work without signal? You do need signal to open the link. But if it drops in the middle of a shift, keep scanning. Each scan is saved on the phone, and it tells you it will sync when the connection is back. When the signal returns, those scans go to your Sheet on their own. And at any time, you can download a CSV backup straight from the phone.

QR code attendance and check-in

For attendance, give each person their own QR code. Our free bulk QR tool turns a list of ID numbers into printable label sheets. Scan each badge at the door, and your Sheet becomes a live attendance list. For check-in and check-out, make two links, one for each. Every row says which one it came from. More than one active link is part of Premium.

Start free

That's it. Connect Google, create a link, and scan. Start free with 300 scans. When your team grows, Premium is $7 per device per month. Go to qrtosheets.com, and send your first scanner link today. The written guide is linked in the description.

QR Code Attendance in Google Sheets: Scan with Any Phone (No App)

4:02 video · hosted by Pip

Pip, the QR to Sheets assistant, walks through taking attendance with QR codes: connect a Sheet, create a scanner link, share it with your team, and run check-in and check-out.

Watch on YouTube
Read the transcript

Scan QR codes into Google Sheets with a phone

Hi, I'm Pip. Here's how to scan QR codes into Google Sheets with any phone, no app and no account. The people scanning just open a link in their browser. Point the phone at a code, and the row lands in your own Google Sheet. In the next few minutes, I'll show you how to set it up, share it with a team, and what happens when a code is scanned twice, or the signal drops. Let's start with the Sheet.

Connect your Google Sheet and create a scanner link

First, sign in at qrtosheets.com, and open Scanners. Click Connect Google, and approve it. It asks for the narrowest permission: only the spreadsheets you choose, and nothing else in your Drive. When it says Google connected, create a scanner link. I like to name it after the place you'll scan, like Front door. Then choose where the rows go, right inside the same form. Open Google Picker to use a spreadsheet you already have, or click Create a sheet for me, and I'll set one up for you. Click Create link. You get a short scanner link, and its QR code. Copy the link to send it, or download the QR code, so workers can open the scanner with their camera.

Scan from any phone browser, no app or account

Now open that link on a phone. Any browser works, on Android or iPhone. There's nothing to install, and nobody has to sign in. Tap Start camera, and allow camera access when the browser asks. Then hold a code inside the box. Beep! A green check, and it says: Recorded and synced to Google Sheets. Back in your Sheet, the row is already there. I love that part. If a label is too damaged to scan, type the value into manual entry.

Share one link to multiple phones

Scanning with a team? You don't set anything up again. Send the same link by text, email or chat, and each phone opens the same scanner. Every scan lands in the same Sheet, in the order it happened. The free plan covers one phone. For a team, Premium is $7 per device per month. Each phone shows up under Devices, so you can see which phones are scanning.

What gets recorded in each row

So what's in each row? The time of the scan, the code's value, the link it came from, your workspace, and the type of device. Times are written in your workspace's time zone. You set it once, in Settings. If one code holds several values, like a badge number, name and ticket type, turn on column mapping. Split by separator, and each part gets its own column, right after the tracking columns.

What happens if a code is scanned twice

Now, what happens if the same code is scanned twice? The scanner turns amber. Already scanned, two times on this link. It's a warning, not a block. The scan is saved anyway, and the row still lands in your Sheet. So a real second visit is never lost, and an accidental double scan is easy to spot.

Does it work without signal?

Does it work without signal? You do need signal to open the link. But if it drops in the middle of a shift, keep scanning. Each scan is saved on the phone, and it tells you it will sync when the connection is back. When the signal returns, those scans go to your Sheet on their own. And at any time, you can download a CSV backup straight from the phone.

QR code attendance and check-in

For attendance, give each person their own QR code. With the free bulk QR tool, a list of ID numbers becomes printable label sheets. Scan each badge at the door, and your Sheet becomes a live attendance list. For check-in and check-out, make two links, one for each. Every row says which one it came from. More than one active link is part of Premium.

Start free

That's it. Connect Google, create a link, and scan. Start free with 300 scans. When your team grows, Premium is $7 per device per month. Go to qrtosheets.com, and send your first scanner link today. The written guide is linked in the description. Happy scanning!

Quick feature tours

Everything the product does, in under two minutes each.

QR Code to Google Sheets: Every Feature in 88 Seconds

1:28 video · music, no narration

Every feature in under a minute and a half, with on-screen text and music, so it works with the sound off: repeat scans, lost signal, setup, the dashboard, Forms, the Events add-on and pricing.

Watch on YouTube

Barcode Scanner to Google Sheets, No App: Full Tour with Pip

1:38 video · hosted by Pip

Pip tours everything QR to Sheets does with QR codes and barcodes in about a minute and a half: scanning, repeat scans, lost signal, column mapping, the dashboard, Forms and the Events add-on.

Watch on YouTube
Read the transcript

Hi, I'm Pip. Let me show you QR to Sheets. Scan a QR code with any phone, and it lands in your Google Sheet. No app. No account. Your team just opens the link. Every phone writes to the same Sheet. Nothing lost.

Scanned twice? It's flagged, and still saved. Signal drops? Keep scanning. It's saved on the phone. Signal's back, and it all syncs. Every phone keeps a backup, too. Code won't scan? Just type it in. Every scan ends up in the Sheet.

Your Sheet. Your way. Connect Google, then create a scanner link. You pick the Sheet right inside that step. One code can even fill its own columns. Pick your time zone. Rename links anytime. Watch every scan land on the dashboard.

Invite your team as Admins or Scanners. And see every registered device. And more. Forms fill your Sheet, too. One response reaches your Sheet, your CRM, and their inbox. The Events add-on sends invites, then checks guests in.

Need codes? Print a whole label sheet, free. Stuck? Just ask me. Start free with 300 scans. Then it's $7 per device, per month. Start free at qrtosheets.com.

Shorts

Under thirty seconds, made for a phone screen.

Scan QR Codes to Google Sheets in Seconds, No App

0:22 Short · music, no narration

One link on every phone, no app and no account. A repeat scan is flagged and still saved.

Watch on YouTube

Scan QR Codes to Google Sheets with Pip (No App)

0:27 Short · hosted by Pip

Pip in 27 seconds: scan a QR code, it lands in your Google Sheet, and a repeat scan is saved anyway.

Watch on YouTube
Read the transcript

Hi, I'm Pip. Scan a QR code, and it lands in your Google Sheet. Every scan is a new row. Share one link. It opens on any phone. No app, no account. Just open it and scan. Scanned it twice? You'll see it in amber, and it's saved anyway. Start for free at qrtosheets.com. Happy scanning!

Rather read it step by step?

The guides cover every workflow in writing, from school attendance to stock counts. Or start free with 300 scans on your own Sheet.

No credit card required