The Scenario
It's territory planning week. Your AE team has 60 target account domains in a sheet — accounts they've identified as expansion targets for Q3. The problem: the sheet has domains and nothing else. Before the planning session tomorrow morning, someone needs to fill in industry, company size, headquarters city, and LinkedIn URL for every row so the team can prioritize by segment.
That someone is you.
The bad version:
- Open Hunter's company enrichment page, type in the first domain, read the result, manually enter industry into column B, employee count into column C, city into column D, LinkedIn URL into column E.
- Tab to the next domain. Type. Read. Enter.
- 60 domains. About 2 minutes each if you're fast. That's two hours of data entry before you've done any actual planning.
The planning session is at 9 AM. It is currently 7 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domains in your column A and through its Hunter integration it can pull company enrichment data for every row — industry, employee count, location, LinkedIn URL — and write it back to the correct columns without you touching a single cell.
For each domain in column A, use Hunter to enrich the company and write the company name, industry, employee count, headquarters location, and description to columns B–F.
What You Get
- Column B: company name as Hunter has it.
- Column C: industry classification (e.g., "SaaS", "Healthcare", "Retail").
- Column D: employee count or employee range.
- Column E: headquarters city and country.
- Column F: a brief company description from Hunter's enrichment data.
What If the Data Is Not Quite Ready
Some domains returned partial enrichment and you want to flag gaps
Hunter has varying data depth by company. Some domains return a full profile; others return only a name and industry. Before the planning session you want to know which rows are incomplete.
Enrich each domain in column A with Hunter's company enrichment. Write company name to column B, industry to column C, employee count to column D, and headquarters to column E. Add a column F that says "complete" if all four fields were returned, or lists the missing fields if any are empty.
You want to segment accounts by employee size before reviewing
Your manager wants the 60 accounts sorted into three tiers — enterprise (500+), mid-market (50–499), and SMB (under 50) — before the planning call.
Enrich all domains in column A with Hunter's company enrichment. Write the employee count to column B and the company name to column C. Add a column D that labels each company "Enterprise" if employee count is 500 or more, "Mid-Market" if 50–499, and "SMB" if under 50. Sort the sheet by column D before finishing.
A subset of your domains are subdomains, not root domains
Some rows in your sheet have things like "mail.acme.com" or "careers.widget.io" instead of the root domain. Hunter's enrichment works on root domains.
For each domain in column A, check if it appears to be a subdomain (has more than one dot before the TLD). If so, strip it to the root domain, write the root domain to column G, and run Hunter's company enrichment on column G. For clean root domains, run enrichment directly on column A. Write all enrichment results to columns B–F.
You want enrichment + LinkedIn URL + email count stats all in one pass
You want to go into the territory planning session with the firmographic data, the LinkedIn company page, and a rough sense of how reachable each account is via Hunter's email index.
For each domain in column A, run Hunter's company enrichment and write company name to column B, industry to column C, employee count to column D, headquarters to column E, and LinkedIn URL to column F. Then get Hunter's email count for each domain and write the total indexed email count to column G. Flag any domain with zero emails in Hunter as "low reach" in column H.
Combining enrichment and email count in one prompt means you arrive at the planning session with a complete account picture, not just firmographic data.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet holding your target account domains. Ask SheetXAI to run Hunter's company enrichment across all of them and write the firmographic fields back to your sheet. See also bulk domain search or return to the Hunter overview.