The Scenario
You're a growth analyst. Your team has been talking about expanding into three new verticals, and someone — you, it turns out — needs to assess how reachable the companies in those verticals are via cold email before the team commits to buying API credits for a full domain search campaign. You have a sheet of 100 target domains sitting in column A. Hunter's email count API tells you how many addresses they've indexed 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. That's expensive if most of them return three emails. The smart move is to check the counts first.
The bad version:
- Open Hunter, navigate to the email count endpoint documentation, make a test call for the first domain, record the numbers manually, move to the next domain.
- There's no email count UI — this is an API call. So you're copying JSON responses and translating them into sheet values by hand.
- At domain 8 you've already lost an hour and you're not sure your numbers are structured consistently.
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 Google Sheet. It reads the domains in column A and through its Hunter integration it can pull email count statistics for each domain — total, by department, by seniority — and write them into the sheet in a format you can actually use.
For each domain in column A, get Hunter's email count stats and fill in total emails found, breakdown by department (engineering, sales, marketing, etc.), and breakdown by seniority.
What You Get
- Total indexed email count per domain in column B.
- Department breakdown written to subsequent columns (engineering, sales, marketing, finance, other) — one column per department category.
- Seniority breakdown written after that (executive, senior, junior) — one column per tier.
- A structured row per domain you can sort, filter, and pivot without reformatting.
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. You want each domain flagged as HIGH, MEDIUM, or LOW priority before handing the sheet to the sales team.
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 filter out domains that likely have catch-all servers
Catch-all domains inflate email count stats — Hunter counts them but they're often unverifiable. You want to identify which domains in your list have catch-all servers before using the counts to make decisions.
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 it is flagged 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 employee count — 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 place.
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.
This staged approach lets you spend your API quota on the accounts that are actually worth pursuing, not the ones that will return two addresses and a catch-all.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where column A holds a list of company domains you're scoping for outreach. Ask SheetXAI to pull Hunter's email count stats across all of them so you know where to invest before running full searches. See also bulk domain search or return to the Hunter overview.