Kozy: Room Catalogue with Google Sheets as Admin

website

Kozy is a room rental website for owners who already manage everything in a spreadsheet. Instead of building a CMS and a database, the Google Sheet is the admin panel.

Image

The home page shows every location with live counts of available rooms and starting prices. Availability is read from the Sheet at request time and served as server-rendered HTML cached at the edge, so visitors get fast pages while the Sheet stays the single source of truth.

Image

Each location page lists its address, photos, shared facilities and room availability. Every location can have its own WhatsApp number, so each chat button goes straight to the right person.

When the owner edits a cell, the site catches up within one to two minutes. A secret purge link, bookmarked as "Refresh website", makes changes live immediately. The build bakes a copy of the Sheet into the bundle and the server keeps a last-good copy, so the site keeps serving real data even if Google is unreachable. The result is a fast, reliable site with no database, no admin login and almost no running cost.

Tags

react typescript tanstack tailwind