Email Validation
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
Click menu Extensions - Email Validation - Validate - Selection to process all content of the selected range.
Click menu Extensions - Email Validation - Validate - All emails to process the active worksheet cells with email like content.
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
Click menu Extensions - Email Validation - Batch Validation - Selection to process all content of the selected range.
Click menu Extensions - Email Validation - Batch Validation - All emails to process the active worksheet cells with email like content.
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
Click menu Extensions - Email Validation - Formulas - Update errors to update the formulas in an error state. This action may resolve some internal issues.
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.
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.
Click menu Extensions - Email Validation - Settings
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:
Set how to display results of verification
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
to validate
isEmailString(email)
Example
isEmailString(string)
Description
Checks whether a value is a valid email-like string
The value to be verified as an email address