Brokerage ops

Each morning unpaid tenants get an AI-written rent reminder that moves from gentle to firm to final as the days overdue add up, firm and final reminders ping you on Telegram, and every Monday you get a weekly collection report

An n8n template by Khairul Muhtadin reads a TenantLedger tab in Google Sheets every day at 8:00 AM and checks each row for tenant name, email, rent amount, and due day. For each unpaid tenant whose rent is due, an OpenAI model (gpt-4o-mini) drafts a reminder email and picks the stage from days overdue: gentle at 0 to 4 days, firm at 5 to 9 days, and final at 10 or more days, with a system instruction to stay polite and never threaten. Reminders go out through Gmail and are logged to a second sheet tab, and firm or final reminders also send the landlord a Telegram alert. Incomplete tenant rows or an invalid AI response trigger an error notice instead of an email. Every Monday at 9:00 AM a second run summarizes the ledger into a short report of paid and unpaid tenants and the most overdue tenant, sent by Gmail and Telegram.

At a glance

Tools used
n8nOpenAIGoogle SheetsGmailTelegram
Category
Brokerage ops
Audience
landlord, property manager
Difficulty
Builder
Source
Automate tenant rent collection with AI reminders and landlord escalation via Sheets, Gmail and Telegram
Khairul Muhtadin (n8n creator) · n8n template · Aug 12, 2026
First step
Build the TenantLedger tab with tenant_name, unit, rent_amount, email, due_day, status, and reminder_stage, add yourself as a test tenant marked unpaid, and read the gentle, firm, and final drafts before you connect any real tenant emails.

Compliance note: Have a person approve any final-stage reminder, and keep late fees, grace periods, and notice wording to what the lease and your state and local landlord-tenant law allow; a reminder email is not a legal notice to pay or quit.

Suggested prompt

Written by this directory, inspired by the source. Replace the [bracketed] parts.

You are a rent collection assistant for a small landlord. Draft a rent reminder email for this tenant. The rent was due on [due date] and is [days overdue] day(s) overdue. Choose the stage: gentle (0 to 4 days overdue), firm (5 to 9 days overdue), or final (10 or more days overdue). Gentle is a friendly nudge, firm is polite but clear that payment is expected soon, and final is a clear and urgent notice. Never threaten or use aggressive language, and do not mention late fees, eviction, or legal steps unless they appear in the lease terms below. Return JSON with stage, subject, and body. Tenant details: [tenant name, unit, rent amount, how to pay]. Lease terms on late payment: [paste]

Share on X Read the source

← All use cases