# Google Sheets Integration for Email Validation

URL: https://email-validation.org/integrations/google-sheets/
Updated: 2026-11-10

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

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.

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

- Status: Setup guide
- One script, pasted into your sheet

**Your sheet after a run** Test addresses

Columns it fills

```text
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         remove
```

## 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**: 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 `Email` above your addresses, 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).
- **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/)

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

1. **Create a key**: Create an API key for the sheet with a daily credit cap.
2. **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.
3. **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.
4. **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](https://email-validation.org/docs/bulk/).

## Related

- [The full Google Sheets setup guide](https://email-validation.org/docs/guides/google-sheets/)
- [Google Sheets add-on: a cell function and bulk lists](https://email-validation.org/integrations/google-sheets-add-on/)
- [Add-on or template: which one to use](https://email-validation.org/docs/guides/google-sheets-add-on/#which)
- [Statuses and reasons: what each column value means](https://email-validation.org/docs/statuses/)
- [All integrations](https://email-validation.org/integrations/)