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:
Below is a step by step guide to creating a Zap between Google Sheets and DataValidation:
Log into your Zapier account and click on the Make a Zap! button at the top of the page.
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.
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.
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.
Click on Connect an account and put in the credentials for your Google account, then grant Zapier permission to access your Google Sheets.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Again, the system will test this step, after which you need to click on Finish.
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.
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.
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.
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.