How it works

1. A scheduled check looks for new rows with route coordinates in your Google Sheet. 2. For each route, an HTTP request calls the driving directions API for trucks. 3. The response is parsed. 4. Route id, distance and duration are appended to a results tab.