Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Determine the Driving Distance/Time between 2 Addresses

Topic Labels: Scripting extentions
1496 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!!

2 Replies 2

Hi Tom,

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

Br,
Casper

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