Event ticketing backend: auto QR tickets with Google Sheets & Gmail
Ready for 3.0What this workflow does
This workflow has 27 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Parse Barcode (Code): runs custom JavaScript code
- Get Rows (Google Sheets): uses Google Sheets
- Validate Input (Code): runs custom JavaScript code
- Get Tickets (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Valid Input? (If): checks a condition and branches into true / false
- Ticket Available? (If): checks a condition and branches into true / false
- Generate Ticket Data (Code): runs custom JavaScript code
- Get Participant (Google Sheets): uses Google Sheets
- Validation Error (Respond to Webhook): sends the response back to the webhook caller
…plus 14 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)
- Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Ticketing Backend automates registration, QR-ticket generation, email delivery, and check-in validation using Google Sheets, Gmail, and a webhook scanner — reducing manual ticket prep from ~3 hours to under 5 minutes for 200 attendees. Last updated: September…