Brewnest
Artisanal Café & Workspace Portal with Lean Serverless Operations
↳Asynchronous reservation submission dispatched directly into a sanitized Google Sheets operational log
What was this and who was it for?
A concept web application designed for boutique café owners who need modern digital reservation workflows and clear operational status without the ongoing overhead of cloud databases or dedicated server infrastructure.
What was broken, frustrating, or missing?
Small hospitality businesses often get locked into expensive monthly reservation SaaS platforms or attempt complex custom backend builds that break when staff changes occur.
Design & Platform Boundaries
- [1]$0 continuous operating expense.
- [2]Must be intuitive for non-technical staff to manage reservations directly in familiar spreadsheets.
- [3]Instant loading and battery-efficient performance on mobile devices over cellular connections.
Architectural & UX Strategy
Built a mobile-first responsive frontend connected to a Google Apps Script web endpoint that validates, sanitizes, and appends reservation payloads directly into the café manager's Google Sheet.
Execution Highlights
What was compromised & what was gained?
- /Accepted minor execution latency inherent in Google Apps Script cold starts (1–2s) in exchange for zero monthly infrastructure bills.
- /Relied on client-side state checks rather than real-time WebSocket seat sensors.
Verifiable Outcome
A highly polished, mobile-friendly café presence that provides real business utility and operational clarity for zero monthly hosting expenditure.
"Good engineering is about finding the leanest architecture that solves the actual human problem. A well-designed Google Sheets backend is often vastly superior to an over-engineered microservice stack for a local business."