With our Zapier integration, you can easily integrate Verifalia’s email verification service with more than 6,000 apps without the help of any developer: read about what Zapier is and how it works, if you are new with that tool.
The Zap action named Verify Email Address verifies, as the name suggests, a single email address in real-time with Verifalia: it checks if it is properly formatted, really exists and can accept mails, if it is a free or a business mail, flagging spam traps, role accounts, disposable and catch-all addresses - following all the 28+ steps of our email verification process. If you need to verify lists of email addresses in bulk use the Verify List of Email Addresses Zap action, which supports duplicated emails detection and can import / export your data in multiple file formats.
As an integration example, in this article we will show you how to create a Zap that connects Verifalia with Google Sheets, so that every time you add or change an email address on a Google Sheets spreadsheet, Verifalia will verify that email address and you will get its deliverability status in the adjacent column in the source spreadsheet. With this Zap, we aim to achieve three goals:
- pull in every new (or updated) email address from the spreadsheet;
- use our email list cleaner to verify the new emails;
- return the verification results from Verifalia into the spreadsheet.
Prerequisites
What do you need to connect Verifalia and Google Sheets through Zapier?
- A Verifalia account: you can register for a free Verifalia account if you don't have one already, and get 25 free email verifications per day.
- A Google account: a Google account and a Google Sheets spreadsheet are needed specifically for our Zap. Before you begin, it is necessary to set the following columns with headers;
-
- Email column – this is the source where Zapier will get your emails from;
-
- Deliverability column – this is the destination, where Zapier will store the deliverability results from Verifalia, like Deliverable, Undeliverable and Risky;
-
- Status code column (optional) – this an additional destination column which may be added in the event you wish to obtain the exact reason why Verifalia returned a specific deliverability result, like MailboxDoesNotExist, MailExchangerIsHoneypot, etc. - see the complete list;
- A Zapier account: create a free Zapier account, if you don't have one already.
Step-by-step
Now let’s get started with a step-by-step guide to help you create a Zap between Google Sheets and Verifalia.
Step 1
Log into your Zapier account and click the Create a Zap button from the menu shown on the left side of the page.
Step 2
Next, set up the Trigger, which will determine when to start the Zap: on the Choose app & event section click on Google Sheets. If that option is not available, type Google Sheets in the Search apps... text box - once the app appears in the list, select it.
Step 3
Choose the Google Sheets trigger named New or Updated Spreadsheet Row in the Choose an event drop-down list, which will cause Zapier to perform the following actions whenever a spreadsheet is updated; then click Continue.
Step 4
Click Choose Account and enter the credentials for your Google account, then grant Zapier permission to access your Google Sheets. Then, click Continue.
Step 5
Choose the specific spreadsheet you want to use in the Zap, then select the worksheet you want to use (if more than one are available). The system will automatically display all the spreadsheet files that you have stored in Google Drive. Finally, choose as the trigger column the one which contains the email addresses to verify. Then, click Continue.
Step 6
In the Test trigger section, click the Test Trigger button: a summary of the trigger configuration will be shown - check the details to see if everything is correct, then click Continue.
Step 7
Now it is time to set up the first action. At this stage, the system is aware of which spreadsheet to process and where to check for any changes or new additions and you only need to configure the actions to perform next. In the App Event section, search for Verifalia and select it.
Step 8
In the Action Event section select the Verify Email Address option, then click Continue, followed by Choose Account, so that you can finally connect your Verifalia account with Zapier: once the authentication interface is shown, enter your Verifalia user-name and password. Then, select Yes, Continue.
🛡 Using a dedicated user
For added security, create and use a dedicated Verifalia user for Zapier: to do that, log into Verifalia and create a new user, which you can name something like 'Zapier User'. Ensure that all the permissions are granted, according to your use case: to take full advantage of our Zapier integration, you may want to grant the Submit jobs, Specify quality level, View own job data, List own jobs and Delete own jobs permissions as well as everything in the Quality levels and Credits sections).
Step 9
Configure your source data: in the Email Address To Verify field select the column that contains the email addresses in your spreadsheet. While only that field is required, you can also adjust every single detail of processing of your lists, including the expected results quality level (through the Expected Result Quality Level field) and the data retention period (for specific privacy/security compliancy).
After that, click Continue.
Step 10
Zapier will show a summary of your setup you can review. Click Test & Continue to proceed and, If everything is correct, Zapier will show the message Test was successful!: in addition, the result of a test email verification will be shown. At this point Zapier will ask if you want to turn on your Zap: before turning it on, we need to take another step, so that the Zap will add the results of the verification to your spreadsheet. For that, click the Close button, then click the + icon below the Verify Email Address in Verifalia to include a new Action step.
Step 11
Choose the app that performs the intended action: search for Google Sheets, and click Update Spreadsheet Row, then click Continue; in the Choose account screen select your Google Account (authorize using your Google credentials, if needed) and click Continue.
Step 12
To update the original source spreadsheet, choose the same file and worksheet you selected in the Trigger step, as mentioned above. Next, click the drop-down list under Row and, from there, the Custom tab. Then, click New or Updated Spreadsheet Row in Google Sheets to expand it and select Row ID from the items.
As soon as you select the Row ID value, Zapier will present a list of the available columns in the target spreadsheet: for the Classification field, select Verify Email Address in Verifalia, click Show all options and, from there, pick the Classification item. That field will host the email address deliverability result (i.e. Deliverable, Undeliverable, Risky and Unknown) in your spreadsheet. Then click Continue; should you wish to grab the exact verification result code (like MailboxDoesNotExist, MailExchangerIsHoneypot, etc. - see the complete list, select the Status field instead.
Along with each email verification result, Verifalia includes several additional fields you may want to select, if you are interested in an in-depth email validation analysis: this tutorial only uses the Classification field for easy reading: find out more about our verification result here.
Step 13
Click Test Action and, after Zapier has finished checking your configuration, click Close.
At this point, the Zap is ready - congrats! 🏆
Tap the switch to activate your Zap.
Final consideration and tips
We recommend that you do a manual test of your Zap, to make sure everything is working correctly: open the spreadsheet in Google Sheets and insert a new row filling the Email column. Wait for a couple of minutes (the exact time depends on your Zapier plan), then check your spreadsheet again: the email verification results should have been pasted into the expected cells.
The integration steps explained above are just one of the many ways you can use Verifalia’s email verification service on Zapier. Zapier's library includes over 6,000 apps, so there is a high chance they support the ESP or CRM you are already using: check the list of their supported apps. In minutes, you can create Zaps without any coding skills and connect Verifalia with thousands of different apps and services, automating your daily tasks with ease.