Mail7 for Google Sheets
Email validation inside Google Sheets with one formula
Verify addresses right where your list already lives. Type =MAIL7(A2) and get an honest Valid, Not Valid or Unknown for that row, so questionable addresses get flagged rather than silently dropped.
Not on the Google Workspace Marketplace yet - add the Apps Script directly today.
How it behaves
The =MAIL7() formula: validate any cell
Point the formula at a cell holding an email, like =MAIL7(A2), and it returns Valid, Not Valid or Unknown for that address. Fill it down a column to score an entire list without leaving the sheet.
Valid, Not Valid, Unknown: read the result honestly
Every row gets one of three honest answers, so you can sort and filter your list without throwing away real contacts:
Validate a whole column from the menu
Select a column of emails and choose the Mail7 menu item to validate the range in one pass. The status is written to the column on the right, with a (disposable) note where it applies, so you keep the original addresses intact.
Format, MX and SMTP mailbox check behind each result
Each cell result is a real verification, not a syntax guess: Mail7 checks the address format, looks up the domain’s MX records, and probes the mailbox over SMTP. That is why a well-formed address can still come back as Not Valid, and why an uncertain one is honestly marked Unknown.
Setup
Add the Apps Script in two minutes
-
Step 1
Open Apps Script
In your sheet, go to Extensions, then Apps Script.
-
Step 2
Paste the script
Paste Code.gs into the editor and add the manifest from Project Settings.
-
Step 3
Reload the sheet
A Mail7 menu appears and =MAIL7(...) works as a formula. Set an API key from the menu for large sheets.
Questions
Frequently asked questions
How do I validate one cell?
Use =MAIL7(A2); it returns Valid, Not Valid or Unknown for that address.
Can I validate a whole column at once?
Yes, the validate-a-column menu item processes the selected range.
What does Unknown mean in a cell?
The mailbox could not be confirmed either way (catch-all, greylisting or a blocked SMTP), so it is flagged rather than marked invalid.
Do I need an account?
No. Single checks are free; paid plans add volume for large sheets.
Is the checker doing a real mailbox check?
Yes: format, MX records and an SMTP mailbox probe, not just a syntax test.
Related integrations
Free single checks, paid plans for volume
Single checks are free with no account, so the formula works right away. For large sheets, set a Mail7 API key from the menu to lift the anonymous rate limit, and a paid plan raises your volume. You are only charged for definite Valid and Not Valid results; Unknown checks are always free.