The Scenario
The customer success team at a SaaS company has 300 enterprise accounts — each with an IP address on file from the last known login, sitting in an Excel workbook alongside account names, ARR, and renewal dates.
The head of CS asked the team to plan a proactive outreach sprint: reach out to every account in the next two weeks. The team is distributed across three continents. The accounts are global. Calling an enterprise customer in Singapore at 8 AM San Francisco time is the kind of mistake that ends up in a QBR slide about "communication missteps."
What the team needs is simple: for each account IP, what timezone are they in? That column does not currently exist in the workbook.
The bad version:
- Export the IP column as a CSV, write a script to call BigDataCloud's timezone endpoint, get back a JSON file.
- Parse the timezone field, match rows back to the original workbook by row index, paste the values in.
- Realize the script didn't handle IPv6 addresses and 12 accounts now show blank — go back and add IPv6 handling, re-run for those rows.
The outreach sprint starts Monday. It's Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your account data, calls BigDataCloud's IP-to-timezone API for each row, and writes the timezone name and UTC offset back into adjacent columns — so your team can plan outreach windows without guessing.
Open SheetXAI from the Excel add-in panel and type:
Add a Best Call Window column to my sheet based on each IP's local timezone from BigDataCloud — flag customers where local time is currently outside 9am to 6pm
What You Get
- Column B: IANA timezone name (e.g., "Asia/Singapore", "Europe/London", "America/Sao_Paulo")
- Column C: UTC offset as a signed integer
- Column D: "good time now" if the account's current local time is between 9 AM and 6 PM; "outside window" otherwise
- Rows where BigDataCloud cannot resolve the IP return blank cells; SheetXAI notes the count of unresolved IPs in the add-in panel
What If the Data Is Not Quite Ready
Some accounts have multiple IPs on file — comma-separated in one cell
For each row in column A, if the cell contains multiple IPs separated by commas, use the first one. Look up timezone and UTC offset via BigDataCloud and write into columns B and C.
The IP column has some entries that are CIDRs, not individual IPs
For each entry in column A, if it's a CIDR range (e.g., 192.168.1.0/24), use the first IP in the range. If it's an individual IP, use it as-is. Fetch timezone and UTC offset from BigDataCloud and write into columns B and C.
You want to prioritize accounts by whether they're currently reachable
For each IP in column A, fetch timezone and UTC offset from BigDataCloud into columns B and C — add column D flagging "good time now" or "outside window," then sort the entire table so "good time now" rows appear first
Full outreach scheduling pass in one prompt
For each IP in column A, fetch timezone name and UTC offset from BigDataCloud into columns B and C — add a column D flagging whether local time is within a 9 AM to 6 PM window, sort the worksheet so "good time now" rows appear first, and add a summary at the top of the worksheet noting how many accounts are currently reachable versus outside their window
One prompt handles the enrichment, the window logic, the sort, and the summary row.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of customer IP addresses — paste the prompt above and have your timezone-aware outreach schedule ready before Monday's sprint kickoff. See the geolocation spoke if you also need country and region data alongside the timezone output.