What the agent did
Ko Andi runs a kos-kosan (boarding house) on his own. His agent reads guest check-in reports from a Telegram group, enters them into Google Sheets, matches them against bank transfers and builds the report. The source is a blog post in Indonesian from KomuniTech, the community that sells the course and membership he joined.
Result, as claimed
Time and effort for this workflow dropped 60-70%, a figure the source attributes to Ko Andi himself.
This is the result as the person described it in public. It has not been checked and is not a typical outcome.
Proof
Try it yourself
An agent that turns check-in messages from a chat group into a spreadsheet, matches payments and builds the monthly report.
Prompt
Read new messages in our [Telegram group] where staff report guest check-ins and check-outs. For each, add a row to [Google Sheet] with date, room, guest name, in or out, and amount due. Once a day, compare amounts due with this bank statement export [CSV] and mark each row Paid, Partly paid or Not found. At the end of the month, build a report with occupancy, income received and unpaid rooms. Ask me about any message you cannot read clearly.Tools
- n8n One option for this kind of workflow
- Telegram Bot API Free bot API
- Google Sheets Free
- OpenClaw Free, open-source agent you run yourself
Steps
- Agree a simple message format with staff, such as room, name, in or out.
- Connect the chat group and sheet to your agent or workflow tool.
- Run it alongside your manual records for one month.
- Switch to the automatic report once the numbers match.
Watch out: Guest names and bank data are private, so limit who can see the sheet and check the reconciliation before you rely on it.
Starter version by Solopreneur Code