The Scenario
Your manager dropped 200 company domains into column A of a Google Sheet on Friday afternoon and asked you to have each one scored against your ICP criteria by Monday morning. Employee count, annual revenue, industry, HQ city — all from ZoomInfo, all in the adjacent columns. You know what the finished sheet is supposed to look like. You just need the data to appear in it.
The bad version:
- Open ZoomInfo, search each company one at a time or in small batches, export what the UI lets you export
- Open the export CSV, find the right columns, copy, switch back to the sheet, match rows by hand, paste — and repeat 200 times or until something goes wrong
- Discover mid-paste that 23 rows didn't match because the domain format was slightly different in the export, and spend another 30 minutes reconciling them
The sheet goes to the sales team Monday. There is no Monday-morning window for a three-step reconciliation loop. The work has to happen between now and then.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the domains in column A, connects to ZoomInfo, enriches each company, and writes the results back into your sheet — all from a single prompt.
For each domain in column A, enrich the company using ZoomInfo and write employee count, estimated annual revenue, industry, and HQ city into columns B, C, D, and E
What You Get
- Column B: employee count as a number (e.g., 420)
- Column C: estimated annual revenue (e.g., 38000000)
- Column D: industry category from ZoomInfo's taxonomy (e.g., Software, Healthcare IT)
- Column E: headquarters city and state
- Rows where ZoomInfo returns no match are left blank with a note in a status column
What If the Data Is Not Quite Ready
The domains are formatted inconsistently — some have www, some don't, some include paths
Normalize all values in column A so they are root domains only (no www, no paths, no protocols), then enrich each domain with ZoomInfo company data and write employee count, revenue, industry, and HQ city into columns B through E
I also want to score each row against our ICP and flag matches
Enrich all 200 domains in column A with ZoomInfo company data — employee count into B, revenue into C, industry into D, HQ city into E — then add column F with the label ICP Match if employee count is between 200 and 1000 and industry is SaaS or software, Partial if only one condition is met, and No Match otherwise
Some rows already have partial data I want to preserve
For rows where column B is blank, enrich the company domain in column A with ZoomInfo and write employee count into B, revenue into C, industry into D, and HQ city into E — skip any row that already has a value in column B
Clean the list, enrich it, and sort it for the sales handoff in one shot
Remove any duplicate domains from column A, enrich each unique domain with ZoomInfo company data — employee count, revenue, industry, HQ city into columns B through E — add column F with ICP scoring as described above, and sort the sheet by column F so ICP Match rows appear first
One prompt handles the normalization, the enrichment, the scoring, and the sort. That is the pattern.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of company domains in column A — ask it to enrich each row with ZoomInfo firmographic data and score them against your ICP. You can also link to the hub overview for all ZoomInfo + Google Sheets workflows.