QR code delivery confirmation and receiving log to Google Sheets — no app
With QR to Sheets, drivers and warehouse staff scan barcodes from any phone browser and every delivery or receipt writes instantly to Google Sheets. No paper POD, no app, no manual data entry.
Free for your first 300 scans on one phone, no card needed.
Updated
Replace paper PODs and manual receiving logs
Barcode scanned → row in Google Sheets. Instant, timestamped, searchable delivery records. Setting up a driver phone? See scanning barcodes into Google Sheets on iPhone and Android. Comparing costs first? Free barcode scanner apps for Google Sheets says what each does free and where each stops.
Drivers scan on delivery
Drivers open the scanner link on their own phone and scan the parcel barcode or QR code at the drop-off point. Delivery confirmed — no paper POD, no manual log.
Warehouse staff scan on receipt
Inbound stock is scanned as it arrives. Every item creates a timestamped row in your Google Sheet — cross-reference against PO numbers or manifests automatically.
Works on any barcode or QR code
Code 128, QR codes, EAN-13, UPC — all the barcode formats on parcels, pallets, and manifests are supported. Workers scan with the phone camera directly.
Keeps scanning in loading bays with weak signal
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 while there is signal.
Delivery history in Google Sheets
Every scan writes a row: barcode value, timestamp, driver device, location. Your Google Sheet is a searchable, exportable delivery record with no manual entry.
Separate links for inbound and outbound
Create one link for goods received, one for despatch, one per depot. Each writes to its own tab so inbound and outbound records never mix.
Scan, confirm, done — in under 5 minutes to set up
Connect your delivery log spreadsheet
Sign in with Google and pick the spreadsheet you use for deliveries. Configure columns for barcode, timestamp, driver, and location — done in under two minutes.
Create scanner links for each workflow
One link for deliveries in, one for deliveries out. Share each URL with the relevant team. Each link writes to its own Google Sheets destination.
Drivers and staff scan barcodes on the job
Workers open the link on their phone and scan parcel barcodes, pallet labels, or manifest QR codes. Takes under 2 seconds per item — no paper, no typing.
Full delivery record in Google Sheets
Every scan creates a row. Filter by date, driver, or barcode to resolve disputes, confirm receipts, or prepare manifests — all inside Google Sheets you already use.
Common questions
Do drivers need to install an app?+
No. Drivers open the scanner link URL on any phone browser — Android or iPhone. Nothing to install, no company account required.
What barcode formats does it scan?+
QR codes, Code 128, EAN-13, EAN-8, UPC-A, UPC-E, Code 39, ITF, and more — all the formats found on parcels, pallets, and manifests.
What if a driver is in an area with no signal?+
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. The driver needs signal to open the link, and should keep the page open: reloading it with no signal will not work.
Can I have separate logs for deliveries in and out?+
Yes. Create one scanner link per workflow. Each writes to its own tab so inbound and outbound records are always separate.
Can I use this to confirm deliveries against a PO list?+
Yes — your Google Sheet can contain the expected delivery list alongside the scan log. Use VLOOKUP or Google Sheets filters to match scanned barcodes against your purchase orders.
Also included
No code to scan? Collect it with a form instead.
Drops are scans, but the intake is not: collection requests, address corrections and failed-delivery reports are all typed, not scanned.
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
- Restaurant delivery and stock intake logging with Google SheetsScan every kitchen delivery and stock count into a Google Sheet, so short deliveries and price creep show up in your own data instead of going unnoticed.Read the guide
- How to scan barcodes into Google Sheets for inventoryBarcode scans into Google Sheets three ways: a free Google Form, an Apps Script web app or a hosted scanner link, and what each costs to set up and run.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
- How to scan QR codes into Google Sheets automaticallyScan QR codes and barcodes to Google Sheets: a Google Form, Apps Script, AppSheet, a phone app or a browser link. Which is easiest, and where each breaks.Read the guide
Replace paper delivery logs with a QR scan
Free to start. No credit card. No app for your drivers or warehouse team.
Start for free