Is this email verifier free?

Yes. This page checks up to 3 addresses per run and shows up to 5 results, with no install and no payment. To verify a full list, install SheetMagic for free; the free plan includes 100 one-time scraping credits, and verification runs use those credits.

What does each result mean?

Result reads Valid, Invalid or Catch-all. Invalid means the address will bounce. Catch-all means the domain accepts any address, so delivery is uncertain. Quality rates the address, for example risky or bad, and Detail gives the reason behind the result.

How many addresses can I verify?

This page checks up to 3 addresses per run and shows up to 5 rows. With SheetMagic installed, one Email validator job accepts up to 1,000 addresses. Each run costs 40 scraping credits plus 6 per address, so the free 100 credits cover one run of up to 10 addresses.

What data do I get for each address?

Five columns: Email, Result (Valid, Invalid or Catch-all), Quality (for example risky or bad), Detail (the reason behind the result) and Free Provider, which tells you whether the address uses a free mailbox like Gmail.

How do I verify emails in Google Sheets?

Install SheetMagic from the Google Workspace Marketplace and click Activate. Then type =VALIDATEEMAIL(A2:A10) in an empty cell, pointing at your column of addresses. The results appear next to the cell once the check finishes, one row per address.

Am I allowed to verify email addresses?

Checking whether an address can receive mail is a routine list-cleaning step. You are still responsible for having a lawful reason to email the people on your list under the rules that apply to you, such as CAN-SPAM or GDPR.

Does a Valid result mean my email will reach the inbox?

No. Valid means the address looked deliverable when it was checked. It does not predict spam filtering, and Catch-all domains cannot be confirmed either way. Verify close to your send date, because mailboxes are closed and created all the time.

Free Email Verifier for Google Sheets

Paste a few addresses and see which ones will bounce, which are risky and which use a free provider like Gmail. Install SheetMagic to verify your whole list in Google Sheets.

Your results

Run a search above. The rows land in this sheet.

Row	Email	Result	Quality	Detail	Free Provider
1
2
3
4
5
6
7
8

Install SheetMagic to get every result in Google Sheets

The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.

Install free for Google Sheets

Free email verifier for Google Sheets, in short

To verify email addresses in Google Sheets for free, install the SheetMagic add-on, click Activate, and type =VALIDATEEMAIL(A2:A10) next to your list. Each address gets its own row with a result (Valid, Invalid or Catch-all), a quality rating, a detail code and whether it uses a free provider. The free plan includes 100 one-time scraping credits.

5 columns for every result

Each result is one row, with these columns in this order. Fields the source does not show stay blank.

Email
Result
Quality
Detail
Free Provider

From this page to your sheet

1. Check a few addresses here
Type up to 3 addresses and your email, then run it. You see the result for each address on this page, no install needed.
2. Install SheetMagic for free
Add SheetMagic from the Google Workspace Marketplace and click Activate. No card and no separate account.
3. Verify the whole list in Sheets
Point =VALIDATEEMAIL at your column of addresses. Every result is written into your sheet, one row per address, ready to filter before you send.

Who uses it, and for what

Clean a cold outreach list before sending

Sales and lead gen teams run the list through the verifier, drop the Invalid rows and set Catch-all addresses aside before a campaign goes out.

Check leads you scraped or bought

After pulling contacts from websites or a lead list, run the emails column in the same sheet to see which addresses will bounce before they reach your CRM.

Sort signups by address type

Marketing teams paste an export of newsletter or trial signups and use the Free Provider and Quality columns to separate work addresses from Gmail-style and risky ones.

The same thing, inside Google Sheets

VALIDATEEMAIL takes one address, a list or a range. It runs in the background and writes one row per address into the cells next to it: Email, Result, Quality, Detail and Free Provider. Each run uses scraping credits, so start with a short range.

=VALIDATEEMAIL(A2:A10)

Type it in any cell once SheetMagic is installed.

Other ways to do it

Checking addresses by hand: Eyeballing each address or sending test emails works for a handful. It does not scale, and bounced test sends can hurt your sender reputation.
REGEXMATCH or ISEMAIL in Sheets: Free and instant, but they only check that the text looks like an email. They cannot tell you whether the mailbox exists or the domain accepts mail.
A standalone email verification service: Gives you the same kind of verdicts, but you export a CSV, upload it, wait, download the results and match them back to your sheet.
SheetMagic VALIDATEEMAIL: Runs inside Google Sheets on the column you already have. Results land next to your data, so you can filter and send without leaving the sheet.

Questions

Is this email verifier free?: Yes. This page checks up to 3 addresses per run and shows up to 5 results, with no install and no payment. To verify a full list, install SheetMagic for free; the free plan includes 100 one-time scraping credits, and verification runs use those credits.
What does each result mean?: Result reads Valid, Invalid or Catch-all. Invalid means the address will bounce. Catch-all means the domain accepts any address, so delivery is uncertain. Quality rates the address, for example risky or bad, and Detail gives the reason behind the result.
How many addresses can I verify?: This page checks up to 3 addresses per run and shows up to 5 rows. With SheetMagic installed, one Email validator job accepts up to 1,000 addresses. Each run costs 40 scraping credits plus 6 per address, so the free 100 credits cover one run of up to 10 addresses.
What data do I get for each address?: Five columns: Email, Result (Valid, Invalid or Catch-all), Quality (for example risky or bad), Detail (the reason behind the result) and Free Provider, which tells you whether the address uses a free mailbox like Gmail.
How do I verify emails in Google Sheets?: Install SheetMagic from the Google Workspace Marketplace and click Activate. Then type =VALIDATEEMAIL(A2:A10) in an empty cell, pointing at your column of addresses. The results appear next to the cell once the check finishes, one row per address.
Am I allowed to verify email addresses?: Checking whether an address can receive mail is a routine list-cleaning step. You are still responsible for having a lawful reason to email the people on your list under the rules that apply to you, such as CAN-SPAM or GDPR.
Does a Valid result mean my email will reach the inbox?: No. Valid means the address looked deliverable when it was checked. It does not predict spam filtering, and Catch-all domains cannot be confirmed either way. Verify close to your send date, because mailboxes are closed and created all the time.

All free tools

Free email extractorEnter a website and we read its homepage and the pages it links to, like Contact and About, for emails, phone numbers and social profiles. You see up to 5 results here; install SheetMagic free to get every result in Google Sheets.

Free plan

100scraping credits, one time

Run the full email verifier in Google Sheets.

Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.