The Scenario
Your sales manager dropped a list of 40 company domains into a Teams message this morning — competitors, partners, and tier-2 accounts from last quarter's lost pipeline. She wants a full account map for an Excel workbook: known email addresses, departments, seniority levels, so the team can plan re-engagement. "Before the pipeline review" was the phrase she used. The pipeline review is tomorrow.
Hunter has indexed contacts for most of these domains. The challenge is that a domain search returns not one contact but dozens — names, titles, departments, personal versus generic addresses — all of which need to land in a structured workbook, grouped by domain.
The bad version:
- Open Hunter's domain search UI, enter the first domain, scroll through the results, figure out if there's an export, download a CSV, open it, remap the columns to match your workbook headers, paste the rows under the right domain section.
- 40 domains. However many minutes each.
- Somewhere around domain 12 you realize your row counts are off and two domains' contacts are mixed together.
This was supposed to be a research task. It became a formatting task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the domains in your worksheet and through its Hunter integration it can run a domain search for each one, pull the discovered contacts, and write them into the workbook organized by domain.
Search Hunter for email addresses at each domain in column A and fill in the top email addresses found per domain along with their type (personal/generic), department, and seniority level.
What You Get
- New rows added for each discovered contact, with source domain, full name, job title, email address, type (personal or generic), department, and seniority in separate columns.
- Contacts grouped so all entries for a given domain appear together before the next domain's results begin.
- A structured output the AE team can filter and sort without any reformatting.
What If the Data Is Not Quite Ready
You only want contacts at director level and above
Your manager specifically wants decision-makers — no ICs, no coordinators.
For each domain in column A, run a Hunter domain search. Write only the contacts with seniority level "director", "vp", "c_level", or "owner" to the workbook. For each qualifying contact, write domain, name, title, email, department, and seniority to separate columns, grouped by domain.
Some domains returned no results and you want to flag them
After the run you notice some domain groups in the output are empty. You need a column on the domains worksheet flagging which ones Hunter had nothing for.
For each domain in column A, run a Hunter domain search. Write discovered contacts to the "Contacts" worksheet with domain, name, email, title, department. On the "Domains" worksheet, add a column B that says "found: N contacts" if Hunter returned results, or "no results" if it returned zero.
You want to route results to separate worksheets by department
Your AE team wants engineering contacts on one worksheet and sales on another, not everything mixed together.
Run a Hunter domain search for each domain in column A. Route the results to separate worksheets based on department: engineering contacts to "Engineering", sales contacts to "Sales", marketing contacts to "Marketing", and everything else to "Other". Include domain, name, email, title, and seniority in each worksheet.
You want domain search + email count stats + company enrichment in one pass
Before committing to a full domain search on all 40 domains, you want to know which ones are worth the API credits.
For each domain in column A, first get Hunter's email count stats and write the total count to column B. Then run a full domain search only for domains where the count is 10 or more, writing discovered contacts to the "Contacts" worksheet. For domains below 10, write "low volume — skipped" to column C.
Running the count check first and gating the full search on a threshold is the move when you're working with a long list and limited quota.
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 want to map. Ask SheetXAI to run a Hunter domain search across all of them and land the contacts in a structured output. See also bulk company enrichment or return to the Hunter overview.