Guide

Verify your email list before a Google Sheets mail merge

A mail merge sends from your own Gmail account, so every bad address on the sheet becomes your problem. Here's how to check the list first and send only to addresses that work.

Updated November 17, 2026.

The short answer

Before a mail merge from Google Sheets, remove duplicate rows, then run the Email Verification add-on to write a status next to every address. Filter the sheet to the rows marked deliverable, copy them to a new tab, and point your mail merge at that tab. You send only to mailboxes that exist, which protects the Gmail or Workspace account the merge sends from.

Why verify before a mail merge

A mail merge from Google Sheets sends from your own Gmail or Google Workspace account. That's true whether you use Gmail's built-in mail merge or a mail merge add-on. It has a few consequences:

  • Bounces come back to you. Every message to an address that doesn't exist returns as a bounce notice in your inbox. (Hard vs. soft bounces explains which ones matter.)
  • Bounces count against your sender reputation. Mail providers notice when an account keeps sending to addresses that don't exist. That can push your future mail toward spam folders, including your everyday one-to-one email.
  • Your sending can get paused. Too many bounces can get an account's sending limited for a while, which is a bad day if it's the account you use for work.
  • Dead addresses waste your daily limit. Gmail caps how many messages an account can send per day. A send to a dead address uses up one of those sends just like a real one.

Checking the list first costs less than finding out from bounce notices, and it happens before anything leaves your account.

Step by step

1. Build the merge sheet

Use one row per recipient, with headers in row 1. Put the email address in column A, starting in row 2, and leave column B empty. That's where the add-on writes each address's status. Put your merge fields, like First name and Company, in column C onward.

Merge tools usually match the fields in your template to the column headers, so keep header names short and consistent.

2. Remove duplicates

A duplicate row means the same person gets your email twice. Clean the addresses with =LOWER(TRIM(A2)) first, so "Jane@X.com " and "jane@x.com" match. Then choose Data › Data cleanup › Remove duplicates and check only the email column.

The full walkthrough is in how to remove duplicate emails in Google Sheets. Do this before verifying: each check costs one credit, so there's no reason to check the same address twice.

3. Verify the addresses

  1. Install the add-on from the Google Workspace Marketplace. New accounts get 50 free verifications, no card needed.
  2. Open the sidebar: Extensions › Email Verification › Open.
  3. Click Verification. Lists of up to 100 addresses fill in row by row. Lists of 101 to 250,000 run in the background; import them from Bulk Results when they're done.

The add-on asks each recipient's mail server whether it would accept mail for the address, then stops. Nothing is sent to anyone on your list. When it finishes, column B holds a status for every row. The verification guide covers this step in more detail.

4. Filter to the rows you'll send

First decide which statuses go into the merge (see which rows to send below). Then pull those rows out. You have two options.

Filter in place. Choose Data › Create a filter, click the filter icon on the Status column, and keep only the statuses you chose. This is fine for looking, but see the warning below before you merge from it.

Copy to a new tab. This is the safer option for a merge. Make a new tab, copy your header row into row 1, and enter this in A2:

=FILTER('Merge list'!A2:F, 'Merge list'!B2:B="deliverable")

Replace Merge list with the name of your tab and F with your last column. To include shared inboxes as well:

=FILTER('Merge list'!A2:F, ('Merge list'!B2:B="deliverable")+('Merge list'!B2:B="deliverable (shared inbox)"))

Then copy the results and paste them back as values only, so the merge list doesn't change if someone edits the source tab.

Why a separate tab? A filter only hides rows from view. Don't assume your merge tool skips hidden rows, because some tools read every row in the sheet. A tab (or a copy of the file) that holds only the rows you want takes the guesswork out.

5. Run the merge

Point your mail merge at the filtered tab or the copy, not the original list. Details are in run the merge below.

Which rows to send

  • deliverable: the mailbox exists. Include it.
  • deliverable (shared inbox): a team address like info@ or sales@. It works, but it reaches a team rather than one person. Include it if your message makes sense to whoever reads that inbox. A "Hi Jane" greeting may not.
  • deliverable? (catch-all, not confirmed): the domain accepts mail for every address, so this one can't be confirmed. It's your call. Read what a catch-all email is or the catch-all help note before you decide.
  • inbox full (try again later) and unknown (mail server did not answer): no clear answer right now. Leave them out of this send and check them again later.
  • not deliverable: invalid, disabled, throwaway, or spam-trap address. Don't send to it.

Run the merge

Use whatever mail merge tool you normally use. That might be Gmail's built-in mail merge, which is available on eligible Google Workspace plans, or a mail merge add-on from the Google Workspace Marketplace. The steps above work the same either way, because they only change which rows are in the sheet.

Keep the Status column, but test first. Many merge tools ignore columns your template doesn't use, so the Status column usually does no harm and leaves a record of why each person was included. Before the real send, make a tab with one row containing your own address and merge just that. Check the greeting, the merge fields and the formatting, and make sure nothing unexpected shows up in the message.

When to verify again

Addresses go bad over time as people change jobs and close accounts. If a list is old or you haven't sent to it in a while, verify it again before the next merge. Credits never expire and there's no subscription, so you can buy a pack once and use it whenever a merge comes up. See pricing. To check a single address instead of a whole list, see how to check if an email is valid.

FAQ

Does verifying my list send anything to my contacts?

No. The add-on asks each recipient's mail server whether it would accept mail for the address, then stops. Nobody on your list receives anything.

Will the Status column break my mail merge?

Usually not. Many mail merge tools ignore columns your template doesn't use. Test with a single row sent to your own address first to be sure.

Should I include catch-all addresses in a mail merge?

It's your call. A catch-all domain accepts mail for every address, so the check can't confirm that the mailbox exists. If you know the contacts and the batch is small, including them is usually reasonable. If you want the lowest bounce risk, leave them out.

How much does it cost to verify a list?

New accounts get 50 free verifications with no card. After that you buy prepaid credits: one credit checks one address, packs start at $9, and credits never expire. There's no subscription.

Have a merge coming up? Install Email Verification free and check your first 50 addresses before you send.