Your first 100,000 email verifications or 10,000 work emails found are on us.100K verifications or 10K finds, free.Sign up today

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

  1. Open Apps Script

    In your sheet, click Extensions, then Apps Script. A new tab opens.

  2. Clear the sample code

    Click in the box, select everything (Ctrl+A on Windows, Cmd+A on Mac) and delete it.

  3. Paste the code below

    Replace YOUR_API_KEY with your key. Keep the quote marks.

  4. 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 429 errors. 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 free

01FAQ

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.

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.