latlong.gs

function findLatLong() {
  Logger.log(SpreadsheetApp.getActive());
  var sheet = SpreadsheetApp.getActiveSheet();
  var range = sheet.getDataRange();
 
  var numRows = range.getNumRows();
  var numCols = range.getNumColumns();
  for (var i = 2; i <= numRows; i++) {
         var locality = range.getCell(i,1).getValue();
    
    var url = 'https://maps.googleapis.com/maps/api/geocode/json?'
    + 'address='
    + locality
    + '&sensor=false';
    var response = UrlFetchApp.fetch(url);
    
    Logger.log(response); 
    
    var pobj=JSON.parse(response);
    Logger.log(pobj);
    
    var long = pobj.results.geometry.location.lat;
     Logger.log(lat);    
    range.getCell(i,2).setValue(lat);
      //range.getCell(i,3).setValue(lat);
    }
  }