The Scenario
Your revenue team is building a regional pricing model. They need to know the likely local currency for each customer based on where they signed up from. You have 6,000 customer rows in Google Sheets, each with an IP address in column B. Someone needs to add a currency column before the pricing spreadsheet goes to the CFO on Thursday.
That someone is apparently you.
The bad version:
- Try to write a VLOOKUP against a country-to-currency table. Realize you do not have a country column — just IPs.
- Consider running the IPs through a geolocation tool first, then joining the currency table. Two steps, two potential failure points.
- Look at the calendar. Thursday is tomorrow.
The CFO review is locked in. The pricing model without currency segmentation is incomplete, and the team lead made it very clear that "we ran out of time" is not a status update she wants to deliver to finance.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the IP column, calls ipdata.co for currency and country data, and writes the results into the columns you need — in one shot, no intermediate geolocation step required.
For each IP in column B, use ipdata.co to look up the currency code and currency name and write them to columns C and D.
What You Get
- Column C: ISO 4217 currency code (e.g., "EUR," "GBP," "BRL")
- Column D: full currency name (e.g., "Euro," "British Pound Sterling," "Brazilian Real")
- Rows where the IP returns no location data noted inline so no customer is silently dropped from the analysis
- IPs from the same country naturally cluster on the same currency, making the segmentation filter-ready immediately
What If the Data Is Not Quite Ready
You also need calling code for a separate telephony routing project
Fetch the currency symbol and calling code for every IP in column B using ipdata.co and write them to columns C and D.
Some customers have multiple rows with the same IP and you want to avoid redundant lookups
Deduplicate column B by IP address before calling ipdata.co. Look up currency code and currency name for each unique IP and write to a lookup table on a new tab called IP-Currency-Map. Then use that table to populate columns C and D on the main sheet via a match on column B.
The currency data needs to map to a regional pricing tier defined in another tab
For each IP in column B, fetch the currency code from ipdata.co and write to column C. Then look up the currency code against the Pricing-Tiers tab (column A = currency code, column B = tier name) and write the matching tier to column D.
Kill-chain: clean duplicates, enrich currency, map to pricing tier, and build a revenue summary
Remove duplicate rows by email address (column A). For each remaining row, look up the currency code and currency name from ipdata.co using the IP in column B — writing to columns C and D. Match the currency code against the Pricing-Tiers tab and write the tier name to column E. Add a summary on a new tab: revenue row count and percentage per pricing tier, sorted by row count descending.
One prompt handles the deduplication, enrichment, tier mapping, and summary in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open your customer sheet, then ask SheetXAI to append currency codes from the IP column using ipdata.co. See also classifying IPs by continent and EU membership or the ipdata.co integration overview.