Generate and validate bulk QR codes with Google Sheets and Google Drive

This workflow allows you to generate QR codes (Barcodes) in bulk from a Google Sheets file and store the generated QR images automatically in Google Drive. Each QR code contains a unique identifier (in this template, an email address) and is connected to a validation webhook.

When a QR code is scanned, the webhook checks whether the ID exists and verifies its status. The system updates the spreadsheet to reflect whether the QR code has been generated and whether it has already been used.

This template demonstrates a simple but practical QR lifecycle system:

- Generate QR codes in bulk from spreadsheet data

- Store QR images in Google Drive

- Validate QR scans through webhook

- Track generation and usage status directly in the spreadsheet

Example use cases include event check-in systems, access control, membership validation, digital ticketing, or controlled asset distribution.