Simple Maps Apps Script

maps.js

/**
 * Gets driving directions from Mountain View to San Francisco.
 * Derived from https://github.com/googleworkspace/apps-script-samples/blob/main/sheets/maps/maps.gs
 * @customfunction
 */
function getDrivingDirections() {
  // Set starting and ending addresses
  var start = '1600 Amphitheatre Pkwy, Mountain View, CA 94043';
  var end = '345 Spear St, San Francisco, CA 94105';
  var directions = Maps.newDirectionFinder().setOrigin(start).setDestination(end).getDirections();
  // html to text: https://stackoverflow.com/a/5002161
  return directions.routes[0].legs[0].steps.map((s) => s.html_instructions.replace(/<\/?[^>]+(>|$)/g, ""));
}