{"product_id":"ai-rent-reminder-workflow-google-sheets-gmail-telegram-n8n","title":"AI Rent Reminder Workflow: Google Sheets, Gmail \u0026 Telegram (n8n)","description":"\u003ch3\u003eAutomate rent reminders with AI—straight from Google Sheets to Gmail and Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reads your tenant rent ledger in \u003cb\u003eGoogle Sheets\u003c\/b\u003e, uses \u003cb\u003eOpenAI (gpt-4o-mini)\u003c\/b\u003e to draft overdue rent reminder emails, sends them via \u003cb\u003eGmail\u003c\/b\u003e, and escalates firm\/final reminders to \u003cb\u003eTelegram\u003c\/b\u003e. It also generates a weekly AI-written collections summary and delivers it to you through Gmail and Telegram.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eDaily check (08:00, Asia\/Jakarta):\u003c\/b\u003e Loads tenant rows from the \u003cb\u003eTenantLedger\u003c\/b\u003e tab and validates required fields: tenant name, email, due day, and rent amount. Missing data triggers a \u003cb\u003eTelegram alert\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOverdue calculation:\u003c\/b\u003e Normalizes tenant data, calculates the current month due date, and computes how many days rent is overdue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAI-generated reminders:\u003c\/b\u003e For tenants who are unpaid and due today or overdue, the workflow uses OpenAI to generate a short reminder email in \u003cb\u003eJSON format\u003c\/b\u003e (gentle\/firm\/final).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDelivery + logging:\u003c\/b\u003e Sends the drafted reminder via \u003cb\u003eGmail\u003c\/b\u003e, appends a reminder record to the \u003cb\u003eReminderLog\u003c\/b\u003e tab in Google Sheets, and notifies the landlord in \u003cb\u003eTelegram\u003c\/b\u003e when the stage is \u003cb\u003efirm\u003c\/b\u003e or \u003cb\u003efinal\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWeekly summary (Monday 09:00):\u003c\/b\u003e Summarizes the ledger in Google Sheets, uses OpenAI to write a weekly rent report, and sends it by \u003cb\u003eGmail\u003c\/b\u003e and \u003cb\u003eTelegram\u003c\/b\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 automated \u003cb\u003erent overdue reminders\u003c\/b\u003e without manually drafting emails.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or landlords managing multiple units using a \u003cb\u003eGoogle Sheets rent ledger\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams that need a clear escalation path (gentle → firm\/final) with \u003cb\u003eTelegram notifications\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations\/Nodes:\u003c\/b\u003e \u003ci\u003eGoogle Sheets\u003c\/i\u003e, \u003ci\u003eGmail\u003c\/i\u003e, \u003ci\u003eTelegram\u003c\/i\u003e, \u003ci\u003eOpenAI\u003c\/i\u003e (gpt-4o-mini), plus workflow logic nodes such as \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003esummarize\u003c\/b\u003e, and \u003cb\u003esticky note\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCredentials:\u003c\/b\u003e OAuth2 for Google Sheets and Gmail; add an OpenAI API credential for the two OpenAI steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eConfig:\u003c\/b\u003e Set spreadsheet ID and sheet names (\u003cb\u003eTenantLedger\u003c\/b\u003e, \u003cb\u003eReminderLog\u003c\/b\u003e) to match your ledger.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830406734003,"sku":"N8N-18232","price":65.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Os5cBjHB2c0X71qbxmbmv_wOb1bmdn.png?v=1786698493","url":"https:\/\/buyflowscripts.com\/products\/ai-rent-reminder-workflow-google-sheets-gmail-telegram-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}