How to Create a Double Opt-In System to Verify Email with Pabbly Connect

Learn how to create a double opt-in email verification system using Pabbly Connect. This tutorial covers integration with Google Sheets, Gmail, and Formstack. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Verification

To create a double opt-in system, first access Pabbly Connect. Navigate to the Pabbly website and select the option to sign up or log in.

Once logged in, click on the ‘Access Now’ button for Pabbly Connect. This will take you to the dashboard where you can create workflows for automation.

2. Creating Workflows in Pabbly Connect

In this step, you will set up your first workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and name your workflow, for example, ‘Formstack to Google Sheets to Gmail’.

• Select Formstack as your trigger application.
• Choose ‘New Form Submission’ as the trigger event.
• Connect your Formstack account by clicking ‘Connect with Formstack’.

After setting up the trigger, save and send a test request to ensure that Pabbly Connect is receiving data from Formstack correctly.

3. Integrating Google Sheets with Pabbly Connect

Next, we will integrate Google Sheets with Pabbly Connect. In the action step, choose Google Sheets and select the action event as ‘Add New Row’.

Connect your Google Sheets account and select the spreadsheet where you want to store your form responses. Map the fields from Formstack to the corresponding columns in Google Sheets.

• Map the name, email, mobile number, city, and age fields.
• Leave the email verification status column blank for now.

Once the mapping is complete, save and send a test request to confirm that the data is being added to your Google Sheet.

4. Sending Verification Email Using Gmail

Now, configure the third action step to send a verification email using Gmail through Pabbly Connect. Select Gmail as the application and choose ‘Send Email’ as the action event.

Connect your Gmail account and set up the email details. Make sure to map the recipient’s email address from the Formstack submission. Use HTML formatting to create a professional email that includes a verification button.

Set the email subject to ‘Email Verification’. Add the HTML content with a verify email button that links to your webhook URL.

After filling in the email details, save and send a test request to ensure the email is sent correctly.

5. Updating Email Verification Status in Google Sheets

Finally, set up the second automation workflow in Pabbly Connect to update the email verification status. Create a new workflow named ‘Update Email Verification Status’ and select Webhook as the trigger application.

Copy the webhook URL generated by Pabbly Connect and use it in the verification email button. When a user clicks the button, the webhook will capture their information.

Use Google Sheets to look up the user’s email based on the webhook response. Update the email verification status in the corresponding row.

Save and send a test request to confirm the status is updated successfully in Google Sheets.

Conclusion

This tutorial demonstrates how to create a double opt-in email verification system using Pabbly Connect. By integrating Formstack, Google Sheets, and Gmail, you can automate the email verification process efficiently.