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
Go to the Hunter for Google Sheets page and click the Get the Add-on button.
Click the Install button.
Click Allow to give permissions to Hunter.
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.
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.
Find email addresses from a domain
Select the Search tab and enter the domain in the text box.
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.
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:
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.
Perform a Bulk Domain Search
Select Bulk in the Search tab.
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.
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.
Select the Finder tab.
Match the contact fields to your corresponding columns.
Check the My table has headers box if needed.
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.
Select the Verifier add-on tab.
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.