Google Sheet to pull mileage from Google Maps API

Hello everyone,

I need GSheet script to pull travel distances from GMaps API for each vehicle listed, and how many miles it has made in which country.

For example - today I’m driving vehicle A from Hodgkins, IL to Youngwood, PA, so I’d like to know how many miles I made in every country I went through (if I was in 5 states, then I want mileage for all 5 of them separately). I’d also like the script to recognize that there is more than one vehicle and categorize mileage accordingly.

I’ll have a sheet with “from” and “to” colums, with worksheet for each vehicle and it’s routes. The script should make worksheet for it’s results with column names to be vehicles ID’s, and row numbers to be state’s.

If feasible, send me your best quote and delivery estimate please.

Best,
Boris