QR to Sheets — Frequently Asked Questions

Yes — a bulk generator at qrtosheets.com/tools/bulk-qr-codes, free and with no account needed. Paste a list or a Google Sheets column and get a QR code for every row, up to 500 at a time. Print them as an Avery-compatible label sheet or download them as PNG files. No watermark and no expiry, and the codes are generated in your browser so your list is never uploaded.

Yes. Paste the list into the free bulk QR tool and it lays out a print-ready label sheet. The 3x8 grid matches Avery L7160 and 5160 labels, 2x4 matches L7165 and 5163, and there are compact grids for student ID cards. The layout keeps every code above about 18mm so it stays reliably scannable once printed.

Sign up, connect your Google account in the admin, pick your spreadsheet and tab, then create a scanner link. Copy that URL and share it with your field team — when they open it on any phone browser and scan a QR code or barcode, the result appears as a new timestamped row in Google Sheets instantly.

Under five minutes from sign-up to deployed scanner link. You connect Google once, pick a spreadsheet, configure the scanner link, and the URL is ready to share. There is no developer setup, no IT ticket, and nothing to install.

The admin (you) needs a Google account to connect a Google Sheet. Field workers do not — they only need the scanner link URL.

QR codes and most standard 1D and 2D barcodes: Code 128, Code 39, EAN-13, EAN-8, UPC-A, UPC-E, ITF, and more. Scanning uses the device camera via the browser — no app required. Workers can also upload an image of a code or type a value manually if the camera is unavailable.

Any modern smartphone or tablet with a camera — iPhone (Safari), Android (Chrome, Firefox), and desktop browsers. The scanner link opens directly in the browser with no app install required.

Scans are saved to the device first, then synced to Google Sheets when the connection returns. Workers keep scanning normally even when signal drops — the data catches up automatically. Workers can also export a CSV backup at any time from the scanner screen.

Yes. One scanner link can be opened and used by any number of phones simultaneously. Each phone that opens the link counts as one registered device toward your plan limit.

Any spreadsheet in your Google Drive. You pick the spreadsheet and tab during scanner link setup using the built-in Google Drive Picker. Each scanner link can write to a different Google Sheets file — useful for separate locations, job types, or shifts.

By default, each scan appends a row to Google Sheets with: timestamp, scanned value, scanner email, organisation name, device type, and scan ID. Column layout can be customised per scanner link if you need specific columns or a different order.

Only drive.file — the narrowest possible scope. This means the app can only access files it creates or that you explicitly share with it via the Picker. It cannot see or touch any other files in your Drive. No broader spreadsheets scope is requested.

The app automatically refreshes your Google access token in the background. If reconnection is ever needed (e.g. you revoked access), go to Admin → Settings → Google connection and reconnect in one click.

Yes — on Premium you can create unlimited scanner links, each writing to its own Google Sheets destination, tab, and column layout. Free plan is limited to one active scanner link.

No. Workers open the scanner link URL — that is the entire worker-facing product. No sign-up, no login, no onboarding. The admin controls everything; workers only scan.

Yes. Each row written to Google Sheets includes a device identifier and scanner email (for logged-in admins scanning) or the scanner link name (for anonymous field workers). The admin dashboard also shows a per-device scan log.

A form collects details before anyone has a code to scan: registrations, sign-ups, enquiries, or lead capture. Every response becomes a row in your Google Sheet. A form can also POST to a webhook the moment it is submitted, email the person a confirmation, and generate them their own check-in QR code. You build it in the admin, style it with your own colours, then share the link or embed it on your existing site — and you can keep editing it after that, because a form is a live CMS rather than a one-time build.

Yes — this is what makes Forms a CMS rather than a form builder. Add, reorder, rename, hide or delete fields, rewrite the labels and help text, and change the colours on a form that is already taking responses. The change is live the moment you save it: there is no republishing step, the URL never changes, and an embed already sitting on your landing page updates itself without you touching that page. Editing cannot corrupt what you have already collected, because every response stores the field definitions exactly as they were at the moment it was submitted — so a row captured last week still reads correctly after you rename a field today. For that reason, hiding a field is usually better than deleting it: it disappears for visitors while the answers you already hold keep their meaning.

