search

nuket / google-sheets-geocoding-macro

Geocode from addresses to latitude / longitude, and vice versa using Google Sheets
334 stars 148 forks source link

This app has not yet been verified by Google in order to use Google Sign in #12

Closed LPchong closed 3 years ago

LPchong commented 4 years ago

I tried to run the code and authorise the access but received below message. Sign in with Google temporarily disabled for this app This app has not yet been verified by Google in order to use Google Sign in.

Any ideas how to fix it?

Krukarius commented 4 years ago

Yep, I have got exactly the same problem!

nuket commented 4 years ago

Without having time to look at it, I'm gonna guess they tightened up their APIs to require some kind of an API key for the Geocoder constructor, which this code never used since it was before this code's time.

https://github.com/nuket/google-sheets-geocoding-macro/blob/master/Code.gs#L345 https://github.com/nuket/google-sheets-geocoding-macro/blob/master/Code.gs#L400

nuket commented 3 years ago

This probably does the trick: https://developers.google.com/apps-script/reference/maps/maps#setAuthentication(String,String)

Penworks commented 3 years ago

I had cause to use this script recently to test two GSheet GIS tables (that use SheetSee.js to display results from a form submission). It works fine. You are warned about 'trust' for the script but once you agree, it all works. You need to give that approval for each sheet you run it with.