What was wasting time
Kingfisher Holiday Homes needed one place to track tenants, rent collection, pending balances, empty rooms, unit costs, profit, and WhatsApp lead handling. The team still needed Google Sheets as the editing layer because that was the easiest place for operators to keep the data current.
What changed
I built a Google Sheets master workbook, a read-only Vercel dashboard, and a WhatsApp Business AI setup path. The sheet tracks units, rooms, tenants, rent ledger rows, costs, profitability, vacancy, and charts. The dashboard reads published CSV views, sits behind a shared passcode, and gives operators clean views for rent, vacancy, profit, and tenant follow-up. The WhatsApp work covered lead qualification fields, CRM sync logic, webhook validation, labels, quick replies, and the post-approval handoff path for Zaid.
Result
Kingfisher got a Sheet-backed operating dashboard plus the WhatsApp Business AI groundwork for inbound lead qualification and follow-up.
How it works
- Track units, rooms, tenants, rent, discounts, costs, and vacancy in Google Sheets.
- Calculate profit from collected rent minus allocated unit costs.
- Publish safe CSV views for the dashboard.
- Show overview, rent collection, unit profitability, vacancy, and tenant views.
- Add WhatsApp Business AI requirements, CRM sync fields, quick replies, an intake template, and a draft daily snapshot email.
Tools, explained
- Google Sheets is a spreadsheet the team already knows how to update.
- A technical part of the build that supported the business outcome.
- React is a frontend library used to build interactive screens.
- Vercel is a hosting platform used to put web apps online.
- Apps Script is small code inside Google Sheets that checks fields and starts the right next step.
- A technical part of the build that supported the business outcome.