Search API Connector Documentation

Print

Import Hunter Data to Google Sheets

In this guide, we’ll walk through how to gather email leads from the Hunter API directly into Google Sheets, using the API Connector add-on for Sheets. We’ll first get an API key from Hunter, and then set up a request to pull in email data to your spreadsheet.

Part 4 of this article includes a simple demo of how to make your own lead-gathering tool.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Hunter API Key

  1. If you haven’t already, sign up for a Hunter account. While logged in, navigate to https://hunter.io/api_keys.
  2. It really doesn’t get any easier than this. Your API key will be visible on this page, so just click to copy it. That’s it, you now have access to the Hunter API!
    hunter-img1

Part 2: Create Your Hunter API Request URL

We’ll first get a list of email addresses from a particular company domain.

  • API Root: https://api.hunter.io/v2
  • Endpoint: /domain-search
  • Query Strings: ?domain=DOMAIN&api_key=YOUR_API_KEY

Putting it together, we get the full API Request URL:

https://api.hunter.io/v2/domain-search?domain=stripe.com&api_key=ff6...

Just substitute in your own API key, and you can search whatever domain you’re interested in.

Part 3: Pull Hunter API Data into Sheets

Now let’s enter those values into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create screen, enter the Request URL we just created
    hunter-img2
  3. You don’t need OAuth2 authentication for this request, so just leave that set to None. We don’t need headers either, so just leave that section blank.
  4. Create a new tab and click Set current to use that tab as your data destination.
  5. Name your request and click Run. A a moment later you’ll see a list of email addresses associated with the domain in your Google Sheet:
    hunter-results1

Part 4: Get More Hunter API Data

Experiment with endpoints and query strings as described in their documentation to see other types of Hunter data. For example, you can find an email address of a user if you know their company name, first name, and last name as follows:

https://api.hunter.io/v2/email-finder?domain=DOMAIN&first_name=FIRST_NAME&last_name=LAST_NAME&api_key=API_KEY

Make sure to substitute values where indicated by capital letters. Combine this with the IMPORTAPI() Custom Sheets Function to create your own lead gathering tool.

hunter-email-finder
If you are working with lists of leads from different sources, these names may be written differently (e.g. “Jack Jones” vs. “Jack S. Jones”). Use the fuzzy-match Flookup add-on for Sheets to match and merge records together into a master list.

Part 5: Handle Pagination

By Default, Hunter will only return 10 records at a time. To get more, use the ‘offset’ and ‘limit’ parameters, as described in their documentation.
hunter-pagination

With API Connector, you can either run these manually or set up pagination handling (paid feature) to loop through them automatically like this:

  • API URL: enter your request URL
  • Pagination: offset-limit
  • Offset parameter: offset
  • Limit parameter: limit
  • Limit value: 100
  • Run until: choose when to stop fetching data

pagination-offset-limit

Part 6: API Documentation

Official API documentation: https://hunter.io/api/v2/docs#introduction

Previous Import HubSpot Data to Google Sheets
Next Import Instagram Data to Google Sheets

Leave a Comment

Table of Contents