.png){kind=link}
Inventory Dashboard for Small Businesses built with Google Sheets and Google Apps Script.
SmartStock is a lightweight inventory management system that helps small businesses track stock movements, monitor revenue and profit, identify low-stock products, and visualize business performance through an interactive dashboard.
- Interactive Inventory Dashboard
- Google Apps Script Automation
- Automatic Stock Management
- Revenue & Profit Tracking
- Low Stock Monitoring
- Business Performance Dashboard
👉 View the live spreadsheet here:
https://docs.google.com/spreadsheets/d/1-GUmPKmXW34qSE2a9HO0hjdwIxpxtHgw1BoN0RI6sJQ/edit?usp=sharing
- Revenue overview
- Profit overview
- Units Sold
- Current Stock
- Product Count
- Add Transaction (Stock In / Stock Out)
- Automatic inventory updates
- Stock validation
- Prevent negative stock
- Revenue by Product
- Current Stock vs Shortage
- Best Selling Products
- Recent Transactions
- Business Status
- Low Stock Alert
- Google Apps Script custom modal
- Inventory menu
- Low stock checker
- Automatic dashboard refresh
- Google Sheets
- Google Apps Script (JavaScript)
- HTML
- CSS
Dashboard
│
├── Dashboard
├── Products
├── Transactions
└── Backend
- User clicks Add Transaction
- Selects Product
- Chooses Stock In or Stock Out
- Inventory updates automatically
- Dashboard refreshes instantly
- Business insights update automatically
- Total Revenue
- Total Profit
- Units Sold
- Active Products
- Current Stock
| File | Description |
|---|---|
| SmartStock.xlsx | Spreadsheet template |
| Code.gs | Google Apps Script backend |
| TransactionForm.html | Transaction modal |
- Export PDF Report
- Product Filters
- Date Filters
- Add Product Modal
- Weekly Email Report
- n8n Automation
- AI Business Insights
Built by Fara Aliwireja as part of an AI Automation Portfolio.