Determine the Driving Distance/Time between 2 Addresses

I am building out a road trip planner and would like to calculate the distance between two inputted addresses in:

  • Driving Miles
  • Driving Hours

I plan to set up a Button Field connected to this script, so every time I add a new stop along the route, I can manually run the script to determine driving distance and time (recorded in 2 separate fields) between the new stop and the previous one.

There are a number of examples using the Script Editor in Google Spreadsheets alongside the Google Maps API:
*Using the Google Maps Distance Matrix API
*Using Script Editor
*Sample

Thank you!!