Spot fuel economy outliers in your fleet before small problems become big fuel bills
Every Monday, WebRun opens Fleetio, retrieves the past week's fuel economy data for every vehicle, calculates each unit's MPG or fuel consumption rate, compares it to the class average, and logs a ranked outlier report to Google Sheets so your fuel manager can investigate or schedule diagnostics.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I find fleet vehicles with abnormal fuel consumption automatically?
WebRun pulls a week of fuel data from Fleetio every Monday, calculates each vehicle's fuel economy, and compares it to its class average. Vehicles more than 15 percent below average are flagged as outliers and logged to a Google Sheet, ranked by deviation, so your fuel manager can investigate before a small inefficiency becomes a large expense.
- Fuel-wasting vehicles are spotted before the problem compounds into a major cost
- Outliers are ranked by deviation so the worst cases get attention first
- Weekly trend data builds over time in Google Sheets for budget planning
Built for fleet managers · fuel managers · transportation cost analysts · logistics operators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.fleetio.comin a real browser with your saved login - no setup, no API keys. -
1
Fleetio - pull weekly fuel economy data by vehicle
fleetio.com How to Automate Fleetio
WebRun opens Fleetio to pull weekly fuel economy data by vehicle. - Open Fleetio and navigate to Fuel and then Fuel History
- Filter for fuel entries from the past 7 days
- Calculate MPG or L/100km for each vehicle from fuel logs and odometer readings
- Compare each vehicle's weekly average to its vehicle class average in Fleetio
- Flag any vehicle more than 15 percent below its class average as an outlier
Done when Every vehicle with abnormal fuel consumption is identified and ranked by deviation.
-
2
Google Sheets - log ranked outlier report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log ranked outlier report. - Open the fleet fuel economy tracking sheet
- Append this week's outlier report with vehicle unit, fuel economy, class average, and percent deviation
- Highlight the worst offenders in red for easy identification
Done when This week's fuel outlier report is appended to the sheet with deviation percentages and highlights.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What deviation threshold triggers an outlier flag?
The default is 15 percent below class average, but you can set your own threshold during setup to match your fleet's acceptable variance range.
Does it account for different vehicle types having different expected fuel consumption?
Yes. Fleetio groups vehicles by class, and WebRun compares each unit to others in its own class, so a heavy truck is not unfairly compared to a light van.
Will it book a diagnostic appointment for a flagged vehicle?
No. WebRun surfaces the outliers in the sheet for your fuel manager to investigate. Scheduling a diagnostic is a human decision based on the data.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.