Check in participants via QR code with Google Sheets and Slack alerts
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs when someone submits an n8n form (“Session Check-In”). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: When someone submits an n8n form (“Session Check-In”).
- Workflow Configuration (Edit Fields (Set)): sets 9 fields: registration_sheet_id, roster_tab, schedule_tab…
- Screen For First Scan (Data table): row not exists
- Route Duplicate Scans (If): checks a condition and branches into true / false
- Look Up Registration (Google Sheets): uses Google Sheets
- Show Already Checked In Screen (n8n Form): shows the next form page
- Log Check In To Sheet (Google Sheets): append
- Record Dedupe Key (Data table): uses Data table
- Read Cohort Schedule (Google Sheets): uses Google Sheets
- Fetch Attendance History (Data table): get
- Compute Attendance Reachability (Code): runs custom JavaScript code
…plus 3 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 (8)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Data table
n8n-nodes-base.dataTable - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - n8n Form
n8n-nodes-base.form
From the author
Quick overview This workflow creates a QR-driven check-in kiosk that logs attendance to Google Sheets, prevents duplicate scans with an n8n Data Table, calculates each participant’s progress toward a required attendance threshold, and alerts coordinators in…