The problem

A Tangier logistics SME logs fuel receipts, trip sheets and repairs in scattered spreadsheets. The manager only spots fuel overconsumption or overdue maintenance weeks too late.

The solution, step by step

  1. Centralize daily driver entries (km, fuel, incidents) in one Google Sheets file filled via a simple mobile form.
  2. Every Sunday night, an n8n workflow aggregates the week per vehicle and per driver.
  3. ChatGPT analyzes the numbers against the previous 8 weeks and writes a short brief: anomalies, top/bottom consumption, upcoming maintenance by mileage.
  4. The report is emailed via Gmail to the manager and the workshop chief.
  5. Any vehicle exceeding its fuel baseline by 15% triggers an immediate alert.

    6. Result and estimated gains

    • Fuel anomalies detected in days instead of a month — typically 5 to 8% fuel savings.
    • Preventive maintenance done on time, fewer breakdowns on the road.
    • Half a day of admin saved every week.