Patrol & Guard Rounds

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

01

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.

02

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.

03

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.

04

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 together

Related guides

Replace paper patrol logs with a QR scan

Free to start. No credit card. No app for your guards.

Start for free