top of page
horizontal lines
Gigasheet Primary logo
  • Will Andrews

Email Enrichment: Validate Email Address

Last month, we introduced our free email verification tool, an Email Enrichment that allows Gigasheet users to quickly clean and verify email lists. The Enrichment answered the following questions about an email address:

  1. Did we get valid email addresses?

  2. Are they real email addresses, or throw-away "burner" accounts?

  3. What company do they work for?

  4. Is the company big enough for us to care about?

But there was still one lingering question:

Will this email address actually work?

There are two ways to go check if an email is valid:

  1. Option 1 is to just give it the old college try and fire away, but this can lead to trouble!

  2. Option 2 is to use a third-party service that will validate the email address for you, taking the risk out of your email send.

Validating emails before sending will improve your delivery rate, and keep you in your target's inbox, not spam folder. We want to make the latter option easy, so Gigasheet's Email Enrichment now offers a quick and easy email validation option.

As part of the Email Enrichment, Gigasheet has enabled Abstract API's industry-leading email verification API. Simply provide your Abstract API code to Gigasheet to authorize the API, and you will be able to run the enrichment within Gigasheet. Abstract's evaluation of email address deliverability is returned in two columns within your sheet: Deliverability and Quality Score.

Below we will walk through setting up and running the improved Email Enrichment with email validation.

Use Gigasheet to check if email is valid

The Abstract API Key

If you don't have an API key from Abstract API, signing up is easy. You are given 100 free requests per month to evaluate the API results before any purchase, and no credit card is required to try it out. Simply navigate to the Email Validation and Verification API page and click the Get Started button.

Gigasheet uses the Abstract API to validate email addresses

Once signed in, you will find your private API key on the Try it Out tab. This is what you will copy and paste into Gigasheet. While you are here, you can also test the API using the Make test request button.

Abstract API for email validation

Filter Your Sheet to Abstract API Limits

In Gigasheet, Enrichments are only applied to the current results set. Thus, any rows that have been filtered out will not be enriched. Since we are using a trial version of the Abstract API key, we only can make 100 calls a month. Rather than burn through the API limit, let's try running the enrichment on the first 10 rows.

Pro Tip: Gigasheet always tracks the original row numbers in the column labeled "#". Use this in Filters to quickly select a certain number of rows.

Below we will create a filter to select only the first 10 rows. Once applied, we are ready to test the Email Enrichment.

Create a filter to limit the current result set in Gigasheet

Apply the Email Enrichment

The Enrichment tool is accessed from the Tools Menu and selecting Enrichments or by clicking on the desired column and selecting Enrich from the pop-up column menu.