The Scenario
You're a B2B marketer three weeks into a website redesign. The dev team added server-side logging six weeks ago, and you're sitting on 120 IP addresses from visitors who hit the pricing page in the last thirty days — but no names, no company context, nothing you can act on.
Your head of growth wants to know which companies are evaluating you and haven't filled out a form. You're staring at a Google Sheet with a column of IP addresses and a Monday morning check-in in twenty-two hours.
The bad version:
- Paste each IP into Bigpicture.io's IP lookup tool one at a time, note the company name and domain somewhere, repeat for 120 rows
- Discover halfway through that roughly a third of the IPs resolve to ISPs or hosting providers, not actual companies — but you only know that row by row
- Hand the growth team a messy spreadsheet with inconsistent formatting and a footnote that says "some of these are probably not real companies" — which tells them almost nothing
You weren't hired to manually classify IP addresses. The Monday check-in is going to cover actual strategy, not whether you finished the lookup spreadsheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Connect it to Bigpicture.io and you can resolve an entire column of IP addresses to company profiles without writing a line of code or opening a second browser tab.
For each IP in column A, use Bigpicture.io IP-to-company lookup and write the company name, domain, and confidence score to columns B, C, and D. In column E, flag the row as "ISP," "Hosting," or "Business" based on the network type.
What You Get
- Column B: Company name (e.g., "Acme Corp," "Stripe Inc.")
- Column C: Company domain
- Column D: Bigpicture.io confidence score as a decimal
- Column E: Network type classification — "Business," "ISP," or "Hosting"
- Rows that return no match from Bigpicture.io get "Not Found" in column B so you know which IPs to deprioritize
The growth team gets a filtered, actionable view without you having to manually flag every residential or cloud-provider IP.
What If the Data Is Not Quite Ready
The IP column has some IPv6 addresses mixed in with IPv4
Resolve each IP in column A using Bigpicture.io — handle both IPv4 and IPv6 formats. Write company name, domain, confidence score, and network type to columns B through E. Flag any IPs that returned no result in column F.
You only care about high-confidence results above a certain threshold
For each IP in column A, look up the company using Bigpicture.io and write company name, domain, and confidence score to columns B, C, and D. Then filter column D and mark rows in column E as "Low Confidence" where the score is below 0.7.
You want to cross-reference the resolved companies against an existing account list
Resolve each IP in column A to a company using Bigpicture.io — write name, domain, and employee count to columns B, C, and D. Then compare column C against the domains in the "Known Accounts" tab and mark matches in column E as "Existing Account."
Full kill chain: deduplicate IPs, resolve companies, filter ISPs, and score by employee count
Remove duplicate IPs from column A. For each unique IP, look up the company on Bigpicture.io and write company name, domain, employee count, and network type to columns B through E. Remove rows where column E is "ISP" or "Hosting." Sort the remaining rows by column D (employee count) descending and add a "Tier 1" label in column F for companies with over 500 employees.
One prompt. No intermediate exports, no separate filtering step, no second pass.
Try It
Open a Google Sheet with server log IPs or any list of IP addresses and get the 7-day free trial of SheetXAI. Ask it to resolve the IPs to company names and network types using Bigpicture.io, and it'll classify and enrich the whole column at once. For domain-based enrichment, see the bulk domain enrichment spoke, or return to the Bigpicture.io hub overview.