QR code inventory tracking for Google Sheets — no app for your team
With QR to Sheets, workers scan QR codes and barcodes from any phone browser and every scan writes a timestamped row directly to your Google Sheet. No hardware scanner, no app install, no new software.
The free way is a Google Form: print one QR code per item that opens the form with the item already filled in, or build a Google Apps Script web app with a barcode library. A form needs a tap to submit every count and has no barcode scanner, so the barcodes already on your stock are typed by hand, and a script is yours to build and maintain.
Free for your first 300 scans on one phone, no card needed.
Updated
Common workflows
Goods received log
Scan incoming stock against PO references
Stock count & stocktake
Rapid cycle counts with timestamp trail
Pick and pack verification
Confirm scanned SKUs before despatch
Asset tracking
Equipment check-out / check-in with device log
Damage & returns log
Record damaged items with code and timestamp
Location transfers
Scan item + destination bin as one record
Counting stock? How to scan barcodes into Google Sheets for inventory compares the free routes with a scanner link and shows how to lay out each row. Trying the free apps first? Free barcode scanner apps for Google Sheets says what each does free and where each stops.
Lending laptops or library books in a school? See Chromebook and device loan checkout and library book checkout.
Everything you need. Nothing your workers need to install.
Replace clipboards, spreadsheet imports, and app rollouts with a single scanner URL.
Print QR codes for any item
Generate QR codes for SKUs, pallets, bins, equipment, or locations directly from the built-in QR generator. Print them as labels, attach to shelving, or embed in existing paperwork.
Workers scan from any phone browser
No app download, no shared login, no hardware scanner required. Workers open a URL on any Android or iPhone and scan with the camera: QR codes, Code 128, Code 39, EAN-13, UPC-A and the other formats listed below.
Every scan lands in Google Sheets
Each scan appends a row: timestamp, scanned value, worker device and the link it came through, or the signed-in staff member's email when the link has Staff sign-in on. Your inventory sheet updates in real time. Works with any existing spreadsheet layout.
Keeps scanning 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. Workers need signal to open the link in the first place.
Separate links per job, shift, or location
Create one scanner link per workflow: Goods In, Goods Out, Stock Count, Damage Log. Each link writes to its own tab or spreadsheet. No data mixing, no manual routing.
Your data, your spreadsheet
Everything lands in Google Sheets you own. Build pivot tables, VLOOKUP against your master list, trigger Zapier automations, or share the sheet with your ops team — no new software to learn.
Set up in minutes. Running in your warehouse today.
Connect your Google Sheet
Sign in with Google, pick the spreadsheet you use for inventory, and choose the tab. The setup takes under two minutes and requires no developer help.
Create scanner links per workflow
Create one link for Goods In, one for Goods Out, one for Stock Count. Map the columns — scanned value, timestamp, location — to match your existing sheet structure.
Share the URL with your warehouse team
Print the URL as a QR code on a sign near each workstation, or send it via WhatsApp. Workers bookmark it on their own phones. No accounts, no passwords, no IT ticket.
Every scan writes instantly to your sheet
Workers scan items — each scan creates a new row in your Google Sheet within seconds. Monitor stock movements in real time from your laptop while the team scans on the floor.
Watch every feature in 98 seconds
No hardware scanners. No app rollout. No IT ticket.
Your warehouse workers already carry smartphones. QR to Sheets turns any phone camera into a barcode scanner that writes directly to your Google Sheet — with nothing to install, configure, or manage on their device. Scanning barcodes into Google Sheets on iPhone and Android covers the camera permission steps on each phone.
Can several phones scan into the same Google Sheet at once?
Yes: with QR to Sheets, several phones can open the same scanner link and scan at the same moment, and every scan lands as its own row in the same Google Sheet. Each phone that scans counts as one device. Free covers one phone; Premium is $7 per phone per month, and workers need no Google account and no access to the Sheet. How several phones scan into one Google Sheet.
Common questions
Do warehouse workers need to install anything?+
No. Workers open the scanner link URL in any phone browser — Android or iPhone. No app store, no sign-up, no shared password. The link is the entire worker-facing product.
What barcode types does it scan?+
QR codes (including Micro QR), Data Matrix, Aztec, PDF417, Code 128, Code 39, Code 93, EAN-13, EAN-8, UPC-A, UPC-E, ITF (including ITF-14) and GS1 DataBar. Codabar is not read, so test one real label first if your stock uses it. The same QR to Sheets scanner link reads every listed type without any setting.
What if signal drops in the warehouse?+
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. Keep the scanner page open: it needs signal to load, and reloading it with no signal will not work. A CSV backup can be downloaded from the phone at any time.
Can I have different sheets for different workflows?+
Yes. Create one scanner link per workflow (Goods In, Goods Out, Stock Count). Each link writes to its own spreadsheet destination. Premium plan supports unlimited scanner links.
Also included
No code to scan? Collect it with a form instead.
Stock movements are scans, but the requests around them are not: supplier collection bookings, damage reports and stock-take sign-ups arrive as forms.
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
- Warehouse cycle counting with a phone and Google SheetsReplace the annual stock-take with small weekly cycle counts: scan shelf and item codes into a Google Sheet, then read the variance.Read the guide
- Orca Scan alternative for scanning into Google SheetsOrca Scan lists Google Sheets on its Business plan; QR to Sheets writes to your sheet from a browser link, per phone. Compared, including where Orca wins.Read the guide
- Free barcode scanner apps for Google Sheets, compared: what actually worksBarcode Sender, Orca Scan, Barcode to PC, GearChain, AppSheet, Google Forms, a USB scanner and a scanner link: what each does free, and where each stops.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
Replace your clipboard with a Google Sheet today
Free tier includes 300 scans, 1 device, and 1 scanner link. No credit card required.
Start for free