reddit · SideProject · 10-27 04:50 57 分 ← 返回列表

I built a warehouse system that runs entirely inside the customer's own Google account — Sheets as a headless DB, zero infrastructure

I manage the warehouse for a small glass and windows company. We ran inventory on a plain Google Sheet for two years, and it worked until it didn't: two people editing at once, no rack-level visibility, and no clean way to see what a job actually consumed. Nobody wanted another subscription or another login, and we were already on Workspace — so I built the app on top of Apps Script and kept the Sheet as the database. Bring your own sheet, basically. It installs into the customer's own Apps

五维评分

付费意愿

需求真实度

个人可落地

竞争空间

新鲜度

AI 分析

痛点：小公司用Google Sheets管理仓库库存时遇到并发编辑冲突、缺乏货架级可视性和物料消耗追踪，但又不愿增加订阅或登录。

目标用户：使用Google Workspace的中小企业仓库/库存管理者，尤其是玻璃、门窗等细分行业。

证据：Nobody wanted another subscription or another login, and we were already on Workspace — so I built the app on top of Apps Script and kept the Sheet as the database.

变现：一次性买断或按安装收费的Apps Script模板/插件，或提供定制部署服务；避免订阅制以符合用户偏好。

MVP：基于Google Apps Script开发一个轻量级库存管理应用，利用Sheets作为数据库，提供并发写入锁、货架级库存视图和消耗追踪，可安装到客户自己的Google账号，2周内可完成核心功能。

竞品：Google Sheets库存模板、Zoho Inventory、Sortly、Fishbowl、Odoo Inventory

摘要：作者为自家玻璃门窗公司仓库开发了一个完全运行在客户Google账号内的仓库系统，用Sheets作为无头数据库，Apps Script实现应用逻辑，解决了多人同时编辑和货架级库存可见性问题。上线后仓库员工不再打开底层表格，全部在应用内操作。作者强调没有服务器、数据不离客户Drive，但提到“没人想要另一个订阅或登录”，暗示对付费订阅的抵触。