syifbhuiyan
📊 Automated Sales Dashboard in Google Sheets
🔍 Problem
Businesses want a simple tool to monitor sales and receive weekly reports automatically — without manual work.
🛠️ Tools Used
- Google Sheets
- Google Apps Script
- Pivot Tables, Charts, Formulas
- Automation via scheduled email
📦 Dataset
🚀 What It Does
- Live KPIs (Total Sales, Average Order Value, etc.)
- Auto-colored high-value orders
- Pivot Table + Bar Chart (Sales by Product Line)
- Button to send instant report
- Weekly email sent via Apps Script
📷 Screenshots
