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 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.
Section 4 of this article includes a simple demo of how to make your own lead-gathering tool.
- Part 1: Get your Hunter API Key
- Part 2: Create your API Request URL
- Part 3: Pull Hunter API Data into Sheets
- Part 4: Get More Hunter API Data
- Part 5: Handle Pagination
PART 1: GET YOUR HUNTER API KEY
- If you haven’t already, sign up for a Hunter account. While logged in, navigate to https://hunter.io/api_keys.
- 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!
PART 2: CREATE YOUR HUNTER 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=YOUR_API_KEY
Putting it together, we get the full API Request URL:
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
We can now enter our values into API Connector and import email addresses from the Hunter API into Google Sheets.
- Open up Google Sheets and click Add-ons > API Connector > Open.
- In the Create screen, enter the Request URL we just created
- You don’t need any headers for this request, so just leave this section blank. You don’t need any OAuth2 authentication either, so just skip that section.
- Create a new tab and click ‘Set current’ to use that tab as your data destination.
- 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:
PART 4: GET MORE HUNTER API DATA
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 as follows:
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.
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 here. For example:
- Page 1
- Page 2
With API Connector, you can either set these up as separate requests or set up pagination handling (paid feature) to loop through them automatically.