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:
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
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:
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.
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.
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.
Method: POST
https://api.anymailfinder.com/v4.0/search/person.json
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:
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.
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.
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 |
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.
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.
That’s how you can use the Apipheny API integrator to make POST API request to the Anymail finder API to search for and validate email addresses.
If you want to learn more about the Anymail finder API, click here to read the full documentation.
Crypto API Tutorials: