# Google Sheets Add-on for Email Validation

URL: https://email-validation.org/integrations/google-sheets-add-on/
Updated: 2026-11-06

> Documentation index: https://email-validation.org/llms.txt

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.

[Read the full setup guide](https://email-validation.org/docs/guides/google-sheets-add-on/) [Get an API key](https://email-validation.org/signin/)

- Status: Setup guide
- Your key kept per person

**In a cell** After Settings

Formulas

```text
=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 each
```

## At 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](https://email-validation.org/app/api-keys/) made for it, with a [daily credit cap](https://email-validation.org/docs/authentication/#limits), 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](https://email-validation.org/docs/guides/google-sheets-add-on/)

## 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](https://email-validation.org/docs/guides/google-sheets-add-on/), which stays the reference when a step does not match what you see.

1. **Create a key**: Create an API key with Validate addresses and Bulk lists, and a daily credit cap.
2. **Open Apps Script**: In a spreadsheet with no script yet, open Extensions, Apps Script and rename the project to Email validation.
3. **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.
4. **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.

## Related

- [The full Google Sheets add-on setup guide](https://email-validation.org/docs/guides/google-sheets-add-on/)
- [Google Sheets template: the simpler menu-only script](https://email-validation.org/integrations/google-sheets/)
- [The three permissions it asks for](https://email-validation.org/docs/guides/google-sheets-add-on/#permissions)
- [Bulk lists for very long columns](https://email-validation.org/docs/bulk/)
- [All integrations](https://email-validation.org/integrations/)