See llms.txt for all machine-readable content.

Back to Templates

Monitor Porkbun domains from Google Sheets with Gmail and Discord alerts

Created by

Created by: Khairul Muhtadin || khmuhtadin
Khairul Muhtadin

Last update

Last update 11 days ago

Categories

Share

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 9: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:
  3. TenantLedger with the columns tenant_name, unit, rent_amount, email, due_day, status, and reminder_stage.
  4. ReminderLog with the columns reminder_date, tenant_name, unit, rent_amount, days_overdue, stage, and email_sent.
  5. Update both Google Sheets nodes with your spreadsheet ID.
  6. Replace the placeholder Telegram chat IDs with the landlord’s actual chat ID, and configure the recipient address in the weekly Gmail node.
  7. 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.

Additional info

contact me: https://khmuhtadin.com/contact/