Templates / Waitlist form stored in GoogleSheet with email verification step

Waitlist form stored in GoogleSheet with email verification step

Ready for 3.0

by Marcel Claus-Ahrens ✓ · 2,319 views · created 2024-11-15 · Lead Generation

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 (“Waitlist Form”). Along the way it connects Google Sheets.

How it runs

Trigger: When someone submits an n8n form (“Waitlist Form”).

  1. Clean and Standardize (Edit Fields (Set)): sets 2 fields: Email, Company Website
  2. Generate Random Verification Code (Crypto): hashes or encrypts values
  3. Add to Waitlist Sheet (Google Sheets): append or update
  4. Merge: merges the data from its input branches
  5. Send Verification Email (Send Email): sends an email over SMTP
  6. Validate with Verification Code (n8n Form): shows the next form page
  7. Get all Data from the Prev Form + Current (Edit Fields (Set)): sets or maps fields
  8. is the Code correct? (If): checks a condition and branches into true / false
  9. Save as Verified (Google Sheets): append or update
  10. Let the User Reenter Code (n8n Form): shows the next form page

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

Services it uses

Google Sheets

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

Instructions This automation streamlines the process of collecting user information using a Form Node, enabling individuals to join a waitlist managed via Google Sheets. It also generates a verification code, prompting users to input this code in the Second…

Excerpt from Marcel Claus-Ahrens'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.