Loading…
LoadingPractical, complete guides for the workflows people actually run. Each one covers the free do-it-yourself route first, then where it stops working.
Complete answer
How to scan a QR code and have it appear automatically in Google Sheets
Every way to get a QR or barcode scan to appear in Google Sheets automatically: a mobile app, a Google Form, an Apps Script web app, or a shareable scanner link. What each one requires and where each breaks.
8 min readReadTeacher guide
Daily classroom attendance with QR codes and Google Sheets
A teacher-run setup for taking daily register in under a minute: print one QR per student, scan the class in from your own phone, and let the rows land in your own Google Sheet.
10 min readReadDevice loans guide
Chromebook and device loan checkout with QR codes and Google Sheets
Stop tracking laptop and tablet loans on a sticky note. Scan devices out to a student and back in again, with the whole history in a Google Sheet you own.
9 min readReadWarehouse guide
Warehouse cycle counting with a phone and Google Sheets
Replace the annual stock-take panic with small recurring counts. How to run weekly cycle counts by scanning shelf and item codes into a Google Sheet, and how to read the variance.
9 min readReadAccess control guide
QR code site access control and shift sign-in with Google Sheets
Log who is on site, on every shift, with QR codes and a Google Sheet. Contractor sign-in, induction checks, and a live on-site roll call for fire safety.
9 min readReadInventory guide
How to scan barcodes into Google Sheets for inventory
Three ways to get barcode scans into Google Sheets: a free Google Form, a free Apps Script web app, and a hosted scanner link. What each one costs you in setup, reliability, and team size.
9 min readReadAttendance guide
QR code attendance tracking with Google Sheets, with no app for staff
A practical guide to QR attendance in Google Sheets for schools and clubs: the free Google Forms method, its real limits, and when a dedicated scanner link is worth it.
8 min readReadEvents guide
QR code event check-in with Google Sheets, without an app for your door staff
How to run door check-in that writes straight to a Google Sheet: generating guest QR codes, scanning at the door, handling the queue, and surviving bad venue wifi.
9 min readReadMobile guide
How to scan barcodes into Google Sheets on iPhone and Android
Phone-only ways to get barcode and QR data into Google Sheets: the built-in camera, Google Forms, and browser scanners. What works on iOS versus Android, and the camera permission traps.
7 min readReadComparison
Google Forms versus a scanner link for collecting field data
An honest comparison for teams collecting data in the field: where a free Google Form is the right answer, where it breaks down, and what a dedicated scanner link changes.
7 min readReadAsset guide
QR code asset tracking in Google Sheets for equipment and device loans
Track equipment, tools, and device loans with QR labels and a Google Sheet: what to encode, how to model check-out and check-in, and how to keep the log auditable.
8 min readReadFree tool: bulk QR code generator with printable label sheets
Most of these guides start with “print one code per student, per asset, or per shelf.” This does that part for you — paste a list, print the sheet. No account needed. Open the free QR tool.
Free tier covers 300 scans. Your team opens a link and scans — no app install, no accounts for them to create.
Start for freeNo credit card required