{"product_id":"ai-rent-reminder-n8n-workflow-google-sheets-gmail-telegram","title":"AI Rent Reminder n8n Workflow: Google Sheets + Gmail + Telegram","description":"\u003ch3\u003eAutomate Rent Reminders with AI—Google Sheets + Gmail + Telegram\u003c\/h3\u003e\n\u003cp\u003eStop chasing late payments manually. This \u003cstrong\u003eAI Rent Reminder n8n workflow\u003c\/strong\u003e reads your tenants from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a tailored reminder email with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e, and alerts you in \u003cstrong\u003eTelegram\u003c\/strong\u003e—including a weekly collections summary delivered the same way.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eMorning run (scheduled daily):\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eRuns every morning and reads tenant records from the \u003cstrong\u003eTenantLedger\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eValidates required fields: \u003cstrong\u003etenant name\u003c\/strong\u003e, \u003cstrong\u003eemail\u003c\/strong\u003e, \u003cstrong\u003edue day\u003c\/strong\u003e, and \u003cstrong\u003erent amount\u003c\/strong\u003e. If any row is missing data, it sends a \u003cstrong\u003eTelegram alert\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalculates each tenant’s due date and \u003cstrong\u003edays overdue\u003c\/strong\u003e, then selects tenants whose rent is due\/overdue and \u003cstrong\u003enot marked as paid\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a short rent reminder email with a tone based on how many days overdue they are (e.g., \u003cstrong\u003egentle\u003c\/strong\u003e, \u003cstrong\u003efirm\u003c\/strong\u003e, or \u003cstrong\u003efinal\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eSends the reminder via \u003cstrong\u003eGmail\u003c\/strong\u003e, appends an entry to the \u003cstrong\u003eReminderLog\u003c\/strong\u003e tab in Google Sheets, and notifies the landlord in \u003cstrong\u003eTelegram\u003c\/strong\u003e when the stage is \u003cstrong\u003efirm\u003c\/strong\u003e or \u003cstrong\u003efinal\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eWeekly run (Monday):\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eSummarizes your ledger with \u003cstrong\u003eOpenAI\u003c\/strong\u003e into a \u003cstrong\u003eweekly rent report\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eEmails the report via \u003cstrong\u003eGmail\u003c\/strong\u003e and posts the same summary to \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProperty managers who want consistent, timely \u003cstrong\u003erent due reminders\u003c\/strong\u003e without manual outreach.\u003c\/li\u003e\n  \u003cli\u003eSmall landlords using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e as a tenant ledger and needing automated \u003cstrong\u003ecollections updates\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and automation engineers deploying AI-assisted notification flows with \u003cstrong\u003en8n\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads \u003cem\u003eTenantLedger\u003c\/em\u003e, writes to \u003cem\u003eReminderLog\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: sends AI-generated rent reminder emails and the weekly report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e: alerts on missing data and notifies on firm\/final reminders; delivers weekly summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: generates reminder email text and the weekly collections summary (model confirmed as \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003en8n nodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003esummarize\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830411813043,"sku":"N8N-18229","price":7.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Feq4fbMAiM5peiVZ8Amxh_kxrOYFtg.png?v=1786698561","url":"https:\/\/buyflowscripts.com\/products\/ai-rent-reminder-n8n-workflow-google-sheets-gmail-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}