Architecture Overview
The system follows a simple data pipeline:
PWA Frontend → Apps Script API → Google Sheets Storage → Looker Studio Visualization
Key Design Decisions
Progressive Web App (PWA)
- Cross-platform compatibility without app store complexity
- Offline capability for data entry
- Native app-like experience with zero deployment friction
Apps Script Microservice
- Serverless execution with automatic scaling
- RESTful POST endpoint for data ingestion
- Built-in Google Workspace integration
- Zero infrastructure management required
Google Sheets as Database
- Familiar interface for data validation and manual corrections
- Automatic backups and version history
- Real-time collaboration capabilities
- Direct integration with Looker Studio
Looker Studio Dashboards
- Automatic visualization updates as data flows in
- Professional reporting with little/simple configuration
- Shareable dashboards and scheduled reports
Technical Highlights
Cost
$0 monthly operating cost
Scalability
The App Script handles thousands of requests via Google's infrastructure
Observability
Integrated logging for debugging and monitoring
Security
Can be extended with OAuth-based authentication through Google's ecosystem