Join us on the demo, while our product experts provide a detailed walkthrough of our enterprise platform.

How to Verify Email Addresses in Google Sheet

Directly checking email addresses for authenticity in the Google spreadsheet using EVA has never been easier. In this article, you will learn how to validate email addresses using EVA services in Google Sheets.

Narendra Pareek
Narendra Pareek
February 22, 2021
2 min read

Suppose, You have a massive amount of data and want to add them to your new product campaign. You are probably not sure that all of them belong to the right audience; some might be spam or disposable emails.

Now, the actual problem is that how can I do validate so many email addresses?

Well, it would be great to verify them all together in a single shot with 100% accurate results without any manual interaction.

I am writing this article as so many of us have the same concern and are looking for a business email validator that can resolve this problem with high accuracy.

Here we have the tool EVA (Email Verification APIs), which provides excellent email verification services with their open APIs.

EVA service with Google Sheet

Google allows you to create scripts using your custom functions with the service you wanted to use. You can make these functions in standard JavaScript with a basic understanding of JS. Here is the guide to start with Custom Functions in Google Sheets.

Custom Function

=eva(email)

Eva needs the email address only from you and the rest will perform with their excellent service. You can also go through the Email Verification API (EVA) article for more details about EVA.

Here is the custom function created using the EVA Services to validate email.

function eva(email) {
  var url = "https://api.eva.pingutil.com/email?email="+email;
  var res = UrlFetchApp.fetch(url);

  // Get status of the API
  var status = res.getResponseCode();
  if (status != 200) {
    return false;
  }
  var contextText = res.getContentText();
 
  var result = JSON.parse(contextText);
 
 // Logic to check Business Email
  if (result["data"]["disposable"] === false && result["data"]["webmail"] === false &&  result["data"]["spam"]  === false && result["data"]["deliverable"] === true) {
    return true
  }
  return false;
}

Add Script

We are all set with our script and now need to add this script under Google Script Editor under tools and save it.

Google Script

Run Script

That all! Now I need to drag this formula to the entire rows on which I want to perform validation.

Drag

Perfect :)

Setup Trigger

You can set up a trigger to action (i.e., on open, edit or change in sheet) by navigating tools -> script editor and click on the left alarm icon.

Trigger

Conclusion

In this article, I've explained EVA services to validate email addresses in bulk using the google script editor. If you like what you read, leave a "thank you note" in the comment section.


LoginRadius Docs

Implement Authentication in Minutes

click here

Most Popular Tags

EngineeringJavaScriptNodeJsReactCSSSecurityGoOAuthSocialLoginAuthentication

Are your customers safe on your application?

According to Forbes, data breaches exposed 4.1 billion records in the first six months of 2019. If this gets you worried, we’ve got your back!

LoginRadius protects your customers’ identities. We provide world-class security for your customers during login, registration, password setup, and any other data touchpoints, and make sure that their data is safe. We do so through by offering open source SDKs, integrations with over 150 third party applications, pre-designed and customizable login interfaces, and best-in-class data security products such as MFA, RBA, and Advanced Password Policies. The platform is already loved by over 3,000 businesses with a monthly reach of 1.17 billion users worldwide.Secure Your Application Now

Narendra Pareek

Narendra Pareek

Narendra is a Software Developer at LoginRadius, where he is utilizing his skills in different NodeJS and GO language projects. He has worked with different languages i.e PHP, AngularJS and also has a good knowledge of handling technical support.

View Profile

Try a Modern Authentication Solution

$0/ month

Free Sign Up
  • 5,000 MAU
  • 1 Web or mobile app
  • Standard login
  • 3 Social Login Providers
  • Transactional Email Template
  • Customizable Login Interfaces