How to pull drive times to multiple addresses from google maps into a sheet?

[ARJ2202]

Hello Google Community,

I'm enlisting the help from those of you far more skilled than me. Basically, I am wondering if there is a way to pull the drive times to a set list of multiple addresses from an address I input. Is there also a way to do this AND be able to choose the time and day of your route like you can for directions on google maps? This is something me and my team have to do A LOT for work and we do it manually for roughly 60 locations for each place and I'm hoping there is a way to make our lives easier. I thank you in advanced for your suggestions.

[marc_aguilar · Accepted solution]

Hello, yes there is a way. You could be able to get the driving time from an adress to another, considering as well the departure time or even the desired time of arrival by using the Google Distance Matrix API.

If you want to stay at Workspace, you could code it within Google Apps Scripts.

Have a look in the developers google documentation:

https://developers.google.com/maps/documentation/distance-matrix/distance-matrix