Question 1

How do I validate a list of emails in Google Sheets?

Accepted Answer

With the address in A2, type =VERVE("emailvalidator", A2, "field", "isValid") in B2 and drag it down. Each row reads TRUE or FALSE, so you can filter the list down to the good ones. In Excel it's =VERVE.CALL("emailvalidator", A2, "field", "isValid").

Question 2

What does "valid" actually check?

Accepted Answer

That the address is well-formed and that its domain has a mail server set up to receive email (MX records). It doesn't send a message or log into the mailbox, so it can't promise a specific inbox exists — it catches the typos, dead domains and junk that make up most bad addresses.

Question 3

How do I find disposable or role-based emails?

Accepted Answer

Use the "isDisposable" field for throwaway services and "isRoleAccount" for addresses like info@, sales@ or support@. "isFreeEmail" flags Gmail, Yahoo and similar — useful when you only want company addresses.

Question 4

How much does it cost to validate a list?

Accepted Answer

Each address costs 20 credits, so a 1,000-row list is 20,000 credits. Validate once and paste the results as values if the list won't change — that way a refresh doesn't re-check it.

Question 5

How do I pull Validate Emails into Google Sheets?

Accepted Answer

Install the VerveSheets add-on, sign in once with your key, and type =VERVE("emailvalidator", "support@myspace.com", "field", "username") into any cell. The "field" argument names the value you want back, so the cell resolves to a single number or string you can chart, sort, or feed into another formula.

Question 6

What data can I pull from Validate Emails?

Accepted Answer

Validate Emails returns username, domain, isValid, isRegexValid and isMxValid, plus 5 more — name any one of them as the "field" argument and that value lands in the cell. Leave the field out and the whole record spills into a two-column table instead.

Question 7

Which Validate Emails fields need a paid plan?

Accepted Answer

suggestedCorrection and riskScore are included from the Starter plan up. On the Free plan the cell returns #PREMIUM(field) rather than a wrong or empty value, so it's always obvious which one to upgrade for. Every other field works on Free.

Question 8

Can I fill a whole column of Validate Emails at once?

Accepted Answer

Yes. Put your email values down a column and point the formula at the range — A2:A50 instead of A2 — and one call returns a value for every row. Dragging the formula down works too, but the range form is a single billed call per column rather than one per cell.

Question 9

How many credits does each Validate Emails cell cost?

Accepted Answer

Each resolved cell costs 20 credits. A cell only re-bills when it actually refreshes, so a sheet you aren't touching doesn't keep charging.

Question 10

Does Validate Emails work in Excel as well as Google Sheets?

Accepted Answer

Yes — same arguments, same key, same fields. Excel namespaces custom functions, so the call is =VERVE.CALL() there and =VERVE() in Google Sheets; nothing else about it changes.

Validate Emails

Clean a list before you send

Keep company leads only

Catch typos at the source

Validate Emails, answered

Put Validate Emails in your next spreadsheet. Add the extension, paste the formula, and the cell keeps itself current.

Scaling up?