Kosan Pagar Putih — Architecture

WhatsApp automation for boarding-house operations · sample data

SELF-MANAGED VPS · Linux · Docker · private network · scheduled backups webhook HTTP API write Google Sheets API · HTTPS · read/write Tenants & Owner WhatsApp WAHA WhatsApp HTTP API docker n8n workflow engine docker Gemini intent + reply external API Google Sheets data store LEAD CAPTURE parse inquiry qualify · dedupe append to Leads notify owner BILLING monthly cron generate bills send reminders track overdue CASH + SUMMARY record payment weekly owner digest GOOGLE SHEETS Leads — name · phone · pref · status Tenants — room · rent · due date Billing — month · amount · paid CashFlow — date · type · amount Summary — occupancy · arrears Config — rates · reminder rules single source of truth — read + written by n8n and KosPanel KosPanel owner dashboard occupancy · revenue · arrears CRUD on Sheets via API static · Cloudflare / Vercel LEGEND frontend workflow engine self-hosted infra AI / external API data store external internal n8n flow VPS boundary

Automation (n8n)

  • • Lead capture & qualification over WhatsApp
  • • Monthly billing + automatic reminders
  • • Payment recording and cash-flow tracking
  • • Weekly owner summary, generated

Infrastructure

  • • Self-managed Linux VPS
  • • Docker Compose: WAHA + n8n
  • • Private network, scheduled backups
  • • Secrets in env files, never in git

KosPanel

  • • Owner view: occupancy, revenue, arrears
  • • Reads/writes Google Sheets via API
  • • Static deploy, no server to maintain
  • • Tenant-facing status pages