How to Verify Email Addresses in Google Sheets: A Complete Guide

By Swiftools Team · Published March 25, 2026 · 7 min read

Email verification is one of those tasks that seems optional — until it isn't. You've built a mailing list of 5,000 contacts over the past year. You craft the perfect campaign, hit send, and watch your bounce rate climb to 12%. Your email service provider flags your account. Your deliverability tanks. Future campaigns land in spam folders even for your most engaged subscribers.

This scenario plays out more often than you'd think, and it's almost entirely preventable. In this guide, we'll cover why email verification matters, what happens when you skip it, and how to verify email addresses in bulk directly inside Google Sheets.

Why Email Lists Degrade Over Time

No email list stays clean on its own. Research from various email marketing organizations consistently shows that email databases degrade by roughly 22-25% every year. The reasons are straightforward:

• People change jobs. That marketing director who signed up for your newsletter two years ago? She's at a different company now, and her old email bounces.
• Companies restructure. Domains change, email systems migrate, and old addresses stop working.
• Typos at signup. "gmial.com" instead of "gmail.com" — simple mistakes that create permanently invalid addresses on your list from day one.
• Abandoned email accounts. Free email providers eventually deactivate inactive accounts. That Yahoo address someone used five years ago may no longer exist.
• Spam traps. Some old, abandoned email addresses are recycled by ISPs as spam trap addresses. Sending to them signals that you're not maintaining your list.

The Real Cost of Bounced Emails

Bounced emails aren't just a minor inconvenience. They have real, measurable consequences:

Sender reputation damage. Every email service provider (Gmail, Outlook, Yahoo, etc.) tracks your sending behavior. A high bounce rate tells them you're not maintaining your list, which lowers your sender score. Once your reputation drops below a threshold, even your emails to valid, engaged subscribers start landing in spam.

ESP account suspension. Most email marketing platforms (Mailchimp, SendGrid, Brevo, etc.) have bounce rate thresholds. Exceed them and your account gets flagged, suspended, or terminated. Mailchimp's threshold, for example, is just 2% for hard bounces.

Wasted money. Most email platforms charge based on list size or emails sent. Every invalid address on your list is money you're paying to send emails that will never be read.

Distorted metrics. High bounce rates skew your open rates, click-through rates, and conversion metrics, making it harder to accurately measure campaign performance.

Types of Email Verification Checks

Professional email verification isn't a single check — it's a multi-layer process. Here's what each layer catches:

1. Syntax Validation

The first and simplest check ensures the email address follows basic formatting rules. A valid email needs a local part, an @ symbol, and a domain with a valid extension. This catches obvious typos and malformed addresses like "john@" or "[email protected]" or "john [email protected]" (spaces aren't allowed).

2. Domain Verification (DNS/MX Check)

Even if the format is correct, the domain might not exist or might not be configured to receive email. This check queries DNS records to confirm the domain has valid MX (Mail Exchange) records. For example, "[email protected]" would pass syntax validation but fail the domain check because that domain has no mail server.

3. Mailbox Verification (SMTP Check)

This is the most important check. It connects to the mail server for the email's domain and asks whether the specific mailbox exists — without actually sending an email. If you're checking "[email protected]," this step confirms that the "john" mailbox exists on company.com's mail server. This catches addresses where the domain is real but the user account doesn't exist.

4. Disposable Email Detection

Disposable email services like Guerrilla Mail, TempMail, and hundreds of similar providers offer temporary email addresses that self-destruct after a short period. These addresses technically work at the time of signup, but they'll bounce within hours or days. Detecting and flagging them helps you identify low-quality signups.

5. Catch-All Detection

Some mail servers are configured as "catch-all" — they accept email sent to any address at their domain, whether the specific mailbox exists or not. For example, [email protected] would be accepted. These addresses may or may not actually be monitored. Verification tools flag them so you can decide how to handle them.

How to Verify Emails in Google Sheets

If your email data lives in Google Sheets — and for many small businesses, marketers, and startups, it does — the most efficient approach is to verify emails directly in your spreadsheet. Here's how to do it using the VerifyEmail App add-on:

Step 1: Install VerifyEmail App

Open Google Sheets, go to Extensions > Add-ons > Get add-ons, and search for "VerifyEmail." Install it and grant the necessary permissions. The add-on needs access to read your spreadsheet data (to get the email addresses) and write results back.

Step 2: Prepare Your Data

Make sure your email addresses are in a single column with no merged cells. If your data includes names, companies, and other information, that's fine — just note which column contains the emails. Remove any blank rows within the data range, as they can cause verification to skip subsequent rows.

Step 3: Select and Verify

Highlight the cells containing email addresses, open the VerifyEmail add-on from the Extensions menu, and click "Verify." The add-on will process each address and write results in an adjacent column. You'll see statuses like "Valid," "Invalid," "Disposable," "Accept All," and "Unknown."

Step 4: Interpret the Results

• Valid — The email address exists and can receive mail. Safe to send.
• Invalid — The mailbox doesn't exist or the domain can't receive mail. Remove these immediately.
• Disposable — The address uses a temporary email service. Consider removing or flagging for manual review.
• Accept All — The server accepts all addresses. The email may or may not work. Use caution.
• Unknown — The verification couldn't reach a definitive result, often due to the mail server not responding. Retry later or flag for manual review.

Step 5: Clean Your List

Use Google Sheets' built-in filter feature to sort by verification status. Remove all "Invalid" addresses. For "Disposable" and "Unknown," decide based on your risk tolerance — conservative senders remove them; others may keep "Unknown" and retry later.

How Often Should You Verify?

The answer depends on how fast your list grows and how mission-critical email deliverability is for your business:

• Before every major campaign — If you send quarterly or less frequently, verify the full list before each send.
• Monthly — For active lists that grow consistently, monthly verification catches new invalid addresses before they accumulate.
• At point of capture — The gold standard. Verify each email address as it enters your system (e.g., at form submission). This prevents invalid addresses from ever reaching your list.

Best Practices for Maintaining a Clean Email List

• Use double opt-in. Require new subscribers to confirm their email address by clicking a link in a confirmation email. This eliminates typos and fake signups at the source.
• Remove hard bounces immediately. If an email hard bounces (permanent failure), remove it from your list right away. Don't retry.
• Re-engage or remove inactive subscribers. If someone hasn't opened or clicked your emails in 6-12 months, send a re-engagement campaign. If they still don't respond, remove them.
• Monitor your bounce rate after every send. Most email platforms report bounce rates. If it's climbing, your list needs cleaning.
• Don't buy email lists. Purchased lists almost always contain outdated addresses, spam traps, and people who never consented to hear from you. They're the fastest way to destroy your sender reputation.

Getting Started

If you manage email lists in Google Sheets, the easiest way to start verifying is with the VerifyEmail App add-on. Install it from the Google Workspace Marketplace, verify your first batch, and see the difference clean data makes in your next campaign.