Determine the Driving Distance/Time between 2 Addresses

Topic Labels: Scripting extentions
2361 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

Thank you!!

2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Tom,

I’m looking for something similar to your scenario. Did you find a solution?


This is really easy to set up using the Data Fetcher extension to connect Airtable to the Google Maps Distance Matrix API.

You can then run that API request from a button field