No-Code Enrichment with
Use Hunter To Find Email Addresses Providing Just a Name and Domain Name
Sign Up Free

Use Hunter To Find Email Addresses Providing Just a Name and Domain Name

Hunter is a leader in the email verification space, and when you pair their Email Finder API with Gigasheet’s Custom Enrichment no-code functionality, you can use a spreadsheet to process your massive lead lists. Hunter’s Email Finder API requires only a person's name and domain name, and can return the professional email address along with a confidence score. Additionally, if the address is displayed somewhere online, the sources will be returned.

Use email finder API to look up professional email addresses

Provider Website:

Provider Enrichment Docs:


Token / Registration Required: Yes

How To Enrich A Spreadsheet With Hunter Email Finder API:

For this example, my spreadsheet is a short list of names and domains. However, Gigasheet supports up to a billion rows! email finder locates professional email addresses with just a name and domain

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from Hunter Email Finder API docs.

The email finder API request

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the domain, “”, in the input, and then select our Domain column and click +Insert Column Reference. Repeat the process, highlighting and replacing “Alexis” with the First Name column, and “Ohanian” with the Last Name column. Finally, weneed to highlight the “API_KEY” and paste our real key from Then click Test.

customizing the email finder API request
The email finder request ready for execution

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Hunter Email Finder API response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

Preview of the response from email finder API

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet.

Confirm execution of the email finder API

Step 5. Once completed, Gigasheet will enrich your sheet with new columns using the selected data from the Hunter Email Finder API response

Columns added with data from the email finder API

The new columns contain a professional email address for each row in our spreadsheet, where we provided a name and domain name. We can now run our email programs accordingly, thanks to Gigasheet and Hunter.

data returned by the email finder
Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever