HomeGuidesEmails in Google Sheets
How to find and verify emails in Google Sheets
Open Extensions, then Apps Script, paste the script below with your API key, and use =EFV_VERIFY(A2) to check an email or =EFV_FIND(A2,B2,C2) to find one. It's meant for a handful of rows. For a longer list, upload a CSV to Email Finder Verifier instead.
Free while in beta. No card needed.
Key takeaways
- The setup: paste one small script into Apps Script and add your API key.
- The use: a formula in a cell finds or checks one email at a time.
- The limit: good for a handful of rows. For a long list, upload a CSV.
Last updated 16 Nov 2026
Before you start
Our free email finder and email verifier work without a sheet, but a sheet lets you run a few rows in place. You need an API key. Sign up for a free account, open API keys in the dashboard, and make one named "Sheets". Use a separate key for this sheet so you can delete it on its own. See Create and manage API keys.
The two formulas do email verification and email finding one row at a time. Put your data in columns. For checking, one column of emails. For finding, one column each for first name, last name and company domain (the website, like acme.com).
Add the script
Open Apps Script
In your sheet, click Extensions, then Apps Script. A new tab opens.
Clear the sample code
Click in the box, select everything (Ctrl+A on Windows, Cmd+A on Mac) and delete it.
Paste the code below
Replace
YOUR_API_KEYwith your key. Keep the quote marks.Save
Click the save icon, then go back to your sheet tab.
const EFV_KEY = "YOUR_API_KEY"; // keep this sheet private
function EFV_VERIFY(email) {
if (!email) return "";
const url = "https://api.emailfinderverifier.com/api/v1/verify?email=" + encodeURIComponent(email);
const res = UrlFetchApp.fetch(url, { headers: { "X-API-Key": EFV_KEY }, muteHttpExceptions: true });
if (res.getResponseCode() !== 200) return "error " + res.getResponseCode();
return JSON.parse(res.getContentText()).verified;
}
function EFV_FIND(first, last, domain) {
if (!first || !last || !domain) return "";
const url = "https://api.emailfinderverifier.com/api/v1/find"
+ "?first_name=" + encodeURIComponent(first)
+ "&last_name=" + encodeURIComponent(last)
+ "&domain=" + encodeURIComponent(domain);
const res = UrlFetchApp.fetch(url, { headers: { "X-API-Key": EFV_KEY }, muteHttpExceptions: true });
if (res.getResponseCode() !== 200) return "error " + res.getResponseCode();
return JSON.parse(res.getContentText()).email || "not found";
}
Use the formulas
| You want to | Type this in a cell | You get |
|---|---|---|
| Check an email in A2 | =EFV_VERIFY(A2) |
TRUE if we confirmed the mailbox, FALSE if we couldn't |
| Find an email from first name A2, last name B2, domain C2 | =EFV_FIND(A2,B2,C2) |
The work email, or not found |
To find and then verify, put the find formula in D2 and a check in E2: =EFV_VERIFY(D2). A found email isn't checked yet, so always do both. Send only to the rows where E2 is TRUE.
An answer like error 429 means you went too fast. See Limits and common errors.
Keep it safe and small
- Don't fill a formula down a whole column. Every filled cell sends its request at the same moment. That breaks the speed limit (1 request a second, 5 at once) and you get
429errors. Google also stops a custom function that runs longer than 30 seconds. Try about five rows at a time. - Anyone who can edit the script can see your key. Use a dedicated key, delete it when you're done, and don't share the sheet with people you don't trust.
- Long list? Use Verify or find a list in the dashboard. It handles the speed for you. Save your sheet as a CSV (File, Download, Comma Separated Values) and upload it, up to 5,000 rows a run. See clean an email list.
If you have no key or no script
You can check a few addresses without any setup. Paste them one by one into the free email verifier and write the answer next to each row. It's slow, so use it only for a short list.
Get your API key and try it in a sheet. Free while in beta.
Sign up for free01FAQ
Questions, answered
01Can I verify a whole column at once?
Not with these formulas. Use Verify or find a list for a long list. It's built for the speed limit.
02Do I need to know how to code?
No. You copy the script, paste it and add your key. You don't need to understand it.
03Will the formula work on catch-all domains?
Yes. A catch-all email can come back TRUE. The free email verifier also shows if the domain is catch-all.
04Does a find use my allowance if nothing is found?
No. A find that returns nothing doesn't use your allowance.
05Is my API key safe in the script?
Anyone who can edit the script can see it. Use a key just for this sheet and delete it when you finish.
06Can I use Excel instead?
These formulas are for Google Sheets. In Excel, save a CSV and use the list tool, or use a tool like Clay. See Verify emails in Clay.
08Keep going
Where to next
- Outbound-led foundersCheck a list before it goes to a new domain. Find the gaps, verify, then send.
- Recruiters and staffing firmsFind a hiring manager's work email from name and company, then check it before you send.
- RevOps and sales opsCheck CRM contacts, re-find the ones that went bad, and re-import a cleaner list.
08Start today
Try it in your own sheet
Sign up with email or Google. No card. Your key and a ready-made first request are waiting. Need more later? Message us on Slack.