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

Help centerIntegrations

Use Email Finder Verifier in Google Sheets

Step by step: verify emails in Google Sheets with Email Finder Verifier by pasting a small Apps Script function. No coding skills needed.

Google Sheets is Google's spreadsheet app. You can teach it a new formula called EFV_VERIFY. Then you type it in a cell and it checks an email.

For this you paste a small script. A script is a short piece of code that a program runs. You only copy and paste. You don't need to understand it.

You need an API key first. See Create and manage API keys. Make one named "Sheets".

  1. Open your sheet

    Open the Google Sheet that has your emails. Put them in one column, for example column A, starting at row 2.

  2. Open Apps Script

    In the top menu, click Extensions. Then click Apps Script. A new tab opens. Apps Script is the place where Google lets you add scripts to a sheet.

  3. Clear the sample code

    You'll see a box with some sample code. Click inside it. Select everything (Ctrl+A on Windows, Cmd+A on Mac). Delete it.

  4. Paste this function

    Copy the code below. Paste it into the empty box. Then replace YOUR_API_KEY with your real key. Keep the quote marks around it.

    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;
    }
    
  5. Save it

    Click the save icon (it looks like a floppy disk) or press Ctrl+S or Cmd+S. Then go back to your sheet tab.

  6. Use it in a cell

    Click the cell next to your first email, for example B2. Type =EFV_VERIFY(A2) and press Enter. After a moment you see the answer.

  7. Try a few more rows

    Click B2. Drag the small square at its bottom right corner down a few rows, up to about five. Each cell sends one request (one question to our service).

You'll see TRUE if we confirmed the mailbox. You'll see FALSE if we couldn't. An answer like error 429 means you went too fast. New accounts can send 1 request per second. See Limits and common errors.

Don't fill the formula down a whole column. Every filled cell sends its request at the same moment. That breaks the limits (1 request a second, 5 at once) and you get 429 errors. Google also stops a custom function that runs longer than 30 seconds. Use this for a handful of rows. For more, use Verify or find a list (see below).

Anyone who can edit the script can see your key. Use a dedicated key for this sheet. Delete it when you're done. Don't share the sheet with people you don't trust.

Checking a long list?

For more than a handful of rows, use Verify or find a list in the dashboard (the website you use after you sign in). It handles the speed limit for you. See Verify a list of emails.

Good to know

  • Use a separate API key for this tool. Then you can delete it on its own.
  • Find and verify are two steps: find the email, then verify it. See Find, then verify.

Still stuck? Ask us on Slack. Real people answer.

Get support

Last updated 16.11.2026