Excuse my breaking this out, but it's really a permissions question and not a use-case. I feel.
I found two separate threads pertaining to pulling addresses from the places api using place name, city and state here. (Retrieving location address based on place name and city in Google Spreadsheet). I tried it at the office today and it worked gloriously. I showed it to a few co-workers, but when they left and I drug the formula bar down the column of the spreadsheet I was working on, I ended up with #ERROR! (TypeError: Cannot read property "formatted_address" from undefined. (line 8). <- Refer to source script in the link above for code. I used it as written.) The error popped up not only for new addresses, but for the 80 or so I had already done. I assumed that it may have been because the pull-down would have submitted about 600 places at once and I probably went over quota.
I tried it again from home with a different account and key (as my original from the office was still returning errors and again it worked fine. I once again used a cell drag to populate the function in my spreadsheet, this time, 5 rows at a time and had the same thing happen when I reached row 76. I thought that it may be because I didn't have the places API enabled in the function or sheet, enabled the API and it looked like the issue was fixed, but it died again on row 83.
So now I'm a bit perplexed. The code and sheet are apparently fine as are my permissions, as everything that is in the sheet did work earlier, but I'm now showing an ERROR! on all of the cells that were displaying addresses not 15 minutes ago and nothing has changed aside from the fact that I tried using the same function that worked fine on rows 4-82 on row 83... which broke everything.
Is there something outside the scope of the stackoverflow suggestion and code aside from enabling the places api that I need in order to have this work for more than a short time or limited amount of records (under the 1000 record/day ceiling)?
-Scott
Script ----
function mapAddress(place, city, state) {
var API_KEY = '<My Key>';
var url = 'https://maps.googleapis.com/maps/api/place/textsearch/json?
query=' + place + ' ' + city + ' ' + state + '&key=' + API_KEY;
var response = UrlFetchApp.fetch(url);
var json = response.getContentText();
obj = JSON.parse(json);
addr = obj.results[0].formatted_address;
return addr;
}
