Automated Sales Monitoring Tool Development
Syif Bhuiyan
🔍 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
📎 Live Sheet Link
Like this project
Posted May 19, 2025
Developed an automated sales monitoring tool using Google Sheets and Apps Script.
Likes
1
Views
0
Customer Demographics and Spending Analysis
SQL Analysis of Chinook Music Store Database
