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