Find & Verify Emails in Google Sheets - Anymail Finder Tutorial

How to connect the Anymail Email Finder API to Google Sheets

Here’s a quick tutorial showing you how to find and verify/validate email addresses in Google Sheets using the Anymail Finder API and the Apipheny API integrator.

The same method will also work with other email address finder and validator APIs.

You can use the Anymail finder API to look up email addresses, for example, if you plan on cold emailing people for sales or lead generation.

Here’s the steps we’ll be covering in this tutorial:

Install the Apipheny API integrator for Google Sheets
Sign up for Anymail Finder
Get your API key
Enter your API request in Apipheny and run the request

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new

Step 2.) Sign up for Anymail finder

Anymail finder is one of the most popular email address finders because Anymail finder is focused on returning only verified email addresses.

The Anymail finder REST API has 3 POST endpoints you can query:

Look up someone’s email address from their name and domain
Validate/verify email addresses
Find email addresses from any URL or company name

Click here to create an account and sign up for Anymail finder, if you haven’t already.

After you’ve signed up, you need to verify your email address by clicking the link in your email. Once you verify you email and log in, you’ll be asked to choose a payment plan, or you can choose the “Free Trial” button, which will give you 20 free credits so you can try it out before committing to a paid plan.

Step 3.) Get your API key

Okay, now that you’ve signed up for your Anymail finder account, you need to get your API key.

To get your API key, click the “My Account” button, then click “API” in the left menu, then click “Enable API”:

After you click Enable API, you’ll see your API key. Just copy and paste your API key somewhere safe because you’re going to need it in a moment.

Step 4.) Enter your API request into Apipheny and run the request

As I mentioned in Step 2, the Anymail Finder API has 3 POST endpoints that you can query.

Now I’m going to show you how to query all three endpoints by entering your API request into Apipheny then just run the request by clicking the “Run” button at the bottom of the Apipheny add-on.

Click here to read the Anymail finder API documentation.

1. Look up a persons email address

Method: POST

API URL:

https://api.anymailfinder.com/v4.0/search/person.json

Headers:

Key:
X-Api-Key

Value:
your_API_key

POST Body:

{
"full_name": "Tim Cook",
"company_name": "Apple"
}

Just replace “Tim Cook” and “Apple” with the person and company you want to actually search for.

Parameters you can use for this endpoint:

Field	Type	Description
`full_name`	String	The full name of the person you’re searching for
`first_name`	String	The first name of the person to you’re searching for
`last_name`	String	The last name of the person you’re searching for
`domain`	String	The domain of the company to search the email at
`company_name`	String	The name of the company to search the email at

Either full_name or both first_name and last_name are required. You must also use either the domain or company_name parameter in your POST body.

Here’s what the API request should look like in Apipheny:

Anymail finder API request entered in Apipheny

Then just click the “Run” button at the bottom of the Apipheny add-on and the results of your API request will populate in your Google Sheet.

2. Validate an email address

Method: POST

API URL:

https://api.anymailfinder.com/v4.0/validate.json

Headers:

Key:
X-Api-Key

Value:
your_API_key

POST Body:

{
"email": "tim@apple.com"
}

Just replace “tim@apple.com” with the email address you actually want to search.

3. Find email addresses by company name

Method: POST

API URL:

https://api.anymailfinder.com/v4.0/search/company.json

Headers:

Key: 
X-Api-Key

Value:
your_API_key

POST Body:

{
"domain": "acme.com"
}

For this request, domain or company name is required.

Field	Type	Description
`domain`	String	The domain (URL) to search for emails
`company_name`	String	The company name to search for emails at

4. Find email addresses by job title

Method: POST

API URL:

https://api.anymailfinder.com/v4.1/search/employees.json

Headers:

Key: 
X-Api-Key

Value: 
your_API_key

POST body:

{
"domain": "acme.com"
"job_title": "co-founder"
}

Just replace the domain and job title with the domain and job title you actually want to search for.

Create API request based on value(s) entered in spreadsheet

If you want to make an API request to the Anymail finder API based on the value of a cell in your spreadsheet, you can replace the name or email address in your POST body with {{{Sheet1!A1}}}.

For example, let’s say you have an email address or a name entered in Sheet 1 cell A1 of your Google Sheet. You can reference that cell in your POST body by wrapping the sheet and cell value with 3 curly braces, like this: {{{Sheet1!A1}}}.

Example POST body with variable entered:

{
"full_name": "{{{Sheet1!A1}}}",
"company_name": "Apple"
}

So when making this API request, the value of Sheet 1 cell A1 will be referenced for the “full_name” parameter. You could do the same with the company name, domain, or email parameters.