Yes, through the webhook. Paste one HTTPS webhook URL — a Zapier, Make, or n8n catch hook — on the form's Deliveries tab, and every response is POSTed there instantly. Each field arrives keyed by both its id and its visible label, including dropdown choices, so your automation shows readable names instead of raw ids. A failed delivery is retried with backoff up to five attempts, so a brief outage on your side delays the lead rather than losing it. The row still reaches your Google Sheet either way — the webhook is an addition, never a replacement. There is no CRM picker or field mapper in QR to Sheets on purpose: you map the fields inside your own Zap or scenario, where the rest of your automation already lives.

Yes. The Share tab gives you an iframe snippet you can paste onto Instapage, Wix, Squarespace, WordPress, Webflow, or anywhere else that accepts HTML. You can also just share the form link directly.

Turn on the confirmation email and each response generates that person their own check-in QR code, emailed to them. Scan it on arrival and their check-in is recorded in the same sheet as their sign-up, so registration and attendance sit side by side. The code opens a check-in page rather than a scanner link, so checking someone in never uses one of your device licences. Check-in is idempotent: scanning the same code twice shows the original arrival time instead of recording a second one.

The Free plan includes 1 form and 10 trial submissions in total — enough to watch a sheet row, a QR code, and a confirmation email all arrive once before you pay, but not enough to run anything real. Premium includes 2 live forms per registered device, so a 1-device plan has 2 forms and a 3-device plan has 6. Submissions are unlimited when the form's confirmation email is switched off. With confirmation emails on, the sends draw on your monthly email allowance: 2,000 a month plus 500 per extra registered device.

Nothing is rejected. The response is still saved, the row still reaches your Google Sheet, and the webhook still fires — only the confirmation email is held. Your registrants never see a billing message either: a closed form and a spent trial both read "not accepting new responses right now". If you are expecting a large event, email hello@qrtosheets.com and we will raise the allowance at no charge.

Start free with 300 scans, 1 device, 1 link, and 1 form with 10 trial submissions — no credit card required. Premium is $7/device/month for unlimited scans, unlimited links, 2 live forms per device, and as many devices as you need. Form submissions are unlimited when confirmation emails are off; with them on, the plan includes 2,000 emails a month plus 500 per extra device. No annual lock-in, cancel any month. Enterprise pricing available for large teams.

Each physical phone or tablet that opens a scanner link is registered as one device. One scanner link can be used by multiple phones simultaneously — you pay for the number of scanning stations, not the number of scans or workers.

Yes. Cancel from the Billing page in your admin — you retain Premium access until the end of the current billing period, then the account moves to the Free tier automatically. No cancellation fees.

The Events add-on is $25/month on top of an active Premium subscription. It is for inviting named guests by email and checking them in at a door: you upload or add your guest list, each guest gets a personal invitation with their own QR code, and scanning it at the entrance records their arrival. Most people do not need it. If you are running a recurring register — a class, gym members, shifts, a service, students — a normal scanner link does that job for far less. Choose the Events add-on when you have a named guest list to invite and admit once, not an attendance list you take repeatedly.

Events starts from a guest list you already have: you invite named people and admit them. Forms starts from people you do not know yet: they register themselves, and each registration can email them their own check-in QR code. Forms is included with Premium; Events is a separate $25/month add-on. For public sign-ups, Forms is usually the right tool. For a controlled invitation list, Events is. Both write to your Google Sheet and both share the same monthly email allowance.

Guest invitations draw on your workspace's monthly email allowance, which is shared with Forms confirmations: 2,000 a month plus 500 for each extra registered device. The counter resets on the 1st of each month. If you need a higher limit for a large event, contact us at hello@qrtosheets.com — we can increase it for your account.

Your Google account is never exposed to field workers. Workers only see the scanner screen — they have no access to your Google Sheet, other files in your Drive, or any admin settings. The app uses the narrowest possible Google permission (drive.file), meaning it can only access files it creates or that you explicitly share with it.

Yes. Scans are saved to the worker's device immediately when they scan. When connectivity returns — even hours later — the data syncs to your Google Sheet automatically. Workers keep scanning normally through dead zones, basements, and patchy site WiFi. They can also export a CSV backup at any time directly from the scanner screen.

Scan data is written directly to your own Google Sheet — you own it completely. QR to Sheets stores a copy in its database for the dashboard and sync queue, but your Google Sheet is always the primary record and you can export or delete it at any time.