The Scenario
Your RevOps lead forwarded you a Mixpanel export Monday morning: 600 IP addresses from visitors who hit the pricing page in the last 30 days. The instruction attached: "See if any of these are enterprise accounts we should be talking to." You need company name, domain, and organization type for each IP — then filter to the business-type entries so you have a clean list for the AE team.
This is the kind of task that looks simple until you're three steps into it.
The bad version:
- Export the 600 IPs from Mixpanel into a spreadsheet.
- Call the IPinfo company endpoint manually for each — the web UI doesn't support batch company lookups, so you're writing a script or clicking one at a time.
- Parse the response, extract company name, domain, and type, paste back into the sheet.
- Filter to type === "business" and realize IPinfo returns "isp", "hosting", "business", "education" — decide which ones qualify, update the filter.
By the time you have the filtered list, you've spent an hour on data prep that should have taken five minutes. The AE team is already asking if it's ready.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. Through its IPinfo integration, it can look up company data for every IP in your list and filter the results inline — no script, no manual clicking.
Open the SheetXAI sidebar with your pricing-page IP sheet open and paste:
For each IP in column A, use IPinfo to retrieve company name, domain, and type and write them to columns B, C, and D — then filter to show only rows where type is "business."
What You Get
- Column B: company name (e.g., "Salesforce, Inc." or "Comcast Business")
- Column C: company domain (e.g., "salesforce.com")
- Column D: organization type — "business", "isp", "hosting", or "education"
- Rows where type is not "business" are hidden or removed, depending on your prompt phrasing
- Rows with no company data return blank cells in B-D — not error values
What If the Data Is Not Quite Ready
There are duplicate IPs from the same company visiting multiple times
Look up company information for all IPs in column A using IPinfo and write company name, domain, and type to columns B, C, and D. Deduplicate by company domain and write a deduplicated list of unique enterprise visitors (type = "business") to a new tab called "Account Targets," sorted alphabetically by company name.
I want to cross-reference against our existing CRM accounts
Look up company name and domain for all IPs in column A using IPinfo, write to columns B and C. Then use VLOOKUP to check each domain against the CRM accounts list in Sheet2 column A (domain) and column B (account status), and write the account status to column D. Mark rows where domain is not found as "New Prospect."
Some IPs resolve to ISPs and I need to separate those from business visitors
For each IP in column A, fetch company name, domain, and type from IPinfo. Write to columns B, C, D. In column E, write "Target" if type is "business" or "education," "ISP" if type is "isp," and "Hosting" if type is "hosting." Then write a summary count of each category below the data.
Full pipeline from raw IPs to prioritized outreach list
Column A has 600 pricing-page visitor IPs. Look up company name, domain, and type via IPinfo. Write to columns B, C, D. Filter to type "business" only, deduplicate by domain, check each domain against the CRM in Sheet2, mark new vs. existing, and write the prioritized new-prospect list to a tab called "Outreach Queue" sorted by company name.
One prompt, from raw IPs to a prioritized AE handoff list.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of visitor or prospect IPs, then ask it to identify the companies behind them using IPinfo and filter to your target account types. See also privacy flag screening for sign-ups or batch geolocation enrichment. Hub: IPinfo + Google Sheets.