Integrations
Google Sheets add-on
The add-on gives your spreadsheet a cell function, =EV_VALIDATE, and a menu that validates whole sheets, sending more than 50 addresses as one bulk list. You copy its three files into your spreadsheet’s Apps Script project.
- Status: Setup guide
- Your key kept per person
=EV_VALIDATE(A2)
status here, reason in the cell to the right
=EV_VALIDATE(A2:A40)
one column of up to 50 addresses, two cells eachAt a glance.
- Status
- Setup guide. Not listed on a marketplace yet: you set it up yourself in a few steps, below and in the full guide.
- For
- Teams that share spreadsheets of addresses and want a formula for a few cells, a menu for whole sheets, and each person’s key kept to themselves.
- You need
- A spreadsheet with no Apps Script yet, and an API key made for it, with a daily credit cap, with the permissions Validate addresses and Bulk lists.
- Costs
- 1 credit = 1 validated address, as with any API request. Free: unknown results, API errors, malformed addresses and test addresses on sandbox.email-validation.org.
- Full guide
- Read the full setup guide
Typical uses.
Validate a whole sheet
Validate all rows fills four result columns; up to 50 addresses go as single checks, more as one bulk list it confirms with you first.
A formula for a few cells
=EV_VALIDATE checks an address where you type it, and keeps each answer for 6 hours so a recalculation in that time is free.
Long lists across runs
When Apps Script ends a run while a list is still being checked, the next run collects its results, with no new list and no new charge.
Set it up. 4 steps.
The short version of the full setup guide, which stays the reference when a step does not match what you see.
Create a key
Create an API key with Validate addresses and Bulk lists, and a daily credit cap.
Open Apps Script
In a spreadsheet with no script yet, open Extensions, Apps Script and rename the project to Email validation.
Copy the three files
Replace Code.gs, add an HTML file named Sidebar, turn on Show appsscript.json in Project Settings and replace that file, all from the guide. Save the project.
Allow and set your key
Reload, choose Extensions, Email validation, Settings, allow the three permissions, paste your key and choose the region.
Good to know.
- The cell function is off until the key’s owner ticks Allow =EV_VALIDATE in Settings, because every editor’s formulas in that spreadsheet then use the owner’s key and credits.
- After 6 hours a recalculated formula checks again and is charged again: paste results as values to keep them.
- Google may warn that it has not verified the app: the app is the copy in your own spreadsheet.
- Use the add-on or the template in a spreadsheet, not both: they share function names.
Updated · Maintained by the email-validation.org team