Hi guys, I think this would be helpful to many of us who wants a Geocoding solution in the sheets to display accurate pins on the map. I also tried Geocoding with Awesome Table but it seems like it does not trigger automatically when new rows are added. It has an option to link with Form submit, but it’s not the case here with Glide as far as I aware. So I have a script to do that for me, that will trigger automatically on new inputs as you can see in the GIF below. Note that the columns in the script does not match with the GIF as after this test I changed it. [image] The script is: function AddressToPosition() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName("User profiles"); var cells = sheet.getRange("M2:O"); var addressColumn = 1; var addressRow; var latColumn = addressColumn + 1; var lngColumn = addressColumn + 2; var geocoder = Maps.newGeocoder().setRegion('US'); var location; for (addressRow = 1; addressRow <= cells.getNumRows(); ++addressRow) { var address = cells.getCell(addressRow, addressColumn).getValue(); // Geocode the address and plug the lat, lng pair into the 2nd and 3rd elements of the current range row. location = geocoder.geocode(address); // Only change cells if geocoder seems to have gotten a // valid response. if (location.status == 'OK') { lat = location["results"][0]["geometry"]["location"]["lat"]; lng = location["results"][0]["geometry"]["location"]["lng"]; cells.getCell(addressRow, latColumn).setValue(lat); cells.getCell(addressRow, lngColumn).setValue(lng); } } }; What you need to change: var sheet = ss.getSheetByName(“User profiles”) => Change “User profiles” to the sheet that contains the address. Remember to add a latitude column, a longitude column and a combined lat/lon column (using ARRAYFORMULA) as you can see in the GIF. var cells = sheet.getRange(“M2:O”); => Change M2:O to the range where you have the address, latitude & longitude columns. Hope this helps.

[Nick Pirolli] How to add API key to Google Geocoding script google-maps, google-apps-script, google-sheets, google-cloud-platform asked by Nick Pirolli on 08:00PM - 06 Dec 19 UTC You either re-do the code to use a service URL, or maybe you can try using the Fetch column inside Glide to do this. Make sure you do not expose your API key anywhere in your app.

How do you skip empty addresses XD *when you remove something in glide, the row is cleared but not emptied, hence my question (not a coder, haha, many thanks in advance)

[Daniel Gilbert-Valencia] Get a Google Sheet script to skip empty rows? javascript, google-apps-script, google-sheets asked by Daniel Gilbert-Valencia on 08:09PM - 09 Mar 15 UTC It depends on how you define the logic of an empty row, but basically it should be an if to check that logic and stop the process if the logic is true (the row is indeed empty).

:frowning: Mine doesn’t work Error An unknown error has occurred, please try again later.

[image] Fetch Column Ask for Help As promised: [Glide: Fetch Column] Please use this instead.

Hi ThinhDinh. This code works. But if I want to get 2 locations at the same time. For example, get FROM location and get TO location on the same record. Please advise or give me script. Thanks in advance.

This is a very old thread. If you want to geocode an address, I would suggest using Radar’s integration. [image] Radar Integration | Glide Geocoding and address completion

I use Radar at this moment. But it can’t translate Thai language. Hence, I need some thing to get geolocation and now I got it. The problem now is, I have so many taxi driver locations and so many customer locations. How to get to shortest location to match some locations for some drivers. I don’t want to display all locations to all drivers simultaneously.

What’s your matching flow at the moment? I’m not sure I would build an app that requires live location like that in Glide.

Automatic geocoding using Google Scripts

Ask for Help

ThinhDinh April 2, 2022, 11:56pm 23

Please use this instead.

Topic		Replies	Views
Automatic geocoding in Sheets Ask for Help	7	956	June 13, 2020
Latitude and longitude values for given address using the Google Maps Geocoder Ask for Help	2	1202	September 3, 2021
Geocoding addresses in Google Sheets Ask for Help	1	565	June 8, 2020
Showing addresses in Glide map component Project Showcase	23	4069	March 24, 2025
Geolocalization Ask for Help	24	1642	May 21, 2020

Automatic geocoding using Google Scripts

Related topics