スプレッドシートでリバースジオコード

developers.google.com

function reverseGeoCoding(lat, lng) {

  let geocoder = Maps.newGeocoder()
  geocoder.setLanguage('ja');

  let response = geocoder.reverseGeocode(lat, lng);
  let place = response.results[0].formatted_address.split(/\s+/).slice(1).join(' ');

  console.log(place);

  return place;
}

function get_latlng(s) {

  let geocoder = Maps.newGeocoder()
  geocoder.setLanguage('ja');

  let response = geocoder.geocode(s);
  result = response.results[0];

  let latlng = [result.geometry.location.lat, result.geometry.location.lng].toString();

  console.log(latlng);

  return latlng;

}