QR code patrol logs and guard rounds to Google Sheets — no app
With QR to Sheets, guards scan checkpoint QR codes from any phone browser and every round writes automatically to Google Sheets with precise timestamps. No app, no paper, no manual reporting.
Free for your first 300 scans on one phone, no card needed.
Updated
Verifiable patrol records with zero paperwork
Checkpoint scanned → timestamped row in Google Sheets. Compliance-ready records without a single form.
QR codes at every checkpoint
Print and laminate checkpoint QR codes at doors, gates, floors, or any inspection point. Scanning the code creates an instant timestamped log — no manual entry, no memory required.
Precise timestamps on every checkpoint
Every scan is logged to the second. Prove exactly when a guard visited each location — verifiable records for compliance, incident investigation, and client reporting.
One link per route or shift
Create separate scanner links for day patrol, night patrol, and each route. Each link writes to its own tab so rounds are always separated and easy to review.
Keeps scanning in car parks and basements
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, so the round keeps its real checkpoint times.
Complete round history in Google Sheets
Every patrol creates a searchable, time-stamped record in Google Sheets. Filter by date, guard, or checkpoint. Export for client reports or compliance audits instantly.
Guards use their own phone — no shared device
Each guard opens the scanner URL on their personal phone. No shared tablet to manage, charge, or lose. Works on any Android or iPhone browser.
From checkpoint to Google Sheets in seconds
Print checkpoint QR codes
Generate QR codes from the admin panel for each checkpoint location. Print, laminate, and attach them — doors, gates, stairwells, equipment rooms.
Create a scanner link per route or shift
One link for night rounds, one for day patrol. Each link writes to its own Google Sheets tab so shift rounds are automatically separated.
Guards scan checkpoints during their round
Guards open the scanner link on their own phone and scan each checkpoint QR code as they pass. Takes under 2 seconds per checkpoint — no interruption to the patrol.
Complete patrol record in Google Sheets
Every scan creates a row: checkpoint code, timestamp, guard device, route. Your Google Sheet is a complete, verifiable patrol log with no manual paperwork.
Common questions
Do guards need to install an app?+
No. Guards open the scanner link URL on any phone browser. Nothing to install, no shared account.
How do I prove a checkpoint was visited at a specific time?+
Every scan is written to your Google Sheet with the checkpoint and the time it was scanned. QR to Sheets never edits or deletes a row it has written, and Google Sheets keeps a version history of any later change, so you can share a view-only link with clients or compliance teams.
Can I have separate logs for different shifts or routes?+
Yes. Create one scanner link per shift or route. Each writes to its own tab so day and night patrols are always separated.
What if there's no signal in a basement or car park?+
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 at the start of the round and keep the page open: reloading it with no signal will not work.
Can I export patrol reports for clients?+
Yes. Your Google Sheet can be exported as CSV or PDF, or shared as a view-only link. Build client-ready reports directly in Sheets using filters and pivot tables.
Also included
No code to scan? Collect it with a form instead.
Checkpoints are scans, but incidents are not. An incident report is a form, and it belongs in the same spreadsheet as the patrol it happened on.
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
- QR code site access control and shift sign-in with Google SheetsLog who is on site, every shift, with QR codes and a Google Sheet: contractor sign-in, induction checks, and a live roll call for fire safety.Read the guide
- QR guard tour checkpoints logged to Google SheetsQR tags at each checkpoint, guards scan from a phone browser, every visit lands in Google Sheets. How to spot a missed checkpoint, and the honest limits.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 patrol logs with a QR scan
Free to start. No credit card. No app for your guards.
Start for free