automation
Kosan Pagar Putih — Boarding House Automation
End-to-end WhatsApp automation for a boarding house: lead capture, rent billing, reminders, cash tracking, and an owner dashboard, all synced to Google Sheets.
- Role
- Solo builder: architecture, n8n workflows, chatbot, dashboard
- Period
- Oct 2026 – present
- Stack
- n8nWAHA (WhatsApp HTTP API)GeminiGoogle Sheets APIDockerLinux VPSAstro
Results
- Replaced manual WhatsApp follow-ups with an automated lead pipeline
- Automated monthly rent billing + reminders, cutting admin time to near zero
- Single source of truth in Google Sheets, read/write via a custom dashboard
- Weekly owner summary generated automatically
Problem
A boarding house with multiple rooms was managed entirely by hand: inquiries answered one by one on WhatsApp, rent reminders sent manually, payments tracked in a spreadsheet, and the owner had no quick overview of occupancy or arrears.
What I built
A self-hosted automation stack on a Linux VPS:
- WAHA bridges WhatsApp to an HTTP webhook.
- n8n orchestrates workflows: lead qualification, billing, reminders, cash tracking, weekly summaries.
- Gemini classifies and replies to tenant messages in natural language.
- Google Sheets acts as the database (leads, tenants, billing, cash flow, config).
- KosPanel, a web dashboard, reads from and writes back to Sheets so the owner can manage everything from a browser.
How the data flows
Data flows: WhatsApp → WAHA → n8n → Gemini (for understanding) and → Google Sheets (for persistence). KosPanel reads/writes the same Sheets.
See the architecture diagram (sample data, sanitized).