Guide

How to verify emails in Google Sheets

Google Sheets can check that an address looks right, but it can't tell you whether the mailbox exists. Here's how to do both, starting with the free part.

Updated November 17, 2026.

The short answer

To verify emails in Google Sheets, put the addresses in column A, install the Email Verification add-on, then choose Extensions › Email Verification › Open and click Verification. A status such as deliverable or not deliverable appears next to every row. For a free format-only check, use =ISEMAIL(A2).

There are two levels of checking, and they catch different problems:

  • Format check (free, built into Sheets): catches typos like a missing @, spaces, or a missing domain ending. It can't tell whether jane@company.com is a real inbox.
  • Mailbox check (needs an add-on): asks the recipient's mail server whether that address can receive mail. This is what catches dead mailboxes, fake domains and people who left the company. Nothing is sent to the address.

Method 1: check the format with free formulas

Flag badly formatted addresses

In cell B2, next to your first address, enter:

=ISEMAIL(TRIM(A2))

Drag it down the column. TRUE means the address is formatted like an email; FALSE means it isn't. TRIM ignores stray spaces, which are common in pasted lists.

Stop bad addresses being typed in

Select column A, then choose Data › Data validation › Add rule. Under Criteria pick Text is valid email, and set it to reject input. New entries that aren't formatted like an email are refused.

Find duplicates

=COUNTIF(A:A, A2) > 1

TRUE marks an address that appears more than once. Sending twice to the same person is an easy way to earn a spam complaint.

Where formulas stop: maria@gmial.com and old.employee@company.com both pass ISEMAIL. They look valid and will still bounce. Catching those takes a mailbox check.

Method 2: check every mailbox with the add-on

The Email Verification add-on (EVADDON) runs the mailbox check inside your sheet, so you don't export a CSV, upload it somewhere, and paste results back.

  1. Install it from the Google Workspace Marketplace. New accounts get 50 free verifications.
  2. Put your addresses in column A, one per row, starting in row 2. Row 1 is your header (for example, "Email").
  3. Open the sidebar: Extensions › Email Verification › Open.
  4. Click Verification. Lists of up to 100 addresses fill in row by row while you watch. Bigger lists, up to 250,000 addresses, run in the background; import them from Bulk Results when they're done.
  5. Filter and clean. Turn on a filter (Data › Create a filter), show only not deliverable, and delete those rows.

The setup guide explains the Google permission screen if you want to know what each permission is for.

What each result means

  • deliverable: the mailbox exists. Safe to send.
  • deliverable (shared inbox): a team address like info@ or sales@. It works, but may not reach one person.
  • deliverable? (catch-all, not confirmed): the domain accepts every address, so this one can't be confirmed. Your call; small batches are usually fine. More on catch-all.
  • inbox full (try again later) and unknown (mail server did not answer): no clear answer right now. Check again later.
  • not deliverable: invalid, disabled, throwaway, or spam-trap address. Remove it before you send.

When to verify

  • Before the first send to a list you bought, scraped, or collected at an event.
  • Before a campaign to an older list. People change jobs and abandon inboxes, so a list that was clean last year may not be now.
  • After importing sign-ups from a form, where typos are common.

FAQ

Can Google Sheets verify emails without an add-on?

Only the format. ISEMAIL and the Text is valid email data validation rule check that an address is shaped like an email. Sheets has no built-in way to ask a mail server whether the mailbox exists.

Does verifying send an email to my contacts?

No. The check asks the recipient's mail server whether it would accept mail for that address, then stops. Nothing arrives in anyone's inbox.

How many emails can I verify at once?

Up to 250,000 addresses in one run. Lists of 100 or fewer are checked immediately; larger lists run in the background.

Is it free?

The formulas are free. The add-on gives every new account 50 free verifications; after that you buy prepaid credits (one credit checks one address, packs start at $9, credits never expire). See pricing.

Can I verify emails in a Google Form's response sheet?

Yes. Form responses land in a normal Google Sheet. Copy the email column into column A of a new tab (or move it there) and run the add-on on that tab.

Ready to try it on your own list? Install Email Verification free and check your first 50 addresses.