Vehicle Management System – Google Sheets Apps Script

A vehicle management dashboard on Google Sheets. Vehicles, the drivers assigned to them, and the dates a car was taken and returned are kept as records rather than as a note in someone's phone — which is the difference between knowing where a vehicle is and assuming.

What it does

Each vehicle is stored with its status, plate number and chassis number, and photos can be uploaded against it. Drivers are managed with their contact details and assigned to vehicles, with the taken and returned dates recorded on the handover. The whole thing is a create, read, update and delete dashboard behind an admin and user login, so staff work in a form instead of typing into spreadsheet cells where one misplaced entry shifts a column.

Highlights

• Vehicle records: status, plate number, chassis number
• Driver management with contact information
• Driver assignment with taken and returned dates
• Image uploads against a vehicle
• Admin and user login
• Google Sheets as the database, no licence fees

Who it is for

Companies with pool cars, rental operators, delivery fleets, schools and any organisation lending vehicles to staff, where the question that matters is who has which vehicle and since when. For revenue, driver payments and profit, the fleet management build in the catalog goes further.