Use Google Sheets to Summarize Fuel and Cost Data for Management

What This Does

Instead of staring at a table of fuel and vehicle cost numbers, use Google Sheets Gemini AI to identify the biggest cost drivers, flag unusual spending, and write the narrative summary your manager expects, in 5 minutes instead of an hour.

Before You Start

• You have a Google account and access to Google Sheets
• You have monthly fuel/cost data from your fleet management system (Samsara, Fleetio, or even a basic spreadsheet)
• Your data includes at minimum: vehicle ID or driver name, fuel cost, miles driven, and maintenance costs
• Time needed: 10 minutes first time; 5 minutes monthly after
• Cost: Free

Steps

1. Get your cost data into a Google Sheet

Export from Samsara, Fleetio, or your fleet management system. If there's no export, create a simple table manually: Vehicle, Month, Fuel Cost, Miles, Maintenance Cost.

What you should see: A table with at least 4-5 columns and one row per vehicle per month.

2. Open the Gemini sidebar

Click the sparkle/star icon in the right toolbar or go to Extensions → Gemini in Sheets.

3. Ask for the cost analysis

Type in the Gemini input box: "This is my vehicle fleet cost data for [month/quarter]. What are the top cost drivers? Which vehicle is most expensive to operate? Are there any unusual spikes I should investigate? Write a 3-sentence summary I can include in my monthly report."

What you should see: A written narrative identifying the highest-cost vehicles, any anomalies, and a summary sentence.

4. Use the output in your report

Copy the Gemini-generated summary into your monthly management report, adjusting any numbers or details that need correction.

Real Example

Scenario: You have 15 vans' worth of March fuel and maintenance data and need to include a cost summary in your quarterly operations review.

Data you have: Vehicle IDs, March fuel cost, March mileage, and maintenance charges for each van.

What you type: "This is my fleet cost data for March 2026. Which vehicle costs the most to operate? Any vehicles with unusual maintenance costs? Write a short summary for my management report."

What you get: "Fleet fuel costs for March totaled $12,847, a 6% increase from February driven primarily by increased mileage in Zone 3 due to route expansion. Van #14 had the highest maintenance cost ($1,243) due to brake replacement, this vehicle is now in normal range. Van #7 shows elevated fuel consumption relative to its mileage; recommend a mechanic inspection. Overall fleet cost per mile held steady at $0.48."

Tips

• Even rough data produces useful analysis. a few missing rows won't break the summary
• If Gemini isn't available, paste your summary statistics into ChatGPT with the same question
• Add a "Notes" column explaining any unusual costs before running the analysis so the AI output reflects the real situation

Tool interfaces change, if the Gemini button has moved, look for AI, Gemini, or Smart options in the Extensions or sidebar menu.