Automation library · Chat assistants

Manage rent, maintenance and tenant messages with OpenAI

Started by an incoming Telegram message, and works across Google Sheets, Slack and Telegram. It hands the judgement calls to OpenAI. 34 steps, 3 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
34 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 3Model 2Logic 8Service 21

The steps in the order they run, from what starts it.

  1. 1Daily Rent Check TriggerSchedule triggerStarts it
  2. 2Tenant Message ReceivedTelegram triggerStarts it
  3. 3On Workflow ErrorError triggerStarts it
  4. 4Get All TenantsGoogle SheetsService
  5. 5Get All Tenants For LookupGoogle SheetsService
  6. 6Slack – Post Workflow Error AlertSlackService
  7. 7Calculate Rent StatusCodeLogic
  8. 8Find Tenant By ChatIdCodeLogic
  9. 9Route By Rent StatusSwitchLogic
  10. 10Classify Tenant MessageOpen AiModel
  11. 11Send Rent Due ReminderTelegramService
  12. 12Send Upcoming Rent ReminderTelegramService
  13. 13Notify Tenant OverdueTelegramService
  14. 14Parse AI ClassificationCodeLogic
  15. 15Update Reminder Sent - Due TodayGoogle SheetsService
  16. 16Update Reminder Sent - Due SoonGoogle SheetsService
  17. 17Escalate Overdue To Owner (Telegram)TelegramService
  18. 18Escalate Overdue To Owner (Slack)SlackService
  19. 19Route By IntentSwitchLogic
  20. 20Update Rent Status - OverdueGoogle SheetsService
  21. 21Log Maintenance RequestGoogle SheetsService
  22. 22Update Payment Status PaidGoogle SheetsService
  23. 23Send General Auto ReplyTelegramService
  24. 24Get All VendorsGoogle SheetsService
  25. 25Generate Receipt MessageOpen AiModel
  26. 26Pick Vendor By CategoryCodeLogic
  27. 27Format Receipt TextCodeLogic
  28. 28Notify Assigned VendorTelegramService
  29. 29Send Receipt To TenantTelegramService
  30. 30Is Urgent RepairIfLogic
  31. 31Log Payment RecordGoogle SheetsService
  32. 32Confirm Receipt To TenantTelegramService
  33. 33Escalate Urgent Repair To Owner (Telegram)TelegramService
  34. 34Escalate Urgent Repair To Owner (Slack)SlackService

How it's built

Starts on
An incoming Telegram message
Steps
34, with 3 branches
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets, Slack, Telegram
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Sheets, Slack and Telegram accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an incoming Telegram message.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 34 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 34 steps before you point it at anything that matters.