A production-grade data automation and visualization system that synchronizes Google Sheets data, performs controlled time-based updates, and presents results through a clean, deployable web dashboard.
Automation Master 25-26 is designed to solve a real-world automation problem:
keeping analytical dashboards updated from a continuously growing master dataset without manual intervention.
The system integrates:
- Google Sheets (as the data source)
- Google Apps Script (as the automation engine)
- A static web dashboard (HTML/CSS/JS)
- Render (for public deployment)
The architecture is intentionally modular, making the project suitable for academic evaluation, internships, and real deployment scenarios.
- Automate extraction of sales data from a master Google Sheet
- Process and aggregate data incrementally (row-by-row, day-by-day)
- Avoid repeated data duplication on each update
- Provide a versioned dashboard (Day 1, Day 2, Day 3 progression)
- Deploy a clean UI accessible publicly
- Maintain a clear V1 → V2 evolution structure
Ramkumar R
Automation | Data Systems | Full-Stack Integration
This project is intended for educational and demonstrative purposes.
Reuse with attribution is encouraged.