Sign in to the QR Code Lab app
Use a sign-in method below. Your cloud account will connect to the app through a secure, one-time exchange.
Continue to QR Code Lab app →Sign in
Choose Face ID / Touch ID or an authenticator app.
First time here? Connect Google Sheets and create a Site ID →
Set up QR Code Lab
Connect Google Sheets, create your Site ID, and secure your sign-in.
1. Prepare your Google Sheet
Already deployed QR Code Lab? Use the ADMIN_KEY from your existing script in step 2 before copying an updated script. Keep the same Web app URL.
- Create or open a Google Sheet.
Create a sheet →, then choose Extensions → Apps Script.
- Copy the setup script.
For a new sheet, copy this script into the editor. Its ADMIN_KEY matches the key in step 2. For an existing script, enter its current ADMIN_KEY in step 2 first.
- Save, select
setup, and click Run.Approve Google's requested spreadsheet access. The script creates a Scans tab and two hidden record tabs. It preserves existing tabs.
- Deploy as a Web app.
Choose Deploy → New deployment → Web app. Set Execute as: Me and Who has access: Anyone. Click Deploy and copy the URL ending in
/exec. For an existing deployment, choose Deploy → Manage deployments → Edit → New version → Deploy after saving the updated script.
Your Google Workspace administrator may restrict public Web app deployments. Google Apps Script quotas apply.
2. Connect and create your Site ID
Your site is ready
Use this Site ID to sign in on your other devices.
This key is shown only once. Keep it somewhere private so you can sign in if your passkey is unavailable.
Set up a passkey
Use Face ID, Touch ID, your device passcode, or a supported authenticator for sign-in.
No app-imposed passkey limit.
Site ID sign-in on this device
Enable this after saving your recovery code. Anyone using this browser can sign in with your Site ID while enabled.
QR codes
Create a QR code and record scans in Google Sheets.
Recent QR activity
Last 30 days · Melbourne
Daily scan counts will appear here.
Refresh to load your last 30 days of scan activity.
Daily scan counts
| Date — Melbourne | Scans |
|---|
Create a dynamic QR code
QR code preview
Enter a destination URL
Create the QR code to enable downloads and scan tracking.
My QR codes
Saved QR codes from your Google Sheet.
How to update Apps Script
- Open your Google Sheet → Extensions → Apps Script. Replace the code with the downloaded script and save.
- Choose Deploy → Manage deployments, edit the existing deployment, then select New version → Deploy. Keep the same deployment URL.
The download contains your existing private connection key. Keep it private.
Your connected Google Sheet
Refresh to load your connected Google Sheet.
Update Apps Script below to add the Activity tab to your Google Sheet and load the complete 30-day history here.
Update Google Sheets features
Download the current script, then open your Google Sheet → Extensions → Apps Script. Replace the code and save.
Download updated Apps ScriptChoose Deploy → Manage deployments, edit the existing deployment, and choose New version → Deploy. Keep the same deployment URL, then refresh QR Code Lab. The Activity tab and its graph appear automatically.
The download contains your existing private connection key. Keep it private.
Scan log
Saved in your Google Sheet’s Scans tab.
| Date | Time — Melbourne | QR code |
|---|
Create a QR code, then scan it to record your first visit.
In Google Sheets, select the Scans tab to see this log. Link opens include repeat visits. The app shows the latest 100 entries.
Install QR Code Lab
Add QR Code Lab to your Mac or Home Screen.
The iPhone/iPad profile launches a full-screen web app. Installers are unsigned and require internet access. Installation and removal guide.