Hunter
+
Google Sheets
+
Microsoft Excel

Hunter in your spreadsheet

Import live, refreshable data from Hunter in Microsoft Excel and Google Sheets.

Import Hunter data in your spreadsheet

Hunter helps you find and verify professional email addresses. This Hunter spreadsheet integration for Google Sheets and Microsoft Excel enables you to import contact information from Hunter. This add-on will enable you to integrate on-demand, refreshable identify data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Extract a set of data about the organization, the email addresses found and additional information about the people owning those email addresses.
  • Extract the professional email of a person and a confidence score.
  • Import an email delivery verification and confidence score.

Click here to learn more about the specific syntax for each of the Hunter spreadsheet functions.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Hunter function collection with Microsoft Excel or Google Sheets. Please note that you'll need a Hunter account with an API key to use this integration.

Need Help?

Have questions? Need help with installation? Need other Hunter functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Hunter Organization Enrichment

Returns a set of data about the organization, the email addresses found and additional information about the people owning those email addresses.

Syntax

=FLEX("YOUR_TEAM_NAME/hunter-enrich-org", domain, [properties])

Parameters

Property Type Description Required
domain string The domain name from which you want to find the domain addresses. For example, "stripe.com". true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/hunter-enrich-org", "intercom.io")
=FLEX("YOUR_TEAM_NAME/hunter-enrich-org", "intercom.io", "organization, first_name, last_name, email")
=FLEX("YOUR_TEAM_NAME/hunter-enrich-org", "intercom.io", "first_name, last_name, email, linkedin, twitter")

Notes

The following properties are allowed:

  • organization: name of the organization associated with the specifed domain
  • domain: domain name of the organization
  • first_name: first name of the person
  • last_name: last name of the person
  • email: email address of the person
  • email_disposable: true if this is an domain address from a disposable domain service
  • email_webmail: true if we find this is an domain from a webmail, for example Gmail
  • email_score: estimation of the probability the email address returned is correct
  • phone: phone number of the person
  • position: position of the person in the organization
  • seniority: seniority level of the person in the organization
  • department: department of the person in the organization
  • linkedin: username of the person on LinkedIn
  • twitter: username of the person on Twitter

Hunter People Enrichment

Return the professional email of this person and a confidence score.

Syntax

=FLEX("YOUR_TEAM_NAME/hunter-enrich-people", domain, first_name, last_name, [properties])

Parameters

Property Type Description Required
domain string The domain name from which you want to find the email address. For example, "asana.com". true
first_name string The person's first name. It doesn't need to be in lowercase. true
last_name string The person's last name. It doesn't need to be in lowercase. true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/hunter-enrich-people", "asana.com", "Dustin", "Moskovitz")
=FLEX("YOUR_TEAM_NAME/hunter-enrich-people", "asana.com", "Dustin", "Moskovitz", "email, organization")

Notes

The following properties are allowed:

  • organization: name of the organization associated with the specifed domain
  • domain: domain name of the organization
  • first_name: first name of the person
  • last_name: last name of the person
  • email: email address of the person
  • email_score: estimation of the probability the email address returned is correct
  • phone: phone number of the person
  • position: position of the person in the organization

Hunter Email Verification

Return email delivery verification and confidence score.

Syntax

=FLEX("YOUR_TEAM_NAME/hunter-verify-email", email, [properties])

Parameters

Property Type Description Required
email string The email address you want to verify true
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

=FLEX("YOUR_TEAM_NAME/hunter-verify-email", "steli@close.io")
=FLEX("YOUR_TEAM_NAME/hunter-verify-email", "steli@close.io", "score, status, webmail")
=FLEX("YOUR_TEAM_NAME/hunter-verify-email", "steli@close.io", "score, status, autogen, disposable")

Notes

The following properties are available:

  • score: the deliverability score of the email address
  • status: "deliverable", "undeliverable", "risky"
  • regexp: true if the email address passes a regular expression test
  • autogen: true if this is an automatically generated email address
  • disposable: true if this is an email address from a disposable email service
  • webmail: true if we find this is an email from a webmail, for example Gmail
  • mx_records: true if MX records exist on the domain of the given email address
  • smtp_server: true if connecting to the SMTP server was successful
  • smtp_check: true if the email address doesn't bounce
  • smtp_check_blocked: true if the SMTP server prevented the STMP check
  • smtp_accept_all: true if the SMTP server accepts all the email addresses; this can result in false positives on SMTP checks

Use Hunter in your spreadsheet now!