Integrations
Google Sheets integration
A ready-made Apps Script adds an Email validation menu to your sheet and fills a status, a reason, an action and a suggestion next to each address. Your key stays in your own user properties, never in a cell.
- Status: Setup guide
- One script, pasted into your sheet
Email Validation status Validation reason Validation action Did you mean
accepted@sandbox.email-validation.org valid accepted send
no_mailbox@sandbox.email-validation.org invalid no_mailbox remove
disposable@sandbox.email-validation.org disposable disposable removeAt 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
- Anyone who keeps addresses in a Google Sheet, such as an event list, a lead export or a newsletter list, and wants a status next to each one without leaving the sheet.
- You need
- A Google Sheet with the header
Emailabove your addresses, and an API key made for it, with a daily credit cap. - 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.
Clean a list before a send
Validate every row, then filter the sheet on the status column and remove what will bounce.
Check new rows
Run it again after adding rows: rows that already have a status are skipped, so only the new ones are checked.
Fix typos
The Did you mean column suggests a correction when an address looks like a typo of a common domain.
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 for the sheet with a daily credit cap.
Paste the script
Open Extensions, Apps Script. In a new project, replace everything in Code.gs with the script from the guide; if the project holds code of yours, add a new script file for it instead. Save.
Set your key
Reload the sheet and choose Email validation, Set API key. Allow the script to edit this spreadsheet and to connect to our API.
Validate all rows
Put the header Email above your addresses in row 1, then choose Email validation, Validate all rows.
Good to know.
- It sends 20 requests together, at most one batch a second, and writes each batch as soon as its answers arrive. An address in several rows is checked once.
- It never overwrites your data: it refuses to run when one of your columns sits where its results go, and writes plain text, never formulas.
- Anyone who can edit the sheet can also change its script, and changed code runs with your key when you use it: share the sheet only with people you would give the key to.
- Choose Email validation, Add test addresses to see every column filled for free. For very long lists, upload the file as a bulk list.
Updated · Maintained by the email-validation.org team