The Scenario
A BDR on your team just got assigned three new verticals — fintech, HR tech, and logistics software — and her pipeline is empty. She has a target account template: company name, domain, employee count, headquarters city, and LinkedIn URL. The task is to fill that template with 20 companies per vertical from Hunter's B2B discovery database. Nobody is going to write 60 company profiles by hand.
The sheet is sitting there. Column A has the three industry names. The template headers are in row 1 on the "Prospects" tab. She needs this seeded before the Monday team standup.
The bad version:
- Log into Hunter, navigate to the Discover feature, set industry filter to "fintech", set employee count to 50+, set country to US, click through the results page, manually copy company name, domain, employee count, headquarters city, and LinkedIn URL for each company into the sheet.
- 20 companies for fintech. Then reset the filters for HR tech. Then again for logistics.
- Wonder why you're doing a job that feels like it should be automated while you copy-paste the twelfth fintech company name.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your industry list and through its Hunter integration it can query Hunter's company discovery database for each industry, pull the results with firmographic data, and write them directly into your sheet — no filter-clicking, no copy-pasting.
Use Hunter's company discovery to find companies in each industry listed in column A with more than 50 employees based in the US and populate this sheet with company name, domain, employee count, and headquarters city.
What You Get
- Rows added to the sheet for each discovered company, with the source industry, company name, domain, employee count, and headquarters city in separate columns.
- Results organized by industry — all fintech companies together, then HR tech, then logistics — so the BDR can work vertically without sorting.
- Up to the requested number of companies per industry, stopping at the limit you specify.
What If the Data Is Not Quite Ready
You want companies in specific countries, not just the US
Your BDR covers EMEA alongside North America. You want 15 companies per industry per region, not just US-based results.
Use Hunter's company discovery to find companies in each industry in column A. Pull 15 companies headquartered in the US and 15 headquartered in the UK or Germany for each industry. Write region, company name, domain, employee count, and headquarters city to the sheet. Group by industry and then by region.
You want to filter by employee range more granularly than a single threshold
Your team works mid-market accounts (100–999 employees) exclusively. Startups under 100 and enterprise over 1000 go to different teams.
Use Hunter's company discovery for each industry in column A. Filter to companies with 100 to 999 employees, headquartered in the US or Canada. Write company name, domain, employee count, and headquarters city for up to 20 results per industry. Add a column that flags any company with fewer than 100 or more than 999 employees as "out of ICP" for review.
You want to de-duplicate against an existing target list
The AE team already has a list of 200 known accounts on a tab called "Existing Accounts." You want to discover new companies but skip any that are already in that list.
Use Hunter's company discovery for each industry in column A to find up to 25 companies. After pulling the results, check each discovered domain against the "Existing Accounts" tab. If the domain already appears there, skip it. Write only net-new companies to the output, with a note column showing how many were skipped per industry due to overlap.
You want discovery + company enrichment + email count in one pass
You want the discovered companies seeded directly with enrichment data and a rough sense of Hunter's email coverage so the BDR can prioritize immediately.
Use Hunter's company discovery for each industry in column A to find 20 companies with more than 50 US employees. For each company, also run Hunter's company enrichment to fill in industry, LinkedIn URL, and a company description. Then get Hunter's email count for each domain and write the total to a "Hunter coverage" column. Sort results by Hunter coverage descending within each industry group.
Combining discovery, enrichment, and email count in a single prompt means the BDR opens the sheet and sees a prioritized, research-ready list — not a starting point that still needs three more steps before it's usable.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where column A lists industries, company types, or geographic markets you want to seed with target accounts. Ask SheetXAI to use Hunter's discovery database to populate it. See also bulk company enrichment or return to the Hunter overview.