Double opt in email verification system with Google Sheets
This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generat...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
This template implements a professional Double Opt-In email verification system using Google Sheets as a database. The workflow collects user emails, generates unique verification codes, stores them securely, and validates user access before proceeding with your main form.
How it Works
- User submits their email through an initial form
- System generates a unique 6-digit verification code
- Code is stored in Google Sheets along with user data
- Verification email is sent to the user
- User enters the code to verify their email
- Upon successful verification, user accesses the main form
Setup
Follow these steps to configure the workflow:
#### 1. Google Sheets Configuration
Create a Google Sheets spreadsheet with the following columns:
| Column Name | Data Type | Description | |----------------|-----------|--------------------------------------| | Start Date | String | Timestamp of form submission | | ID | String | Workflow execution ID | | Accepts Terms | String | Terms acceptance flag | | Email | String | User's email address | | Code | String | 6-digit verification code |
#### 2. Google Sheets Connection
- In n8n, go to Credentials
- Add new credential for Google Sheets OAuth2
- Follow the OAuth2 authorization flow
- In the workflow, update the "Store Data" node:
- - Replace `YOUR_GOOGLE_SHEET_ID` with your spreadsheet ID
- - Select the correct sheet tab
#### 3. SMTP Configuration
- Add SMTP credentials in n8n:
- - Go to Credentials > Add new > SMTP
- - Enter your SMTP server details
- - Configure port, username, and password
- Update the "Send Email" node:
- - Change sender email to your domain
- - Customize subject line and message body
- - Set reply-to address
#### 4. Form Customization
- **Entry Form**: Customize the title and privacy policy text
- **Email Form**: Update the description for your use case
- **Verification Form**: Modify instructions as needed
- **Main Form**: Add or modify fields for your requirements
Configuration
#### Email Settings
- **From Email**: Replace `no-reply@yourdomain.com` with your sender address
- **Subject**: Customize the verification email subject
- **Message**: Personalize the email template with your branding
- **Reply-To**: Set your support email address
#### Form Messages
- Update all form descriptions to match your brand voice
- Customize button labels
- Modify error messages for better user experience
Benefits
- **GDPR Compliance**: Ensures legitimate user consent
- **Spam Reduction**: Validates email ownership
- **Data Quality**: Maintains clean contact lists
- **User Trust**: Professional verification process
Use Cases
- Newsletter subscriptions
- User registration flows
- Marketing campaign sign-ups
- Lead generation forms
- Event registrations
Error Handling
The workflow includes: - Invalid code detection - Second attempt opportunity - Process restart option after multiple failures - Clear error messaging
Security Features
- Unique 6-digit codes for each session
- Temporary code storage
- Validation against stored data
- Multiple attempt limits
Tags Double Opt-In, Email Verification, Forms, Google Sheets, GDPR, Data Protection, Email Marketing, Lead Generation
Requirements
- n8n v1.0+
- Google Sheets account
- SMTP server access
- Basic understanding of n8n workflows
Support
For questions or issues with this template: 1. Check the sticky notes in the workflow for detailed explanations 2. Review the setup instructions above 3. Ensure all credentials are properly configured 4. Test with a personal email address first
Best Practices
- Test the complete flow before going live
- Monitor Google Sheets for verification attempts
- Set up email delivery monitoring
- Consider implementing code expiration (advanced feature)
- Keep form messages clear and concise
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
_Double_opt_in_email_verification_system_with_Google_Sheets.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Email & Outreach Workflows
View All in Email & Outreach →Abandoned cart recovery for Shopify via Gmail Google Sheets T
Who is this for? This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to reco...
Add new leads in Lemlist from Airtable
This workflow allows you to add new leads in Lemlist from Airtable. !workflow-screenshot Airtable node: This node lists all the emails that are stored in you...
Add Subscriber and Send Email Campaign
Production-ready n8n automation template for Add Subscriber and Send Email Campaign built by AhiXLight. Seamlessly connects Sendy with 3 configured nodes.
Add new contacts from HubSpot to the email list in Mailchimp
This workflow adds new HubSpot contacts to the Mailchimp email list. Prerequisites - HubSpot account and HubSpot credentials - Mailchimp account and Mailchim...