Skip to main content

Find Email Addresses

Find the most likely email address from a person's first name, last name, and company domain using Hunter's powerful email finder.

Email Finder Formula​

Formula Structure​

=FIND_EMAIL(first_name, last_name, domain, [ignore_cache])

Parameters​

  • first_name (required): Person's first name
  • last_name (required): Person's last name
  • domain (required): Company domain (e.g., "reddit.com")
  • ignore_cache (optional): TRUE to force fresh results; FALSE uses cached results for 30 days

Examples​

Basic lookup:

=FIND_EMAIL("Alexis", "Ohanian", "reddit.com")

Force fresh result (ignore cache):

=FIND_EMAIL("Alexis", "Ohanian", "reddit.com", TRUE)

Reference from cells: If you have:

  • A2: First Name
  • B2: Last Name
  • C2: Company Domain

Use:

=FIND_EMAIL(A2, B2, C2)

How It Works​

The formula uses Hunter's email pattern database to:

  1. Analyze the company's email format (e.g., [email protected], [email protected])
  2. Apply the pattern to the person's name
  3. Return the most likely email address with a confidence score

Tips for Best Results​

  • Use the exact company domain (not the full URL)
  • Make sure names are spelled correctly
  • For better accuracy, use the domain where the person currently works
  • The formula returns the most likely email - always verify before using

Credit Cost​

  • Email finder uses Hunter API which costs 20 credits per lookup