Automated Routing Data Collection to Google Sheets

This n8n workflow automates the process of collecting driving distances and durations between multiple routes and storing the results in a Google Sheet. It integrates with the Open Route Service API for route calculations and uses Google Sheets for data input and output. The workflow begins with triggering either manually or automatically, loads route data from Google Sheets, and loops through each entry to request the latest route information via API. It then extracts relevant data such as distance, duration, and steps, and updates the Google Sheet with these details. The process is designed to be repeated periodically, with pauses introduced to prevent API overload, making it ideal for logistics planning, fleet management, or route optimization scenarios.