The Scenario
Your logistics team runs a weekly route-planning document. This week's batch: 400 delivery GPS coordinates collected from driver devices over the past month, sitting in columns A and B of a Google Sheet — latitude in A, longitude in B, nothing else.
The route-planning tool they use expects full postal addresses and local timezones. Without them, the coordinators have to look up addresses one at a time using an online geocoder, copy the results by hand, and then manually figure out which timezone each delivery location falls in before scheduling handoff windows.
Someone handed this task off three weeks ago and it never got done because it's 400 rows of repetitive lookups.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet and calls BigDataCloud's reverse geocoding API on your behalf. You describe the task — it handles the coordinate-to-address conversion and the timezone lookup, then writes the results back into your sheet.
Open SheetXAI from the Extensions menu and type:
Reverse-geocode the lat/lon pairs in columns A and B using BigDataCloud and fill columns C and D with the formatted address and timezone identifier
What You Get
- Column C: formatted postal address (street, city, state/province, country)
- Column D: IANA timezone identifier (e.g., "America/Chicago", "Europe/Paris", "Asia/Tokyo")
- Rows where the coordinate pair returns no result get a blank cell; the SheetXAI sidebar notes the count of unresolved coordinates after the run completes
What If the Data Is Not Quite Ready
The coordinate columns have inconsistent decimal precision
Reverse-geocode the lat/lon pairs in columns A and B using BigDataCloud — round each coordinate to 6 decimal places before the API call, then write formatted address and timezone into columns C and D
Some rows have the coordinates reversed — longitude first, latitude second
Reverse-geocode the coordinates in columns A and B using BigDataCloud — column A contains longitude and column B contains latitude (reversed from standard), swap them before the API call, then write address and timezone into columns C and D
The data spans two sheets — one for domestic deliveries, one for international
Reverse-geocode all lat/lon pairs in column A and B on the "Domestic" sheet and the "International" sheet using BigDataCloud, write formatted address and timezone into columns C and D on each sheet, then copy all rows into a combined sheet called "All Deliveries"
Full route-prep pass in one prompt
Reverse-geocode all coordinate pairs in columns A and B using BigDataCloud and write address and timezone into columns C and D — then flag in column E any row where the timezone is outside UTC-5 to UTC+3 (international delivery requiring special coordination), and sort the flagged rows to the top of the sheet
One prompt handles the geocoding, the timezone enrichment, the flagging, and the sort.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of GPS coordinates — paste the prompt above and have your delivery addresses and timezones ready for the route-planning tool. See the IP-to-timezone spoke if you also need to resolve timezone data from IP addresses in a separate sheet.