Waitlist form stored in GoogleSheet with email verification step
Ready for 3.0What 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”).
- Clean and Standardize (Edit Fields (Set)): sets 2 fields: Email, Company Website
- Generate Random Verification Code (Crypto): hashes or encrypts values
- Add to Waitlist Sheet (Google Sheets): append or update
- Merge: merges the data from its input branches
- Send Verification Email (Send Email): sends an email over SMTP
- Validate with Verification Code (n8n Form): shows the next form page
- Get all Data from the Prev Form + Current (Edit Fields (Set)): sets or maps fields
- is the Code correct? (If): checks a condition and branches into true / false
- Save as Verified (Google Sheets): append or update
- 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
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)
- Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Send Email
n8n-nodes-base.emailSend - n8n Form
n8n-nodes-base.form - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Crypto
n8n-nodes-base.crypto - n8n Form Trigger
n8n-nodes-base.formTrigger
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…