🔬 Automate tenant rent collection with AI reminders and landlord escalation via Sheets, Gmail and Telegram

⚡ 6 views · 🔬 Document Extraction & Analysis

Description

Rent collection without the awkward calls. This workflow watches your tenant ledger every morning, has AI write reminder emails that progress from gentle to firm to final, escalates serious cases to you on Telegram, and sends a weekly collection report. No tenant chased by hand.

Last updated: September 2026.

Quick overview

Automate rent follow-ups with AI-generated tenant reminders, overdue-payment escalation, activity logging, and weekly collection reports using n8n, Google Sheets, Gmail, OpenAI, and Telegram.

How it works

1. The workflow runs through two scheduled processes.
2. Every day at 8:00 AM, it reads tenant records from Google Sheets and validates required fields such as tenant name, email, rent amount, and due day.
3. Unpaid tenants whose rent is due receive a personalized reminder generated by OpenAI.
4. The tone automatically progresses from gentle to firm and final based on how many days the payment is overdue.
5. Valid reminders are sent through Gmail and recorded in a separate Google Sheets log. Firm or final reminders also trigger a Telegram alert to the landlord.
6. If tenant data is incomplete or the AI returns an invalid response, the workflow sends an error notification instead.
7. Every Monday at 09:00 AM, a second process aggregates the ledger data, generates a concise weekly collection report, and delivers it through Gmail and Telegram.

Setup

1. Import the workflow into n8n, then connect your Google Sheets, Gmail, Telegram, and OpenAI credentials.
2. Create a Google spreadsheet containing two worksheets:
   • TenantLedger with the columns tenant_name, unit, rent_amount, email, due_day, status, and reminder_stage.
   • ReminderLog with the columns reminder_date, tenant_name, unit, rent_amount, days_overdue, stage, and email_sent.
3. Update both Google Sheets nodes with your spreadsheet ID.
4. Replace the placeholder Telegram chat IDs with the landlord’s actual chat ID, and configure the recipient address in the weekly Gmail node.
5. Finally, check the n8n instance timezone and adjust the daily and weekly schedules before activating the workflow.

Requirements

• An active n8n instance
• Google account with access to Google Sheets and Gmail
• OpenAI API account and available API credits
• Telegram bot and landlord chat ID
• Structured tenant ledger using the required column names

Customization

• You can modify the reminder stages, overdue thresholds, email tone, AI prompts, and escalation rules to match your rental policy. The default stages are gentle for 0–4 days overdue, firm for 5–9 days, and final for 10 or more days.
• You can also change the workflow schedules, weekly report recipient, Telegram notification text, spreadsheet structure, email templates, and reporting metrics. Additional delivery channels such as Slack, WhatsApp, or SMS can be added if required.

Quick Answers

How do reminder tones work?
Gentle for 0-4 days overdue, firm for 5-9 days, final for 10 or more days. Firm and final stages also alert the landlord on Telegram.
Which sheets are involved?
TenantLedger for tenants and ReminderLog for every reminder sent.
When is the report sent?
Every Monday at 09:00 AM, covering the week’s collection activity.

Additional info

Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/

🔗 Nodes Used

Google Sheets, Telegram, Gmail, Schedule Trigger, AI Agent, OpenAI Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup