{"product_id":"rent-tenant-support-n8n-workflow-openai-telegram-sheets","title":"Rent \u0026 Tenant Support n8n Workflow: OpenAI, Telegram, Sheets","description":"\u003ch3\u003eAutomate rent reminders and tenant support—with OpenAI, Telegram, and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eRent \u0026amp; Tenant Support n8n Workflow\u003c\/strong\u003e keeps your rental operations on track by automatically sending \u003cstrong\u003eTelegram rent reminders\u003c\/strong\u003e, escalating \u003cstrong\u003eoverdue rent\u003c\/strong\u003e to both tenant and owner, and handling \u003cstrong\u003etenant support messages\u003c\/strong\u003e (maintenance and payment) using \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e to read all tenants from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and calculate each tenant’s rent status (due today, due soon, overdue, or paid\/OK).\u003c\/li\u003e\n  \u003cli\u003eSends \u003cstrong\u003eTelegram reminders\u003c\/strong\u003e to tenants whose rent is due \u003cstrong\u003etoday\u003c\/strong\u003e or within the \u003cstrong\u003enext three days\u003c\/strong\u003e, and updates the tenant row with the \u003cstrong\u003elast reminder timestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor \u003cstrong\u003eoverdue rent\u003c\/strong\u003e, sends an overdue \u003cstrong\u003eTelegram notice\u003c\/strong\u003e, escalates the situation to the \u003cstrong\u003eproperty owner\u003c\/strong\u003e via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e, and updates the tenant status in Google Sheets to \u003cstrong\u003e“Overdue”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eListens for \u003cstrong\u003eincoming Telegram messages\u003c\/strong\u003e, looks up the tenant by \u003cstrong\u003eTelegram chat ID\u003c\/strong\u003e in Google Sheets, and uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to classify the message (maintenance, payment, or general), including category and urgency.\u003c\/li\u003e\n  \u003cli\u003eFor \u003cstrong\u003emaintenance requests\u003c\/strong\u003e: logs a ticket to the \u003cstrong\u003eMaintenance\u003c\/strong\u003e tab, selects a vendor from the \u003cstrong\u003eVendors\u003c\/strong\u003e tab by category, notifies the vendor via \u003cstrong\u003eTelegram\u003c\/strong\u003e, and confirms the ticket to the tenant.\u003c\/li\u003e\n  \u003cli\u003eIf maintenance is marked \u003cstrong\u003ehigh urgency\u003c\/strong\u003e, escalates the repair to the \u003cstrong\u003eproperty owner\u003c\/strong\u003e via \u003cstrong\u003eTelegram\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor \u003cstrong\u003epayment confirmations\u003c\/strong\u003e, updates the tenant status to \u003cstrong\u003e“Paid”\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily, automated rent chasing for multiple tenants without manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eCentralized tenant messaging where OpenAI categorizes requests and routes them to maintenance or payment workflows.\u003c\/li\u003e\n  \u003cli\u003eOwner visibility for overdue rent and high-urgency repairs through Telegram + Slack alerts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, switch, open ai, telegram, slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSystem of record:\u003c\/strong\u003e Google Sheets (Tenant lookup, Maintenance logging, Vendors selection)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI component:\u003c\/strong\u003e OpenAI intent classification using \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging\/escalation:\u003c\/strong\u003e Telegram to tenants and vendors; Slack + Telegram to owners\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812007764147,"sku":"N8N-17971","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HhBNO_64b18de0tPPY5mo_2LpdUCOA.png?v=1786352793","url":"https:\/\/buyflowscripts.com\/products\/rent-tenant-support-n8n-workflow-openai-telegram-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}