How to Calculate the Distance Between Two Addresses in Google Sheets

Code.gs

function CALCULATE_DRIVING_DISTANCE(origin, destination) {
  var directions = Maps.newDirectionFinder()
    .setOrigin(origin)
    .setDestination(destination)
    .setMode(Maps.DirectionFinder.Mode.DRIVING)
    .getDirections();

  var distance = directions.routes[0].legs[0].distance.value;

  distance /= 1000; // Convert meters to kilometers
  return Number (distance.toFixed(2));
}