data Enrichments /
Hunter
No-Code API with
Hunter
Use Hunter Email Verifier API to Verify Emails In A Spreadsheet
Sign Up Free

Use Hunter To Verify Emails In A Spreadsheet

Hunter is a leader in the email verification space, and when you pair their Email Verifier API with Gigasheet’s Custom Enrichment no-code functionality, you can verify massive address lists. Their Email Verifier API requires an email address as an input and returns the result of the verification, indicating whether an email address is deliverable or not. Additionally, it includes optional detailed validations as well as a confidence score.

hunter.io email verifier documentation

Provider Website: https://hunter.io

Provider Enrichment Docs: https://hunter.io/api-documentation/v2#email-verifier

Endpoint: https://api.hunter.io/v2/email-verifier

Token / Registration Required: Yes

How To Enrich A Spreadsheet With Hunter Email Verifier API:

For this example, my spreadsheet is a short list of email addresses. However, Gigasheet supports up to a billion rows!

Data to enrich with hunter.io email verifier

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

Paste the request from the hunter.io email verifier docs

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 email, “patrick@stripe.com”, in the input, and then select our Email column and click +Insert Column Reference. We also need to highlight the “API_KEY” and paste our real key from Hunter.io. Then click Next.

Highlight fields to merge into the hunter.io email verifier API from Gigasheet
The final cURL request for hunter.io email verifier

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 Verifier 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 response from the hunter.io email verifier

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 hunter.io email verifier API

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

New columns containing data from the hunter.io email verifier

The new columns contain data for each email address such as results, which indicate if an email is deliverable or risky. We can now run our email programs accordingly, thanks to Gigasheet and Hunter.io.

Result and score from the hunter.io email verifier
Try it Out

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

No Code
No Database
No Credit Card
Sign Up, Free Forever