The Scenario
You're a VP of Growth. The board deck goes out Sunday night for Monday morning. Slide 14 is supposed to show "where our trial users are coming from geographically." You have 10,000 trial sign-up IPs in a Google Sheet. Your growth analyst is on PTO. You need a shareable map link by tomorrow.
The map itself isn't the problem. IPinfo has a tool that takes a list of IPs and returns a visual map link you can drop into a slide. The problem is getting your 10,000 IPs from the sheet to that tool and the link back into the sheet.
The bad version:
- Copy 10,000 IPs from the sheet to a text file.
- Upload to IPinfo's map tool via their batch interface.
- Wait for the link to generate.
- Copy the URL back to the sheet manually.
That's not terrible. But the upload interface expects a specific format, you have to handle the column-to-plaintext step, and doing this without a script means a lot of clipboard work for a dataset this size.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the IP column, sends the list to IPinfo's map tool, and writes the generated link directly to a cell — no copy-pasting, no format conversion.
Open the SheetXAI sidebar and paste:
Take all IP addresses in column A and send them to IPinfo's map tool, then write the generated map URL to cell C1 so I can share it.
What You Get
- Cell C1: the shareable IPinfo map URL — a live interactive map showing all 10,000 trial user IPs plotted geographically
- The link is ready to paste into a slide, share in Slack, or embed in a doc
- No intermediate file export, no format conversion, no re-import
What If the Data Is Not Quite Ready
The IP list includes duplicates and I want unique IPs on the map
Deduplicate column A, then send the unique IP addresses to IPinfo's map tool and write the generated map URL to cell C1.
I have IPs across multiple sheets and want to combine them into one map
Collect all IP addresses from column A on Sheet1 and column A on Sheet2, combine them into a single deduplicated list, send to IPinfo's map tool, and write the resulting map URL to cell A1 on a new tab called "Map Links."
I want separate maps for different user segments
Column B contains the user segment label for each IP in column A (values: "Trial," "Paid," "Churned"). Create a separate IPinfo map for each segment using only the IPs where column B matches that segment. Write the three map URLs to cells A2, A3, and A4 on a tab called "Segment Maps," with the segment name in column A and the URL in column B.
Full board-deck prep in one shot
Column A has 10,000 trial sign-up IPs. Deduplicate, remove any IPs from our internal office ranges (listed in the "Exclusions" tab column A), send the cleaned list to IPinfo's map tool, write the map URL to cell B1, and also write the total unique IP count to cell B2 and the country count to cell B3 so I have all three numbers for the slide.
One prompt, everything the board slide needs.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of user or trial sign-up IPs, then ask it to generate a shareable IPinfo map link so you have something visual ready for your next presentation. See also geographic traffic distribution with pivot tables or batch geolocation enrichment. Hub: IPinfo + Google Sheets.