The Scenario
The compliance team sent a ticket Friday afternoon: "2,000 account sign-up IPs from the March campaign need a VPN/proxy screen before Monday's activation batch runs." The ticket was assigned to you because you handle the fraud tooling. It's Sunday morning.
You have the IPs in an Excel workbook. The activation batch runs at 6 AM Monday. You need VPN, proxy, Tor, and hosting flags per row, and a summary count by category so the compliance lead can sign off.
The bad version:
- Write a script to call the IPinfo privacy endpoint for 2,000 IPs, handle auth, loop, extract four boolean fields per row.
- Run the script, hit a rate limit at row 847, add sleep logic, rerun from the beginning.
- Paste the output CSV back into Excel, align the four boolean columns with the existing rows by order ID.
You're debugging retry logic at 10 PM Sunday so a compliance checkbox can get ticked at 6 AM Monday. That's the wrong use of a Sunday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls the IPinfo privacy detection API across your full sign-up IP list and writes the four boolean flags — plus a summary — directly into the workbook.
Open the SheetXAI sidebar and paste:
Check all sign-up IPs in column A against IPinfo's privacy detection API and write VPN, proxy, Tor, and hosting flags to columns B through E, then highlight any row where at least one flag is true.
What You Get
- Column B: TRUE/FALSE for VPN
- Column C: TRUE/FALSE for proxy
- Column D: TRUE/FALSE for Tor exit node
- Column E: TRUE/FALSE for datacenter/hosting IP
- Any row with at least one TRUE value highlighted in a warning color
- Rows where IPinfo returns no privacy data written as FALSE, not blank — clean vs. unknown is distinguishable
What If the Data Is Not Quite Ready
I need a summary count by privacy category for the compliance sign-off
Run IPinfo privacy detection on all 2,000 IPs in column A, write VPN, proxy, Tor, and hosting flags to columns B through E, then add a summary table below the data counting how many accounts fall into each privacy category and how many had more than one flag simultaneously.
Duplicate registrations from the same IP need deduplication before the screen
Column A has 2,000 sign-up IPs with some duplicates from users who registered multiple accounts. Deduplicate column A by IP address before calling IPinfo privacy detection, run the check on unique IPs, write the four flags back to every matching row using VLOOKUP, then highlight rows where any flag is true.
The compliance team wants a clean/anonymized/datacenter/Tor classification per row
Check all IPs in column A against IPinfo's privacy detection API. For rows where all four flags are false, write "Residential" in column F. For rows where VPN or proxy is true, write "Anonymized." For rows where hosting is true, write "Datacenter." For rows where Tor is true, write "Tor." Write the summary count of each category to a new worksheet called "Fraud Screen Results."
Full compliance pipeline: deduplicate, screen, classify, and report
Column A has 2,000 sign-up IPs, some duplicated. Run IPinfo privacy detection on unique IPs, write VPN, proxy, Tor, and hosting flags to columns B through E, classify each row as Residential/Anonymized/Datacenter/Tor in column F, highlight flagged rows, and write a summary table to a new worksheet called "Campaign Fraud Summary" with counts per category and percentage of total.
Privacy screen, classification, and sign-off summary in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of sign-up or transaction IPs, then ask it to run the IPinfo privacy screen and produce the compliance summary before your activation batch runs. See also company identification from visitor IPs or batch geolocation enrichment. Hub: IPinfo + Excel.