How to Verify Email and Add Data to Google Sheets for Typeform Submission Using Pabbly Connect

Learn how to verify emails and add data to Google Sheets from Typeform submissions using Pabbly Connect. Step-by-step guide for seamless integration. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Getting Started with Pabbly Connect

To verify email addresses and add data to Google Sheets from Typeform submissions, we will use Pabbly Connect. First, sign up for a free account on Pabbly Connect and log in to your dashboard.

Once logged in, click on ‘Create Workflow’ to begin your integration setup. You can name your workflow, for example, ‘Typeform to Email List Verify and Google Sheets.’ This will help you keep track of your automation processes.

2. Setting Up Typeform Trigger in Pabbly Connect

In this section, we will set up the Typeform trigger in Pabbly Connect. Start by selecting Typeform as your application in the trigger window. Choose the event as ‘New Entry’ to capture form submissions.

• Select ‘Typeform’ from the app dropdown.
• Choose the trigger event as ‘New Entry’.
• Click on ‘Connect’ and add a new connection to your Typeform account.

Once connected, you will see a dropdown with all your Typeform forms. Select the form you wish to use for this automation, such as the ‘Webinar Registration Form’. After selecting the form, click on ‘Save and Send Test Request’ to fetch the latest submission data.

3. Verifying Email Address Using Email List Verify

After setting up the Typeform trigger, the next step is to verify the email address captured from the Typeform submission using Pabbly Connect. In the action window, search for ‘Email List Verify’ and select the action event as ‘Single Email Verify’.

• Connect your Email List Verify account by entering the API key.
• Map the email address from the Typeform response to the Email List Verify email field.
• Click on ‘Save and Send Test Request’ to verify the email address.

After sending the test request, you will receive a response indicating whether the email address is valid. If it is valid, you can proceed to add the Typeform submission data to Google Sheets.

4. Adding Data to Google Sheets

Now that we have verified the email address, we will add the Typeform submission data to Google Sheets using Pabbly Connect. In the action step, select ‘Google Sheets’ and choose the action event as ‘Add New Row’.

Connect your Google Sheets account by signing in. Select the spreadsheet and sheet where you want to add the data. Map the Typeform responses to the corresponding columns in Google Sheets.

After mapping all the required fields, click on ‘Save and Send Test Request’. You should see a confirmation that the data has been added successfully as a new row in your Google Sheets.

5. Filtering Invalid Emails Before Adding to Google Sheets

To ensure that only valid email addresses are added to Google Sheets, you can set up a filter in Pabbly Connect. This filter will check if the response from Email List Verify is ‘OK’ before proceeding to add the data.

Add an action step and select ‘Filter’ from the app options. Set the filter condition to check if the response equals ‘OK’. If the filter condition is true, the workflow will continue to add data to Google Sheets.

This filter ensures that if the email address is invalid, the workflow will stop, preventing any incorrect data from being added to your Google Sheets.

Conclusion

Using Pabbly Connect, you can efficiently verify emails and add data from Typeform submissions to Google Sheets. This automation saves time and ensures data accuracy by only adding valid emails to your records.