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 a Google Sheet 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 catch is the team is distributed across three continents, and 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, and is right now a reasonable time to call them? That information does not currently exist in the sheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your account data, calls BigDataCloud's IP-to-timezone API for each row, and writes the timezone name and UTC offset back — so your team can sort by timezone and plan outreach windows without guessing.
Open SheetXAI from the Extensions menu and type:
For each IP in column A, look up the timezone and current local time using BigDataCloud and write the timezone name and UTC offset into columns B and C
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 (e.g., +8, -5, +1)
- Rows where BigDataCloud cannot resolve the IP return blank cells; SheetXAI notes the count of unresolved IPs after the run
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.
You want the "best call window" logic applied automatically
For each IP in column A, fetch timezone and UTC offset from BigDataCloud and write into columns B and C — then add a column D that flags "good time now" if the account's local time is currently between 9 AM and 6 PM, and "outside window" otherwise
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.
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 currently within a 9 AM to 6 PM window, sort the sheet so "good time now" rows appear first, and add a summary at the top noting how many accounts are currently reachable versus outside their window
One prompt handles the enrichment, the window logic, the sort, and the summary.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of customer IP addresses — paste the prompt above and have your timezone-aware outreach list ready before the sprint kicks off. See the geolocation spoke if you also need country and region data alongside the timezone output.