Get Hunter Email Count Stats for a Domain List in an Excel workbook

The Scenario

You're a growth analyst. Your team is scoping three new verticals and you need to assess how reachable the companies in those verticals are via cold email before committing to API credits for full domain searches. You have a workbook with 100 target domains in column A. Hunter's email count endpoint tells you how many addresses they have per domain, with department and seniority breakdowns. You need that data before the strategy meeting tomorrow.

The mistake would be to run full domain searches on all 100 domains right now. Some of them might have three indexed emails. The smart move is counts first.

The bad version:

• Open Hunter's developer docs, find the email count endpoint, make a test API call for the first domain, parse the JSON response, manually enter the numbers into your workbook.
• Repeat for domain 2.
• Realize at domain 8 that your column structure is inconsistent because you were summarizing the JSON differently each time.

This is supposed to be a quick prioritization step, not a data engineering project.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the domains in column A and through its Hunter integration it can pull email count statistics for each domain and write them into the workbook in a structured format you can immediately sort and filter.

Check Hunter's email count for every domain in column A and write the total email count, personal email count, and generic email count to columns B, C, and D.

What You Get

• Column B: total indexed email count for each domain.
• Column C: count of personal addresses (first.last@, etc.) Hunter has indexed.
• Column D: count of generic addresses (info@, hello@, etc.) Hunter has indexed.
• A row per domain you can sort by total count to prioritize the full domain search run.

What If the Data Is Not Quite Ready

You want to score domains for outreach priority based on the counts

Raw counts are useful; a priority score is actionable.

For each domain in column A, get Hunter's email count stats. Write the total count to column B. Then add a column C that labels the domain "HIGH" if total count is 50 or more, "MEDIUM" if 10–49, and "LOW" if under 10.

You want to identify catch-all domains before using count stats to make decisions

Catch-all domains inflate Hunter's count. You want to know which domains are catch-all before treating their numbers as meaningful.

For each domain in column A, get Hunter's email count stats and write the total count to column B. Then run a quick domain search on each domain and check whether Hunter flags it as catch-all. Write "catch-all" or "not catch-all" to column C. Flag domains where count is high but server is catch-all in column D as "inflated — verify before search".

You want to join email count stats with company enrichment

You want to compare Hunter's email index depth against the company's actual headcount — a simple way to gauge how well Hunter covers each account.

For each domain in column A, get Hunter's email count stats and write the total to column B. Then run Hunter's company enrichment and write the employee count to column C. Add a column D that calculates coverage as a percentage (Hunter total ÷ employee count × 100), rounding to one decimal.

You want count stats + top 3 emails + full enrichment only for high-count domains

You want a tiered pass: count stats for all 100 domains, then deeper enrichment only for the ones that clear a threshold.

For each domain in column A, get Hunter's email count stats and write total count to column B. For domains where the total count is 20 or more, also run a Hunter domain search and write the top 3 email addresses found to columns C, D, and E. For domains below 20, leave columns C–E blank and write "low volume" to column F.

Spending quota on the accounts that clear the threshold — and skipping the rest — is the move when you have a large list and a finite API budget.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook where column A holds a list of company domains you're evaluating for outreach. Ask SheetXAI to pull Hunter's email count stats so you know where to invest before running full searches. See also bulk domain search or return to the Hunter overview.