@Dan_Liebeschutz thank you for this - it works perfectly!
I am having an issue with the script though and was wondering whether you have an idea how to solve it:
I use array formula to apply the formula to new rows. Every time a new row is added, the formula re-calculates the entire column’s coordinates which causes:
a. some down time before Glide refreshes and shows the pins on the map. This means that maps are not shown for a couple of minutes when a new row is added.
b. “Exception: Service invoked too many times for one day: geocode. (line 11).” - since my app is sending hundreds of requests each day, I reached a limit I wasn’t aware of.
I think it would be great if newly added rows would use geolocation for themselves only without recalculating the entire column. Any idea how to do that?
Thank in advance!