Knowledge Base > How It Works

How to integrate DataValidation with your favorite apps using Zapier

Zapier is an online utility that allows you to link and configure various online services to work together. You can create links (or Zaps, as they are called in Zapier) between DataValidation’s email list cleaner and more than 1,000 apps like spreadsheet apps, email service providers, and CRMs, to automate your email validation flow. A Zap is made up of at least two steps: step one is the Trigger and step two is the Action taken by the trigger.

Basically, when a certain event happens in app A, it will trigger app B to perform a set action. DataValidation lets you validate email addresses in real-time by using Zapier.

In this article we will show you how to create a Zap between Google Sheets and DataValidation, showing how to do email validation with Zapier. Our goal is to have Zapier pull in all new email addresses from aspreadsheet, validate them with our email list cleaner and push the DataValidation validation results back to the spreadsheet. Please keep in mind that the procedure might be significantly different when creating links with other apps. You can tailor the validation flow to suit your needs as Zapier is flexible and feature rich.

Prerequisites for using DataValidation with Zapier:

  • A Zapier account. You can sign up for a free account with limited functionality.
    The specific Zap that we're creating will work on a free Zapier account.

  • A DataValidation account with tokens available and a generated API key. You can generate an API key under Profile Settings
    in your DataValidation account. You can purchase tokens by clicking on the circle icon in the top-right side of the page.

  • For this particular Zap, you will also need a Google account and a spreadsheet in your Google Drive. In the Google spreadsheet, you will need to have the following columns with headers created in advance:

    • Email - the column that Zapier will pull your emails from
    • Grade - the column where DataValidation will push the grade it assigned to the email address
    • Disposable - here DataValidation will mark whether the email address is disposable or not (in the true/false format)
    • Role-based - here DataValidation will indicate whether the email address is role-based or not (in the true/false format)

Below is a step by step guide to creating a Zap between Google Sheets and DataValidation:

  1. Log into your Zapier account and click on the Make a Zap! button at the top of the page.
    Make a Zap!

  2. On the left side of the Zap creation page you will see the steps required to set up your Zap. Optionally, you can start by giving your Zap a name and adding some notes to it. Click on the Name your Zap…. To add a note, click on Add a note right below the Zap name, add the note in the field on the right, and click Save.

  3. Next, we will set up the Trigger, which is executed by Google Sheets. If you created a note, click on Choose app on the left panel. If you haven't created a note, you're already there. Type Google Sheets in the Search hundreds of apps… field and select it from the list that popped up.
    Choose a trigger app

  4. Now we will tell the app what we want the trigger to be. We want it to trigger the Action whenever we update our spreadsheet, so we will select New or Updated Spreadsheet Row and click Save + Continue.
    New or Updated Spreadsheet Row

  5. Click on Connect an account and put in the credentials for your Google account, then grant Zapier permission to access your Google Sheets.
    Connect an account
    Connect an account

  6. Next, select which spreadsheet file you'd like linked. Click on the drop-down icon next to the Spreadsheet field, and select the desired spreadsheet. You will notice the system automatically shows you all spreadsheet files that you have saved in Google Drive. Next, select the worksheet that you want the system to look into, following the same pattern. Next, under Trigger Column, select the column that contains the email addresses in your spreadsheet. After all this is done, click Continue.
    Select spreadsheet
    Select spreadsheet
    Select spreadsheet

  1. You will now see a summary of the trigger setup. Check if everything seems in order and proceed to test the connection by clicking Fetch & Continue. If everything is in order with the setup, the next screen will say Test Successful. If something went wrong, you will get an error message. If that is the case, review the settings from the previous steps, apply any necessary changes and repeat the test. Once everything is in order, click on Continue to proceed to the next step.
    Summary of the setup
    Test successful

  2. Next, you will set up the action step. The system now knows which spreadsheet to look for and where exactly to look for changes or new entries, and now it's time to tell the system what to do with the new or updated data it finds. Under Choose an Action App, type in DataValidation and select it from the drop-down list.
    Choose an Action App

  3. Next, you will see the only Action option is Verify Email, which is already selected. Click on Continue, and then click on Connect an account to connect to your DataValidation account. In the pop-up window put in your API key, which you can find or generate in your DataValidation account under Profile Settings. Click on Yes, Continue.
    Choose an Action App
    Save and continue
    API Key
    Grant access

  4. Next, it's time to set up the template. Under Email, click on the drop-down icon and select the column that contains the email addresses in your spreadsheet and click Continue.
    Select the email column

  5. At this point the system will give you the chance to verify if the setup is correct, before moving forward. If you can see an email address in the main field, click on Send Test to DataValidation, and the system will test this step. Just like in the previous step, if everything is in order, the next screen will say Test was Successful! and the validation results will be displayed for the email address that was tested. Click Finish if the test passed.
    Test DataValidation
    Test DataValidation

  6. Next, you will be asked if you are ready to turn on your Zap. We are not yet ready to do that, as there is one more step we need to complete before the Zap is functional, and that is pushing the validation results back to the Google Sheet. In the left-hand menu, scroll down to the bottom and click on the + button to add a new Action step.
    Push the validation results

  7. You will be required to select the app that will perform this step again. You will now have Google Sheets under Your apps. Click on it, then select Update Spreadsheet Row and click on Save + Continue.
    Update Spreadsheet Row
    Update Spreadsheet Row

  8. Next, you will notice that your Google account is already selected. You don't have to go through the login process again. Click on Save + Continue.
    Save and continue

  9. Then, once again, select the spreadsheet and the worksheet, as described in step 6 above. Then, under Row, do not click on Add Search Step, but instead click on the drop-down icon and scroll through the list and select Use a Custom Value (advanced). Then, under Custom Value for Row ID, scroll through the drop-down menu again and select Row ID. Then, if you scroll down, you will find the fields you created in your spreadsheet for the validation results, as mentioned in the prerequisites section of this article: Grade, Disposable, and Role-based. For each of these fields, you will need to click on the field and then select them from the drop-down menu 2. Verify Email. and then select the corresponding field — Grade, Disposable or Role-based respectively — and click Continue.
    Add Search Step
    Add Search Step
    Add Search Step

  10. Again, the system will test this step, after which you need to click on Finish.

  11. Now you are ready to turn your Zap on. Click on the switch to turn your Zap on and click on See it in your Dashboard.
    See it in your Dashboard

  12. At this point you will need to do another manual test, just to make sure everything is in order. Here's how to do that: go to your spreadsheet and enter a new entry in the Email column, then go to your Zapier Dashboard, where you will see your current Zap(s). Click on the drop-down button near the ON switch and click on Play, then watch the magic happen. Your Zap works as intended if no errors came up.Next, go back to your spreadsheet and check if the validation results were synced back in the correct column and row.
    Check sync
    Check sync
    Check sync

NOTE: We encourage you to read more about the meaning of the validation results here.

Please note that this is one of many ways you can use a Zapier integration with DataValidation's email list cleaner, but the basic principles are the same. Also, since Zapier's library includes over 1,000 online apps, there's a high chance that they support the ESP or CRM that you using. Feel free to browse through their supported apps list and start doing email validation with Zapier. Explore the possibilities and be creative! You can always count on our LiveChat support team for help in case you encounter any issues.

https://www.datavalidation.com/kb/20006-Zapier-Quick-Start-Guide.html

Zapier lets you connect DataValidation to over 1,000 other web services. Automated connections, called Zaps, can be set up in minutes, without any coding Zapier lets you automate your day-to-day tasks and build workflows between apps that otherwise wouldn't be possible.



comments powered by Disqus