Determine the Driving Distance/Time between 2 Addresses

[Tom_Jeffrey]

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

[Csanko]

Hi Tom,

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

Br,
Casper

[Andy_Cloke]

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

datafetcher.com

Calculate Time & Distance Between 2 Points in Airtable using Google Maps API

In this guide, we will calculate the time & distance between two points in Airtable using the Google Maps API and the Data Fetcher app.

You can then run that API request from a button field