I have a simple script:
function geozipmh(a) {
var response=Maps.newGeocoder()
.reverseGeocode(lat(a),long(a));
return response.results[0].formatted_address.split(',')[2].trim().split('
')[1];
}
function lat(pointa) {
var response = Maps.newGeocoder()
.geocode(pointa);
return response.results[0].geometry.location.lat
}
function long(pointa) {
var response = Maps.newGeocoder()
.geocode(pointa);
return response.results[0].geometry.location.lng
}ON the attached, I need the column Zip Code filled in, on my Google Sheet - for the first few it works great - Then I run into the "...invoked too many times error" [image: 2019-05-01 15_37_57-Contractor List - Master - Google Sheets.png] Can I upgrade to get this to work? How? I just need a populated sheet that I can export to Excel and call it a day. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
Zip Populate Example 1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
