Read QR code scan counts in Google Sheets
The spreadsheet option supplies a private, read-only CSV feed of your code names and scan counts. You choose where to use its address. It does not sign in to Google, create codes from spreadsheet rows or write changes back to ovbq.
Create the private feed
- Open Connections in your own account. Check that the spreadsheet feed is included in your current access.
- Name the feed and use its creation action. Save the private URL when it is shown; it is not displayed again.
- Review who can read the spreadsheet or other service before giving it that URL. Anyone who has the URL can request its CSV while the feed and its access remain active.
Keep the URL out of public pages, QR codes, support screenshots and shared examples. A spreadsheet formula and copies of the spreadsheet can expose it to collaborators. The feed address may also appear in the hosting provider's access logs; it is not a never-logged credential.
Choose a one-time import or a pull from the URL
For a one-time snapshot, retrieve the CSV and import the downloaded file. For a URL-based pull in Google Sheets, use its CSV import function in an empty area of your sheet. Replace this placeholder privately, not in a shared example:
=IMPORTDATA("PRIVATE_FEED_URL")Google receives the address and the returned CSV when it fetches the feed. Its refresh behavior belongs to Google Sheets; creating a feed does not promise immediate updates or continuous synchronization. External account requirements and limits still apply. No Google account or Drive permission is connected to ovbq through this method.
Check the columns and a sample result
code_key,name,scans_last_30_utc_daysThe feed covers your current, nondeleted codes that have not lapsed, including zero counts. It contains the code reference, its name and the recorded count for the last 30 UTC days. It does not contain form answers, code destinations or individual scan records. Code names can still reveal information, so share the sheet with care.
Check a sample against your account. This is an export of counts: changing a spreadsheet row does not edit the code, and rearranging rows is not an update command. Requests are rate limited; a 429 response means the consumer must wait before trying again.
Stop a feed you no longer use
Revoke it in Connections. Future requests with that URL stop working. Loss of the relevant account or tool access also stops reads. Revoking the feed does not recall CSV files, spreadsheet values or copies another service already saved.
To create distinct codes from spreadsheet rows, save a CSV and use the separate bulk creation guide.
Related: What scan counts show · Plans and access.