Validate QR tickets in real time with Google Forms and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets.
How it runs
Trigger: On Google Sheets events (row added).
- Select Latest Item (Code): runs custom JavaScript code
- Set Ticket Code Field (Edit Fields (Set)): sets 1 field: kode_tiket
- Read Trigger Sheet Rows (Google Sheets): uses Google Sheets
- Route by Conditional Rules (Switch): routes items into 2 branches
- Append Scan Results (Google Sheets): append
- Read Form Responses Sheet (Google Sheets): uses Google Sheets
- Select Latest Form Response (Code): runs custom JavaScript code
- Append to Scan Results Sheet (Google Sheets): append
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.
- Still check Always Output Data on multi-output nodes (If/Switch) now adds an empty item only when every output is empty (Route by Conditional Rules).
Nodes used (5)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
Automated QR Ticket Scanner & Validator This workflow is the perfect companion to the "Automated e-Ticket PDF Generator". It acts as a lightweight, automated check-in system for events. By pairing a simple Google Form with a mobile scanning app, it validates…