nuket / google-sheets-geocoding-macro Goto Github PK

View Code? Open in Web Editor NEW

332.0 332.0 148.0 6.23 MB

Geocode from addresses to latitude / longitude, and vice versa using Google Sheets

JavaScript 100.00%

google-sheets-geocoding-macro's People

Contributors

Stargazers

Watchers

Forkers

xhiena rawliquid jkelleher shauntyndall chrismp tongzz annydreams ericmason sar2160 henrycrawf hitesh90 federicoelles evanocio azique ilyankou aronmozio charmcreative jbelke quigley-brendan johnnyduo brianlevu jfiger nurettin jeffreylain shivaganeshb korymath alexstorer fillll robertosanval cryptowampum ciderpunx agustinapr chinhnhan takayukii rahul-ldn j-davies evaletolab boggyfresh mvaneijgen isaomatsunami mehdzi darrenthomas-dev vilnius viveksnh szikidani pandafulmanda subtlegradient drosenman stevendavis1 deboorn pharoah19 michaeloboyle miklobit zachewente ggallon margotsylvain padminirm jmc39 dakotablackdesign from1900 ranafugaz mkpandey100 toariela tnjulius davespry marekvasku vickyfi imaness prestonm jarias74 ichiriac joshuagob rvg296 awwm ecubo kga245 travelseekr-admin divyanshgaba cbeddow alonsocortes umairisrar landsurveyorsunited rydercz hviricel harietthecat niffadf essiloradria megacla3 irinaonline renansavidan mohammad-at syitzhak nlong-ds theowoo miguepiscy karthikrouthu lucasccrema hillbillysurf terryck bekerov

google-sheets-geocoding-macro's Issues

Skip those rows of addressToPosition where the lat/lon is already geocoded

This can be useful if the script running gets interrupted or times out and you'd want to restart it, ar you want to run the script in an incremental fashion for any reason.

Truncated values?

Hi,

I am very impressed by your script, I easily managed to geocode several addresses.
But, it seems long values could be truncated. So markers are not very accurate on Google Maps :/

For example:
Liverpool:
Returned values by your script :
Latitude: 53,4083714
Longitude: -2,9915726

Returned values by gps-coordinates.net
Latitude: 53.4083714
Longitude: -2.9915726000000404

Do you know why long values are be shorten?
I do not see specific settings in Google Sheet for that.

Thanks for your support!

Authentication to increase rate limit

Is there a way to authenticate this script with an API key to increase the daily rate limit? Thanks in advance

Was this ever approved?

Would be interesting to hear an update on the status.

Slow, almost unusable with medium sized tables

The more data on the page the longer each calculation takes.
Any ideas?
Is the page reloading every time each calculation completes?

Could you update this to get individual address components?

Could you possibly update this to get individual address components?
123 Street Name, City, CA, USA => 4 columns (Street address, City, Region, Country)

How do I run this on my spreadsheet?

It seems like Google changed it a little. I dont see an "Edit script" item in the Tools menu bar on Google Sheets.
I'm new to this. Can someone explain how I run it on my doc?
Thanks

Error Callback

when I manipulate a spreadsheet of 1000 rows it gives an error, callback limit of script, why? I need for scientific research

Automate

Hello, is it possible to set this up to automatically run and create latitude, longitude data from an address every time I add one to my sheet?

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

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?

What are the daily limits without the use of api key?

I have seen conflicting information in google docs, and my own experience has been inconsistent. Is it 250, 300, or 1000 a day? If I do batches of less than 50, should I be able to do an unlimited number in one day?

problems with ' chars in the address

Small bug: the script quits with an error if there's a quotation mark in the address.
example: 123 Queen's Road Central, Hong Kong

Can't understand how to use reverse geocoding

Can you help ?

Multi-column addresses

I use sheets which have multiple columns for addresses (e.g. address 1, address 2, town, postal code), but the script doesn't appear to support this (it won't geocode for two selected columns - only one). I know that I could concatenate the addresses, but is there a way to amend the script so that it can support multi-column addresses?

Map Cells in Mapping image throws error

Hi,

I'm attempting to run the 'Map cells in mapping sheet' function from the menu and I am flagged with this error 'TypeError: Cannot read property 'getRange' of null'. I initiate the function by highlighting three cells, the first two of which are the Lat and Long coordinates, then clicking the function in the menu. How can I resolve this error?