# Automatic geocoding in Sheets **URL:** \ **Category:** Ask for Help\ **Created:** [June 12, 2020, 4:48pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745 "2020-06-12T16:48:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Ofer\_Chama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ofer_chama/32/9007_2.png) [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)\ **Post date:** [June 12, 2020, 4:48pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/1 "2020-06-12T16:48:32Z")
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? ---
**Author:** ![Adam\_Acosta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_acosta/32/73_2.png) [@Adam\_Acosta](https://community.glideapps.com/u/Adam_Acosta)\ **Post date:** [June 12, 2020, 5:09pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/2 "2020-06-12T17:09:31Z")
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](https://www.integromat.com/en/integrations/google-maps/zapier) ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [June 12, 2020, 5:19pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/3 "2020-06-12T17:19:44Z")
Take a look here. > [@Wrong addressing](https://community.glideapps.com/t/wrong-addressing/9312/2): > > 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. ---
**Author:** ![Ofer\_Chama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ofer_chama/32/9007_2.png) [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)\ **Post date:** [June 12, 2020, 5:21pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/4 "2020-06-12T17:21:57Z")
Thanks @Tim_Sullivan and @Adam_Acosta - I’m looking into both solutions right now! ---
**Author:** ![Ofer\_Chama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ofer_chama/32/9007_2.png) [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)\ **Post date:** [June 12, 2020, 5:48pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/5 "2020-06-12T17:48:23Z")
@Tim_Sullivan works like a charm! Thanks a lot! 🥳 ---
**Author:** ![garrison](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garrison/32/22059_2.png) [@garrison](https://community.glideapps.com/u/garrison)\ **Post date:** [June 12, 2020, 8:48pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/6 "2020-06-12T20:48:59Z")
@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](https://gsuite.google.com/u/1/marketplace/app/geocode_by_awesome_table/904124517349?pann=cwsdp&hl=en-GB) ---
**Author:** ![Ofer\_Chama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ofer_chama/32/9007_2.png) [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)\ **Post date:** [June 12, 2020, 9:01pm UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/7 "2020-06-12T21:01:03Z")
Thanks, I saw it earlier but wasn’t sure it could be triggered whenever a new row is added ---
**Author:** ![garrison](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garrison/32/22059_2.png) [@garrison](https://community.glideapps.com/u/garrison)\ **Post date:** [June 13, 2020, 8:24am UTC](https://community.glideapps.com/t/automatic-geocoding-in-sheets/10745/8 "2020-06-13T08:24:33Z")
@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.