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]
Get 50 AI Prompts for Real Estate Agents, free
Subscribe to the Daily 5 and download the 48-page PDF right away. The prompts help with:
- Getting more leads from the contacts already in your CRM
- Faster follow-up, so no text or inquiry goes unanswered
- Less time on listing descriptions, paperwork, and showing instructions
- Copy-paste prompts tested by working agents, brokers, and landlords
- Five new real-world AI use cases every weekday morning in the Daily 5
Confirm by email. Unsubscribe in one click. Review every AI draft for accuracy and fair housing compliance before you send it.