!geocode-to-sheet.md

https://googleappsscriptrc.blogspot.com/2018/04/geocode-to-sheet.html

code.gs

function geocode_Addresses() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var locationInfo = sheet.getRange("A:A").getValues();
  var result = [];
  for (var i = 0; i < locationInfo.length; i++) {
    var row = [];
    if(locationInfo[i][0].toString().length > 6){
      var geoResults = Maps.newGeocoder().geocode(locationInfo[i][0]);
      Utilities.sleep(1000);  
      if(geoResults.status == "OK"){
        var lat = geoResults.results[0].geometry.location.lat;
        var lng = geoResults.results[0].geometry.location.lng;
        row.push(Utilities.formatString(
          "=HYPERLINK(\"https://www.google.com/maps/?q=%s,%s\";\"%s, %s\")", 
          lat, 
          lng, 
          lat, 
          lng));
      }else {
        row.push("Не найдено совпадений");
      }
    } else {
      row.push("");
    }
    result.push(row);
  }
  sheet.getRange("B:B").setValues(result);
}