My app shows locations on a map, but I’ve run into a bit of an issue. Addresses in Hebrew are not displayed at all on Glide, and since my app is aimed at Israelis, that’s a blocker for the app to be released. I’m looking to solve this by geocoding addresses and displaying the pins on the map according to the coordinates, and this is where I could use your help: Is there a way to automatically geocode addresses as they are entered in the spreadsheet? So far all I could find are scripts, Sheets add-ons and Macros that require me to click a button for them to run. Any ideas?

Take a look here. [image] Wrong addressing This is probably the best answer to date for correct addresses in the map. Add the script to your sheet and point your map addresses to the lat/long field in your sheet. Thanks to @Dan_Liebeschutz for the well written article.

Scripts can be triggered by “non-manual” events. I’d bet you can accomplish this with Zapier as well if you don’t want to use a script. Though with a quick search Zapier doesn’t seem to have a geocoding integration. I could be wrong. You may have to try another platform like Integromat. https://www.integromat.com/en/integrations/google-maps/zapier

Thanks @Tim_Sullivan and @Adam_Acosta - I’m looking into both solutions right now!

@Tim_Sullivan works like a charm! Thanks a lot! :partying_face:

@Ofer_Chama: We have used this and it worked really well… https://gsuite.google.com/u/1/marketplace/app/geocode_by_awesome_table/904124517349?pann=cwsdp&hl=en-GB

Thanks, I saw it earlier but wasn’t sure it could be triggered whenever a new row is added

@Ofer_Chama: the solution described on Medium doesn’t work for our case as we need to preserve the long form address for other purposes. We have over 500 listings and some geocoding was failing when we were using an Opencage Data script. The Awesome Table add-on solved that problem because for failed geocoding attempts it has a ‘widen range’ feature.

Automatic geocoding in Sheets

Ask for Help

Tim_Sullivan June 12, 2020, 5:19pm 3

Take a look here.

Topic		Replies	Views
Automatic geocoding using Google Scripts Ask for Help	37	5450	June 26, 2025
Geocoding addresses in Google Sheets Ask for Help	1	565	June 8, 2020
Wrong addressing Ask for Help	18	1350	December 10, 2020
Latitude and longitude values for given address using the Google Maps Geocoder Ask for Help	2	1204	September 3, 2021
Showing addresses in Glide map component Project Showcase	23	4077	March 24, 2025

Automatic geocoding in Sheets

Related topics