Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free QR Code Scanner to Google Sheets – Logs Who Scanned

FREE022 Tools & Utilities Automation & Integration Pro Apps Script Pass Business
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
Scan QR code from Android/Web and save it Google Spreadsheet | AppScript | Free Code
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

QR scanning through the phone or web camera Image file selected as an alternative to live scanning Scanner name required before scanning starts Scanning refused until the name is entered Camera permission requested in the app Decoded value shown after each scan Success popup confirming the entry Timestamp recorded with every scan The name of the person who scanned recorded Decoded QR output written to Google Sheets Bootstrap-styled layout Free source code to copy and adapt

Description

A QR scanner that records who did the scanning. Enter your name, point the camera at a code, and the decoded value goes into your Google Sheet with the scanner's name and the exact time attached.

The name is the point

Most scan-to-sheet tools record what was scanned. This one records who scanned it, and it will not start until a name is entered — attempting to scan without one raises an error. That turns a list of codes into an accountable log: which storeman booked in this delivery, which steward checked this ticket, which technician signed off this unit. When a scan turns out to be wrong, you know who to ask.

Camera or image

The scanner runs in the browser using the phone or laptop camera, with the permission requested in the app. When a camera is not practical — a desktop without a webcam, or a code you were sent as a picture — you can select an image file instead and it decodes the same way.

What lands in the sheet

Three things per scan: the timestamp, the name of the person scanning, and the decoded QR output. A popup confirms each entry so the person scanning knows it registered rather than scanning the same code three times because nothing visibly happened.

Where it fits

Goods in and out, event and ticket check-in, asset audits, sample handling, equipment sign-out — anywhere the question afterwards is not just what was scanned, but by whom and when. The code is yours to extend with extra fields.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets and Google Apps Script — no hosting or server needed
  • A phone, tablet or webcam for live scanning
  • Camera permission granted in the browser
  • A sheet to receive the timestamp, name and scanned value

What's Included

  • Complete Google Apps Script source code
  • In-browser QR scanner using the device camera
  • Image-file decoding as an alternative to live scanning
  • Mandatory scanner name before scanning starts
  • Timestamp, scanner name and decoded value written to the sheet
  • Confirmation popup on each successful scan
  • Google Sheet structure for the scan log
  • Deployment walkthrough for publishing as a web app
  • Step-by-step video walkthrough of the full build
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryTools & Utilities, Automation & Integration
Tagsqr code scanner to google sheetsscan qr code into google sheetsscan qr code and save to google sheetqr code scanner web appqr code scan web appqr scanner android webqr code attendance loggingscan log with user name
VideoWatch walkthrough
LicenseRegular License
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Not subscribed yet? Subscribe to our channel

Custom development

Need this customized for your business?

Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.

400+Projects delivered
91+Countries served

20–30% advance to start · Clear quote before work begins · Support after delivery

What we customize

  • Features & functionsNew features, changes to existing scripts, custom formulas and automations
  • API & integrationsWhatsApp, payment gateways, CRM and more
  • Design & UI changesYour branding, layout redesign, dark mode, mobile layout
  • Full custom projectsDashboards, billing, inventory, CRM, built from scratch
Free
Source Code File

People choose these

Paid picks from the same category

Vibe Coding Just Got FREE: This AI Builds Full Apps AND Dashboards From One Prompt (Google Sheets) Vibe Coding Just Got FREE: This AI Builds Full Apps AND Dashboards From One Prompt (Google Sheets) 115 views this month Apps Script Complete AI Help Desk Ticketing System Demo | Google Sheets + Apps Script Complete AI Help Desk Ticketing System Demo | Google Sheets + Apps Script 93 views this month Apps Script Restaurant POS System Demo | Complete Management Software in PHP MySQL Restaurant POS System Demo | Complete Management Software in PHP MySQL 117 views this month PHP

Reviews & Feedback

What buyers and YouTube viewers say about this project.

Sort
@HerramientasDigitalesyalgomás via YouTube
Excellent my friend, Iam your fans😊
1 like on YouTube
@jacobuys-pd3iq via YouTube
the new security update of google dont allow camera permisions
@pascalkrzeszewski via YouTube
Absolutely Brilliant ! Thank you so much