MD
Back

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).

Dashboard demo

KosPanel demo: occupancy, room status, billing and cash, read live from Google Sheets.
WhatsApp flow demo: a prospective tenant asks about price, availability and a viewing, and the bot answers from the same data. Every reply lands in one thread the owner can read.

Architecture