Extract time and distance from google directions api for list of postcodes in Excel

Required ASAP

Hi,

I want to be able to take a travel route, shown as a list of UK postcodes in excel, and then get the travel time (seconds or minutes) and distance (miles) between each postcode on the route and save this information in the same excel spreadsheet.

An idea would be that I start with a spreadsheet with name, address and postcodes in running order (columns A:C) then time between locations in column D and distance/miles between locations in column E using a macro and google api. Plus a map displayed that I can print/save. See example attached.

Quotes and alternative ideas welcomed.

Regards