Manage rent, maintenance and tenant messages with OpenAI, Telegram and Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 34 nodes and runs on a schedule (every day) (plus 2 other triggers). Along the way it connects Google Sheets, Telegram and Slack.
How it runs
Trigger: On a schedule (every day) (plus 2 other triggers).
- Get All Tenants (Google Sheets): uses Google Sheets
- Get All Tenants For Lookup (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Calculate Rent Status (Code): runs custom JavaScript code
- Find Tenant By ChatId (Code): runs custom JavaScript code
- Route By Rent Status (Switch): routes items into branches
- Classify Tenant Message (OpenAI): uses OpenAI
- Send Rent Due Reminder (Telegram): uses Telegram
- Send Upcoming Rent Reminder (Telegram): uses Telegram
- Notify Tenant Overdue (Telegram): uses Telegram
…plus 21 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Generate Receipt Message, Classify Tenant Message: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Generate Receipt Message, Classify Tenant Message | OpenAI node (AI section) |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Telegram
n8n-nodes-base.telegram - Slack
n8n-nodes-base.slack - If
n8n-nodes-base.if - Telegram Trigger
n8n-nodes-base.telegramTrigger - OpenAI
n8n-nodes-base.openAi - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick Overview This workflow automates rent reminders and tenant support by combining Google Sheets as the system of record with Telegram messaging, OpenAI (gpt-4o-mini) intent classification and receipt writing, and Slack/Telegram owner alerts for overdue…