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.