AppSheet Google Sheets Inventory Automation -- 2
Budget: $30 – $250 SGD
I need a streamlined inventory system that sits on top of a Google Sheet and is fully powered by AppSheet. The sheet will store all core data, while AppSheet provides the front-end where barcodes are scanned to add or remove products.
Scope
• Track finished products only; no raw materials or office supplies are involved.
• Every scan must update on-hand quantity instantly, send low-stock alerts, record the transaction as a sale when it is an outbound movement, and tag the supplier when goods are received.
• Stock alerts need to fire by e-mail and in-app when levels drop below a threshold I can edit.
• Sales tracking must aggregate daily, weekly, and monthly totals in a separate “Sales” tab and appear in AppSheet dashboards.
• Supplier management should let me view supplier contact info, last purchase date, and reorder lead time from inside the app.
Deliverables
- A Google Sheet structured with Products, Suppliers, Transactions, and Sales summary tabs, including all required formulas or Apps Script triggers.
- An AppSheet app connected to that sheet with barcode scanning enabled for product in/out, conditional logic for stock alerts, and summary dashboards.
- Short Loom or similar walkthrough video plus a PDF quick-start guide so my team can hit the ground running.
Success criteria
• Scanning a product reduces stock, logs a sale, and sends an alert if below threshold.
• Adding stock via scan increases quantity and records the supplier.
• Sales and supplier reporting update in real time without manual refresh.
I already have a Google Workspace account and can share a starter sheet; from there, I’ll grant AppSheet access. Let’s set up a quick call once you review the brief so we can lock down field names and alert thresholds.
Scope
• Track finished products only; no raw materials or office supplies are involved.
• Every scan must update on-hand quantity instantly, send low-stock alerts, record the transaction as a sale when it is an outbound movement, and tag the supplier when goods are received.
• Stock alerts need to fire by e-mail and in-app when levels drop below a threshold I can edit.
• Sales tracking must aggregate daily, weekly, and monthly totals in a separate “Sales” tab and appear in AppSheet dashboards.
• Supplier management should let me view supplier contact info, last purchase date, and reorder lead time from inside the app.
Deliverables
- A Google Sheet structured with Products, Suppliers, Transactions, and Sales summary tabs, including all required formulas or Apps Script triggers.
- An AppSheet app connected to that sheet with barcode scanning enabled for product in/out, conditional logic for stock alerts, and summary dashboards.
- Short Loom or similar walkthrough video plus a PDF quick-start guide so my team can hit the ground running.
Success criteria
• Scanning a product reduces stock, logs a sale, and sends an alert if below threshold.
• Adding stock via scan increases quantity and records the supplier.
• Sales and supplier reporting update in real time without manual refresh.
I already have a Google Workspace account and can share a starter sheet; from there, I’ll grant AppSheet access. Let’s set up a quick call once you review the brief so we can lock down field names and alert thresholds.