Hunter for Google Sheets makes it possible to add email addresses from existing data or find them from a domain directly in your spreadsheet.

How to install the Hunter for Google Sheets Add-on

  1. Go to the Hunter for Google Sheets page and click the Get the Add-on button.

  2. Click the Install button.

  3. Click Allow to give permissions to Hunter.

  4. Create a new Google Sheets file online and open the Hunter Add-on. To do this simply select the Add-ons tab -> Hunter for Sheets -> Open.

  5. Now you’ll see a panel on the right side of the page where you’ll be able to perform a Domain Search or an Email Finder task directly in your spreadsheet.

When performing the first search, the Add-on will ask you to enter your personal API key to associate the add-on with your Hunter account. The API key can be found in the API section of your account.


Find email addresses from a domain

  1. Select the Search tab and enter the domain in the text box.

  2. Choose the number of email addresses you’d like to get for that domain from the drop-down menu and hit the Find email addresses button. Remember: you’ll need to enter your secret Hunter API key the first time you use the Add-on.

  3. Hunter will create a new sheet and provide you all the available email addresses directly in it.

Hunter will populate the table with the following information:

  • Email address

  • First name: if the email is personal, and the name of the contact is publicly available, the first name will be provided

  • Last name: if the email is personal, and the name of the contact is publicly available, the last name will be provided

  • Confidence score: an indicator for the deliverability of the email (in %).

  • Type: an email can be Personal or Generic.

  • Department: the department associated to the email.

  • Number of sources: the number of pages of the web where Hunter found that email address.

  1.  Select Bulk in the Search tab.

  2. Select a list of domains in your spreadsheet and click the red "Launch the bulk search" button when you are ready

When doing a bulk domain search, you can select up to 1000 domains at a time. If you select to find more than 10 emails per domain, we recommend selecting less to ensure the Google script does not time out.

Enrich your existing data with email addresses

Hunter for Google Sheets can enrich your existing data by finding email addresses using first name, last name, and company website or company name.

  1. Open a Google Sheet file with your contacts data. This data should at least contain a First Name, Last Name and Company or Domain Name. For better results, we suggest adding all 4 fields.

  2. Select the Finder tab.

  3. Match the contact fields to your corresponding columns.

  4. Check the My table has headers box if needed.

  5. Click on "Find email addresses".

Hunter will automatically complete the sheet with the email addresses found for each person. It will also add a column for the confidence score, and a column for the status.

The status can be OK if an email has been found, no results if no email was found, or it can indicate an error message, such as Parameter(s) missing, if the Email Finder could not be processed. When parameters are missing, this means that data is missing in one of the mandatory colums.

Verify a list of email addresses

You can also verify a list of email addresses to get the deliverability status of each email.

  1. Select the Verifier add-on tab.

  2. Select a list of emails in your spreadsheet, and click on "Verifiy email addresses"

A new tab will be created with the emails and the verification statuses. There will also be a column for the confidence score, and one for the number of sources where the email is found. You can also choose to include the full verification details.

You can select a list of up to 1000 emails at a time.

Did this answer your question?