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.