AppSheet Google Sheets Inventory Automation -- 2

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.

Project ID: 40299752