Collect signups for a waitlist and verify emails before saving them to Google Sheets. People enter their details, receive a code by email, and confirm it. Ideal for product launches, beta access, and event interest lists.

Signups begin on an n8n form. The flow cleans the email and names, generates a random code, and writes the record to Google Sheets with append or update. It then sends the code by SMTP email and asks the user to enter the code on a second form. An If check compares the codes and keeps the user in a simple loop until it matches. Once verified, the sheet marks the user as verified and a final form collects the intended use, which is also saved.

You need Google Sheets access and an SMTP sender. Set up the sheet columns, connect credentials, and adjust the email message and form copy. Expect fewer fake emails, cleaner data, and less manual list work. Using a verified flag supports faster follow up and safer outreach. Teams running launches can reduce list cleanup from hours to minutes while keeping contacts organized.

• Form trigger collects first name, last name, email, and company
• Data cleaning standardizes email to lowercase and trims spaces
• Random code generator creates a one time verification code
• Google Sheets write uses append or update to avoid duplicates
• SMTP email sends the code with a clear subject and message
• Verification form captures the code and supports a retry loop
• If check compares the stored code with the entered code
• Final form gathers intended use and saves it back to the sheet

• Reduce manual list cleanup from 2 hours to 10 minutes per 100 signups
• Improve data quality by standardizing emails and names by 90 percent
• Cut fake or throwaway emails by up to 80 percent with code checks
• Handle higher signup volume without extra staff by using a verification loop
• Connect forms, email, and Google Sheets in one clear flow
• Flag verified contacts for faster outreach and safer campaigns

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and SMTP. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheet with columns for Firstname, Lastname, Email, Company, Verification Code, Verified, and Intended Use.
4. Open the Google Sheets nodes in n8n. In the Credential dropdown, click Create new credential and follow the on screen steps to connect your Google account. Name the credential clearly, for example Google Sheets Waitlist.
5. In each Google Sheets node, select the correct Spreadsheet and Sheet. Keep operation as append or update so existing rows are updated by email.
6. Open the Send Email node. In Credential dropdown, click Create new credential and enter your SMTP server, port, username, and password. Set From Email to a verified sender. Send a test email to confirm delivery.
7. Review the email subject and HTML message. Keep the code placeholder so the unique code is included.
8. Check the form nodes. Update titles, descriptions, and field labels to match your brand. Make the code field required.
9. Activate the workflow so the form links and webhooks go live. Open each form node to copy the public link if needed.
10. Run an end to end test: submit the first form, confirm the sheet entry with code, receive the email, enter the code, and submit the final form. Verify the Verified flag and Intended Use are saved.
11. Troubleshoot: if emails do not arrive, confirm SMTP credentials and domain settings. If the sheet does not update, check the document ID and append or update mode. If codes never match, confirm the If node compares the correct fields.