Key Features:
Batch Route Processing: Automatically calculates distance and estimated travel time for hundreds of routes listed in a Google Sheet without any manual intervention.
Specialized Vehicle Routing: Supports multiple driving profiles, including standard individual trucks (driving-car) and heavy commercial vehicles (driving-hgv), ensuring accurate time estimates for logistics.
Direct CRM Sync: Pulls departure and destination data directly from Google Sheets and writes the calculated results (distance, duration, and trip steps) back to the same sheet in real-time.
Rate-Limit Protection: Includes an intelligent 5-second buffer between requests to comply with API standards, ensuring the system runs smoothly without interruptions or IP bans.
Precise Geolocation Logic: Uses exact longitude and latitude coordinates to provide high-precision routing that standard map searches often miss.
Target Audience
Logistics & Trucking Companies: To automate the calculation of trip distances for driver payouts and fuel estimates.
E-commerce & Last-Mile Delivery Services: To optimize delivery windows and provide accurate arrival times to customers.
Supply Chain Managers: For auditing transportation invoices and checking if the billed distance matches the actual optimized route.
Field Service Providers: For planning the daily routes of technicians or sales teams to minimize travel time and costs.
Information Required
Google Sheet Access: A spreadsheet containing the columns for Departure and Destination (City names or Lat/Long coordinates).
Open Route Service API Key: A free or paid API key from OpenRouteService.org (we can assist in generating this).
Google Cloud Credentials: API access to read and write to the client’s Google Sheets.
Vehicle Profile: Specific requirements for the route (e.g., whether it’s for a small bike, a car, or a heavy 10-wheeler truck).