check lat lng appscript

check-lat-lng.gs

function printLatLng(input){
  var r = Maps.newGeocoder().geocode(input);
  for (var i = 0; i < r.results.length; i++) {
    var res = r.results[i];
    console.log(input, res.geometry.location.lat + ", " + res.geometry.location.lng);
  }
}

function myFunction() {
/** @OnlyCurrentDoc */
  var sheet = SpreadsheetApp.getActiveSheet();
  var addresses = sheet.getRange('D2:D82').getValues();

  for (var i = 0; i < addresses.length; i++){
    //if (addresses[i] != "") console.log(addresses[i]);
    
    if (addresses[i] != ""){
      var address = addresses[i];
      var r = Maps.newGeocoder().geocode(address);
      printLatLng(r);
    }   
  }
}