Email validation inside Google Sheets with one formula

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.

Add the Apps Script in two minutes

1. 1

   Open Apps Script

   In your sheet, go to Extensions, then Apps Script.

2. 2

   Paste the script

   Paste Code.gs into the editor and add the manifest from Project Settings.

3. 3

   Reload the sheet

   A Mail7 menu appears and =MAIL7(...) works as a formula. Set an API key from the menu for large sheets.

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.

Related integrations

Frequently asked questions