Templates / Check in participants via QR code with Google Sheets and Slack alerts

Check in participants via QR code with Google Sheets and Slack alerts

Ready for 3.0

by Kevin Yu ✓ · 18 views · created 2026-08-10 · Project Management

Ready 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 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”).

  1. Workflow Configuration (Edit Fields (Set)): sets 9 fields: registration_sheet_id, roster_tab, schedule_tab…
  2. Screen For First Scan (Data table): row not exists
  3. Route Duplicate Scans (If): checks a condition and branches into true / false
  4. Look Up Registration (Google Sheets): uses Google Sheets
  5. Show Already Checked In Screen (n8n Form): shows the next form page
  6. Log Check In To Sheet (Google Sheets): append
  7. Record Dedupe Key (Data table): uses Data table
  8. Read Cohort Schedule (Google Sheets): uses Google Sheets
  9. Fetch Attendance History (Data table): get
  10. Compute Attendance Reachability (Code): runs custom JavaScript code

…plus 3 more steps. See the full node list below.

Services it uses

Google SheetsSlack

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)

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…

Excerpt from Kevin Yu's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.