Templates / Register event attendance via webhook with Google Sheets and Gmail

Register event attendance via webhook with Google Sheets and Gmail

Ready for 3.0

by Prateeksingh Bais · 46 views · created 2026-07-07 · 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 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

  1. Check Input Validity (Code): runs custom JavaScript code
  2. Check Validity Status (If): checks a condition and branches into true / false
  3. Retrieve Sheet Data (Google Sheets): uses Google Sheets
  4. Return Error Response (Respond to Webhook): sends the response back to the webhook caller
  5. Identify Duplicates (Code): runs custom JavaScript code
  6. If: checks a condition and branches into true / false
  7. Return Duplicate Response (Respond to Webhook): sends the response back to the webhook caller
  8. Add New Entry to Sheets (Google Sheets): append
  9. Dispatch Confirmation Email (Gmail): uses Gmail
  10. Return Success Response (Respond to Webhook): sends the response back to the webhook caller

Services it uses

Google SheetsGmail

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 (6)

From the author

Quick overview This workflow powers a QR code-based event attendance system. A presenter displays a QR code (generated via the companion web app) which participants scan with their phones. Scanning opens a registration form pre-filled with the Event ID; on…

Excerpt from Prateeksingh Bais'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.