The Scenario
You're a sales analyst at a SaaS startup. The growth team handed you a Google Sheet with 200 prospect domains in column A — scraped from a conference attendee list — and asked you to have it enriched and ready for the SDR team by end of day.
The sheet has domains. That's it. No industry, no headcount, no revenue band, no geography. None of the context the SDRs need to prioritize who to call first.
The bad version:
- Open Bigpicture.io, search domain one by one, copy industry and employee count into the sheet manually
- Spend three hours on a task that should take ten minutes, only to find that fifteen domains return partial data with no revenue figure
- Deliver the list two hours late with a note that "some rows are incomplete" — which the SDR team then has to reconcile before they can use it
This is not analysis work. It is data entry with extra steps, and the SDR team is already asking when it'll be ready.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data you're looking at and talks to Bigpicture.io on your behalf. No API setup, no column mapping configuration, no separate tool.
For every domain in column A, look up the company on Bigpicture.io and fill columns B, C, D, E with industry, employee count, estimated revenue, and country. If a field is unavailable, write "N/A" in that cell and add a note in column F.
What You Get
- Column B: Industry (e.g., "Software," "Healthcare," "Financial Services")
- Column C: Employee count as a number
- Column D: Estimated annual revenue (in USD, formatted consistently)
- Column E: Country code or full country name
- Column F: Any enrichment gaps flagged with a brief note — "No revenue data," "Domain not found," etc.
The SDRs get a sheet they can sort and filter immediately. The analyst gets their afternoon back.
What If the Data Is Not Quite Ready
Some domains have "www." prefixes or trailing slashes
Enrich each domain in column A with Bigpicture.io — strip any "www." prefix or trailing slash before looking up. Write industry, employee count, revenue, and country to columns B through E.
Some rows already have partial enrichment from a previous run
For rows in column A where column B is blank, look up the company on Bigpicture.io and fill columns B through E. Skip rows that already have a value in column B.
The list has a mix of domains and company names — not all are proper domains
Column A has a mix of domains and company names. For each row, determine whether it's a domain or a name, look up the company on Bigpicture.io using the appropriate method, and write industry, employee count, revenue, and country to columns B through E.
Full kill chain: deduplicate the list, enrich what remains, and flag accounts already in our CRM tab
Remove duplicate domains from column A, then enrich each unique domain with Bigpicture.io — write industry, employee count, revenue, and country to columns B through E. Cross-reference against the "CRM Accounts" tab and add an "Existing" flag in column G for any domain that already appears there.
Each prompt does the cleanup and the enrichment in a single pass — no pre-processing step, no second prompt to apply the logic.
Try It
Open a Google Sheet with a column of prospect or target company domains and get the 7-day free trial of SheetXAI. Ask it to enrich the list with Bigpicture.io firmographic data — industry, headcount, revenue, geography — and it'll fill the columns in one shot. For the IP-to-company version, see the visitor IP resolution spoke, or go back to the Bigpicture.io hub overview.