Email Validation Add-on

Verify and clean email lists in the Google Sheets. Try our Email Validation Add-on today!
Suitable for batch checking lists of up to 500,000 entries.
See our Privacy Policy.

Validate

To validate emails in your spreadsheet

1. Click menu Extensions - Email Validation - Validate - Selection to process all content of the selected range.

2. Click menu Extensions - Email Validation - Validate - All emails to process the active worksheet cells with email like content.

3. Click menu Extensions - Email Validation - Validate - Noted as unknown to process the active worksheet cells with note “unknown”. API service may return “unknown” status for email in-process. You can review these cells after a while.

Batch Validation

To validate significant emails list in your spreadsheet

1. Click menu Extensions - Email Validation - Batch Validation - Selection to process all content of the selected range.

2. Click menu Extensions - Email Validation - Batch Validation - All emails to process the active worksheet cells with email like content.

3. Click menu Add-ons - Email Validation - Batch Validation - Noted as unknown to process the active worksheet cells with note “unknown”. API service may return “unknown” status for email in-process. You can review these cells after a while.

It is not recommended to use lists of more than 500,000 entries due to the limitations of Google Apps Script execution time.

Formulas

1. Click menu Extensions - Email Validation - Formulas - Update errors to update the formulas in an error state. This action may resolve some internal issues.

2. Click menu Extensions - Email Validation - Formulas - Replace selected with values to replace formulas with values in the selected range. It is useful to avoid API credits “leakage” due to periodical formula updates by Google Sheets.

3. Click menu Extensions - Email Validation - Formulas - Noted as unknown to process the active worksheet cells with note “unknown”. API service may return “unknown” status for email in-process. You can review these cells after a while.

Settings

The table owner can block access to the settings dialog for other users.

1. Click menu Extensions - Email Validation - Settings

2. To get a NeverBounce API Key click Get NeverBounce API Key link, sign-on, create a new project, copy API Key and paste it to the input field:

3. Set how to display results of verification

4. Click Save

Subscription

Check this add-on subscription status at Extensions - Email Validation - Subscription.

This add-on subscription does not cover NeverBounce API usage fees.

Trial and 1 sheet subscriptions are assigned to 1 spreadsheet only. Unassign it under subscription management to reuse in another spreadsheet.

Important note! 

The subscription is to be issued to 

- the owner of the document for spreadsheets on Google Drive;

- the person who first time used the add-on in the document on Google Team Drive.

Function List

validateEmail(email)

Example

validateEmail(string)

Description

Validate an email by using external API

email

to validate

isEmailString(email)

Example

isEmailString(string)

Description

Checks whether a value is a valid email-like string

email

The value to be verified as an email address