write encoded QRC data to google sheets
Can a script be created so that encoded name: value pairs are written to a google sheet (as a single record) with the date/time of the scan, geolocation of the scan, and other "capturable" data at the time of scan?
Sure, for this we have webhooks:
Every time a QR Codes is scanned the following data is send in a webhook
The time when the event occurred
The user who created the voucher
The short URL of the QR Code (Voucher).
The secret API key from the user API. With this key you can validate a webhook request, that it comes from your account.
The number of how many times a QR Code has been scanned.
The number of unique Visitors that scanned the QR Code
The device that scanned the QR Code
os The operating system that scanned the QR Code
The country that QR Code has been scanned in
An optional lng/lat pair, when user submits his GPS coordinates
You can use this data to write a script called by the webhook to write data in a google sheet using their api