Easy geocoding addresses. Translate your street names into GPS coordinates, fast easy and powerful thanks to Google Maps
By:
Listing updated:October 4, 2022
Works with:
347K+
Overview
Geocoding is the task of transforming addresses into GPS coordinates. This task is made by Google Maps which can easily do this translations with high accuracy.

v 0.3.5 - Bug of Exception: The parameters (number[]) solved. Problem detected with Google Maps API limits.
Additional information
PricingNot available
Developer
Non-trader
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
Geocoding by SmartMonkey will ask for the permissions shown below. Learn more
Geocoding by SmartMonkey will need access to your Google account
This will allow Geocoding by SmartMonkey to :
See, edit, create, and delete all your Google Sheets spreadsheets
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Dylan Buttera
June 27, 2022
Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues. I used this twice in a row on two different datasets, and then when doing the third, it produced the error repeatedly. I use this tool every week to maintain a list of stores where certain products can be found, and it usually doesn't give me any grief, but occasionally it does this. Each week I also do all of this after using a large auto email script. Someone commented saying there was maybe a Google limit being reached? Not sure but that kind of seems to make sense. Yesterday I was writing a little Google App Script that combines some data into a PDF and had to test many times before getting the desired results. Could that possibly affect the same limit mentioned before? I don't know but I wish there was an answer one way or another somewhere.
Is this review helpful?
Yes
No
Profile Picture
Daniel Pinon
December 6, 2021
I hope this isn't a foolish review, but: it was working wonderfully and I found myself extremely happy/satisfied with how versatile and flexible it seemed to be with the inputs; it wasn't overly rigid with the syntax and still produced coordinates as needed. However, like others below, I came across the error "Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues." which seems to have been a kiss of death. Irrespective of however the address (single or spreadsheet) is input, it produces the same message. It's possible it's a Google API limit (as suggested by another user below, albeit for a different issue) but, all the same, it doesn't produce information when formatted perfectly using a variable/data point that I've separately confirmed the coordinates. I hope it's fixed soon! It was wonderful prior.
Is this review helpful?
Yes
No
Profile Picture
Tammi Mayson
October 12, 2022
It doesn't work. There's no code in the templates, they're just plain text.
Is this review helpful?
Yes
No
Profile Picture
Janez Vocovnik
November 23, 2022
I was about to quit on this tool before I figured out how to use it... (start with template, add you address, geocode...). Wouldn't mind some instructions...
Is this review helpful?
Yes
No
Profile Picture
Rachel Hamilton
October 4, 2021
This was working so well! Until I kept getting the error message: Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues. Now I can't seem to fix it at all
Is this review helpful?
Yes
No
Profile Picture
Javier Monge
May 2, 2021
I'm keep getting this error: TypeError: Cannot read property 'getLastRow' of null. Does anyone know if this actually worked some time ago?
Is this review helpful?
Yes
No
Profile Picture
Jack Dougherty
August 19, 2020
Excellent app to geocode address/location data inside your Google Sheet. One feature I really like is the "Add-on > Geocoding > Create template" menu, which adds a new tab to your sheet with three column headers (Address, Country, Coordinates) and several rows of sample data. It demonstrates how to enter your data, then you select "Add-on > Geocoding > Geocode" to run the script and view your coordinates.
Is this review helpful?
Yes
No
Profile Picture
Syed Ahmed Raza
April 15, 2021
I am keep getting this error message given below. Please someone help. Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues.
Is this review helpful?
Yes
No
Profile Picture
rodney “Austin” ochimas
March 4, 2021
so fair so good
Is this review helpful?
Yes
No
Profile Picture
rosy A
January 4, 2021
Very Nice
Is this review helpful?
Yes
No
1-10 of 14
Search
Clear search
Close search
Google apps
Main menu