Workout Tracker: React PWA + Google Sheets + Apps Script
Developed a workout tracking progressive web application (PWA) using Google Sheets as a backend database for logging workouts, viewing analytics, and tracking fitness progress.
Technical Implementation:
Data Architecture: Google Sheets API for reads, multiple Apps Scripts for CRUD operations (creating, editing, deleting workouts) with validation, automated script generates TypeScript definitions from Sheets schema
Frontend & Analytics: React PWA, React Router, visualizations for progressive overload, sleep quality, exercise history, and estimated one-rep max calculations with Recharts
PWA Features (In Progress): Service worker with local storage queue for offline logging, automatic sync to Google Sheets when connectivity restored
🔗 Website: https://luigigirke.com
💼 LinkedIn: / luigigirke
💻 GitHub: https://github.com/devdogfish