Generate and validate bulk QR codes with Google Sheets and Google Drive
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Drive and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Get List (Google Sheets): uses Google Sheets
- Extract ID from Webhook (Edit Fields (Set)): sets 1 field: id
- Check is generated? (If): checks a condition and branches into true / false
- Check ID Exists (If): checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get List ID (Google Sheets): uses Google Sheets
- Not Valid (Respond to Webhook): sends the response back to the webhook caller
- QR Generator (HTTP Request): calls an HTTP API
- Not used? (If): checks a condition and branches into true / false
- Upload file (Google Drive): uses Google Drive
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - If
n8n-nodes-base.if - Google Drive
n8n-nodes-base.googleDrive - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set
From the author
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…