Import Hunter Data to Google Sheets

Import Hunter Data to Google Sheets

Hunter is a tool to discover the email addresses of company employees. In this guide, we’ll walk through how to pull data from the Hunter API directly into Google Sheets, using the API Connector add-on. We'll first get an API key from Hunter, and then set up a request to pull in email data to your spreadsheet.

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 API REQUEST URL

We’ll follow the Hunter documentation to access 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={API key}
  • Query Strings Example: ?domain=stripe.com&api_key=ff62104191331770f006e6b6e81b2ddf89a8b516

Putting it together, we get the full API Request URL:
https://api.hunter.io/v2/domain-search?domain=stripe.com&api_key=ff62104191331770f006e6b6e81b2ddf89a8b516
Of course you'll need to substitute in your own API key, and can search whatever domain you're interested in.

PART 3: ENTER YOUR VALUES INTO API CONNECTOR

We can now enter our values into API Connector and import email addresses from the Hunter API into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created
    hunter-img2

  3. You don't need any headers for this request, so just leave this section blank.
  4. Create a new tab. You can call it whatever you like, but here we'll call it 'Hunter_DomainSearch'. While still in that tab, click 'Set' to use that tab as your data destination.
  5. Name your request. Again we'll call it 'Hunter_DomainSearch'
  6. Click Run and a moment later you’ll see a list of email addresses associated with the domain in your Google Sheet:
    hunter-img3

PART 4: NOTES AND EXPANSIONS

  1. Experiment with endpoints and query strings as described in the 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 by entering 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 you see variables, as indicated by the curly brackets.
  2. By Default, Hunter will only return 10 records at a time. To get more, use the 'offset' and 'limit' parameters, as described here. For example:
    First 100 records: https://api.hunter.io/v2/domain-search?domain=stripe.com&api_key={api key}&limit=100
    Second 100 records: https://api.hunter.io/v2/domain-search?domain=stripe.com&api_key={api key}&offset=100&limit=100

IMPORTANT SECURITY NOTE

Anyone with Owner or Edit access to your Google Sheet can view all the information you've saved within API Connector, including API keys and other credentials. Treat these keys as passwords and limit access to your sheet accordingly.

Comments:0

Leave a Reply

Your email address will not be published.