Kingfisher: rent and room tracker

What was wasting time

Kingfisher rents homes in Dubai and lets rooms to tenants. The team needed to track rent, empty rooms, costs, and profit. They wanted to keep using Google Sheets.

What changed

I built a main sheet and a page that reads from it. Staff edit the sheet. The page shows rent, rooms, tenants, and costs. It has a shared passcode. I also wrote the plan for a WhatsApp AI setup. The daily email was a draft.

Result

The team can view rent and room figures from the sheet. They also have a plan for checking WhatsApp leads and passing them to a person. We have not confirmed that the WhatsApp AI system is live.

How it works

1. Add room, tenant, rent, and cost data.
2. Work out profit from rent received less costs.
3. Share selected data with the web page.
4. Show rent due, empty rooms, and profit.
5. Prepare WhatsApp details, replies, and a draft daily email.

Tools, explained

• Google Sheets holds the records that staff can edit.
• Vite was used to build this tool.
• React helps build web pages with buttons and other controls.
• Vercel puts web apps online.
• Apps Script is code that runs tasks in Google apps.
• HyperFrames was used to build this tool.

How we can help

Key facts