The Scenario
Your account-based marketing program is supposed to target specific enterprise companies. Your analytics platform is showing 800 unique IP addresses that hit the pricing page last month. You have no idea who most of them are — just IP addresses and timestamps.
The ABM tool your team pays for should help with this. But it requires you to upload a list and wait 48 hours for enrichment, and the last time you did that, 60% of the rows came back with no match.
The bad version:
- Look up each IP in ipdata.co's web interface to get the company name and domain.
- Copy the company name, switch tabs, paste it into column B. Copy the domain, paste into column C.
- At row 30, your browser crashes. You lost 29 rows of work and have no way to know which ones you completed.
The ABM team's weekly sync is in two days. You were supposed to come with a list of target accounts showing up on the pricing page.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the visitor IP column and calls ipdata.co to resolve each one to an organization name and domain, writing the results back into the columns you specify.
Look up the company name and domain for each IP address in column A using ipdata.co and write them to columns B and C.
What You Get
- Column B: organization name resolved by ipdata.co (e.g., "Salesforce," "Workday," "HubSpot")
- Column C: company domain string where available (e.g., "salesforce.com")
- Rows where the IP resolves to a residential ISP or hosting provider come back with the ISP name, making it easy to filter to business-network visitors only
- Unresolved IPs noted inline rather than silently dropped
What If the Data Is Not Quite Ready
You want to filter to business-type networks only before doing outreach
For each IP in column A, fetch the ipdata.co company name, domain, and network type and write to columns B, C, and D. Then filter to show only rows where network type is "business" by adding a TRUE/FALSE flag in column E.
The visitor log has duplicate IPs from multiple page views
Deduplicate column A by IP address, keeping the first occurrence of each. Then look up company name and domain from ipdata.co for each unique IP and write to columns B and C.
You need to cross-reference against your existing CRM account list
Look up company name and domain for each IP in column A using ipdata.co and write to columns B and C. Then check column C against the domain list in the CRM-Accounts tab column A. Write "EXISTING CUSTOMER" in column D if the domain matches, "NET-NEW" if it does not.
Kill-chain: deduplicate visitors, enrich, filter to business, cross-reference CRM, and flag net-new targets
Remove duplicate IPs from column A. For each unique IP, fetch ipdata.co company name, domain, and network type — writing to columns B, C, and D. Filter to business-type networks only using column E. Cross-reference column C against the domain list in CRM-Accounts tab and write EXISTING CUSTOMER or NET-NEW in column F. Sort the result by column F so net-new targets appear first.
One prompt handles the full account identification and prioritization pipeline.
Try It
Get the 7-day free trial of SheetXAI and open your pricing-page visitor sheet, then ask SheetXAI to resolve the IP column to company names and domains using ipdata.co. See also geo-segmenting session IPs by region or the ipdata.co hub overview.