Google SpreadSheet Address to Latitude / Longitude

function getLatLong(adress) {
  try{
    if(adress=="")return("");
    var geo = Maps.newGeocoder().geocode(adress);
    if(geo.status=="OK"){
      var lng = geo.results[0].geometry.viewport.southwest.lng;
      var lat = geo.results[0].geometry.viewport.southwest.lat;
      return([lat,lng]);
    }  
    else{
      return("error");
    }  
  }
  catch(err){
    return(err);
  }
}

    A | B | C
1  Taipei | =TRANSPOSE(getLatLong(A1)) | 2
3

References :

How to get Latitude and Longitude for Addresses?

Utilities.jsonStringify is deprecated

Utilities.jsonParse() -> JSON.parse()
Utilities.jsonStringify() -> JSON.stringify()




References :
Apps Script News on Twitter: "Google Apps Script methods Utilities.jsonParse() and Utilities.jsonStringify() have been deprecated | @scoopit http://t.co/RIShoZ2T7X"

Google Apps Script fetch external url

var response = UrlFetchApp.fetch("http://example.com/api/id=1");
var json = response.getContentText();
var data = JSON.parse(json);
Logger.log(data);

References :
External APIs - Google Apps Script — Google Developers
Class HTTPResponse - Google Apps Script — Google Developers