Overview
TrailerTrack is a real-time trailer-tracking dashboard I built and maintained for daily production use. It combines Firebase authentication, role-based admin and driver views, and automated ingestion of operational data. The project is currently paused.
Problem
The trucking business needed trailer information in a real-time dashboard alongside the Google Sheets workflow used for operations. Admin and driver-facing views also needed distinct access.
Constraints
- Work with operational data from Google Sheets.
- Separate admin and driver-facing access.
- Maintain real-time trailer information in the dashboard.
Architecture
The frontend uses React, Vite, and Tailwind CSS. Firebase Auth handles authentication, with role-based access for admin and driver-facing views. An event-driven ingestion pipeline uses Cloud Functions triggers to move Google Sheets data into Firestore. The application also uses the Google Maps API.
Decisions
Separate views by role
I implemented role-based access control for admin and driver-facing views rather than exposing the same interface to everyone.
Ingest changes through Cloud Functions
I built the Google Sheets to Firestore pipeline around Cloud Functions triggers to automate operational data sync.
Challenges
Connect spreadsheet data to a real-time dashboard
The ingestion pipeline connects the Google Sheets workflow to Firestore so operational data can appear in the dashboard.
Apply role-based access
Firebase authentication and role-based access distinguish the admin and driver-facing parts of the application.
Results
- Built and maintained a trailer-tracking dashboard that was used in daily production operations.
- Implemented Firebase Auth and admin/driver role-based access.
- Automated Google Sheets to Firestore ingestion through Cloud Functions triggers.
- The project is currently paused.
Current status
- Paused for the moment; no restart date is committed.