The Scenario
Your team operates last-mile delivery across three cities. The GPS tracking system logs every stop as a raw coordinate pair — latitude in column A, longitude in column B — and drops them into a shared Google Sheet overnight. This morning there are 300 new rows and your operations manager needs a readable address for each one before the routing briefing at 11 AM.
The bad version:
- Open Google Maps, paste a coordinate pair from row 2, copy the address that appears, switch back to the sheet, paste it into column C, repeat for row 3
- Lose your place somewhere around row 40 and paste the wrong address into column C for five rows before noticing
- Reach row 80 and realize the briefing is in 45 minutes and you have 220 rows left
This is not an analysis problem. It is a transcription problem, and it is eating the time you were supposed to spend on the actual routing decisions.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the coordinate pairs in your sheet and, through the built-in Yandex integration, calls the reverse geocoding API for each row and writes the results back. No switching tabs. No copy-pasting. One prompt.
For each row with latitude in column A and longitude in column B, use Yandex reverse geocoding to get the address and write the full address into column C, city into column D, and postal code into column E. Start at row 2 and process all non-empty rows.
What You Get
- Column C: full street address from Yandex (building number, street name)
- Column D: city name
- Column E: postal code where Yandex returns one
- Rows where Yandex returns no result get "No address found" in column C rather than a blank cell, so gaps are immediately visible
What If the Data Is Not Quite Ready
Coordinates are mixed into a single column as "lat, lon" strings
Some export formats combine both values into one cell. Before geocoding, you need to split them.
Column A contains coordinate strings formatted as "55.7558, 37.6173". Split each value into separate latitude and longitude columns — latitude in column B, longitude in column C — then use Yandex reverse geocoding on columns B and C to write addresses into column D.
Some rows have reversed coordinates (lon, lat instead of lat, lon)
GPS devices from different vendors sometimes swap the order. Yandex geocoding will return nonsense results for reversed pairs without surfacing an obvious error.
Check columns A and B for rows where the first value falls between 30 and 60 and the second falls between 55 and 75 — those are likely reversed (longitude first). For those rows, swap the values before geocoding, then run Yandex reverse geocoding across all rows and write results into column C.
Only geocode rows where column F is marked "Pending"
You do not want to re-geocode the 180 rows already confirmed last week. You only need addresses for new stops.
Use Yandex reverse geocoding only for rows where column F says "Pending". For each matching row, write the full address into column C, city into column D, and postal code into column E. Leave rows where column F is not "Pending" untouched.
Clean up formatting inconsistencies, geocode, and flag missing postal codes in one pass
Some coordinates came from a form and were entered with extra spaces or trailing decimals. You want clean data, addresses, and a clear flag for anything missing a postal code.
For all rows in columns A and B, trim whitespace and normalize decimal precision to 6 places. Then run Yandex reverse geocoding on each cleaned pair. Write the address into column C, city into column D, postal code into column E. In column F, write "Missing postal code" for any row where Yandex did not return a postal code, and "OK" for the rest.
The pattern here is to ask for the cleanup and the geocoding in a single prompt rather than doing each step separately and hoping nothing breaks between them.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your GPS coordinate log, then ask it to reverse-geocode all the pending rows and flag anything that comes back incomplete. See also: bulk route calculation and company enrichment from Yandex.