{"product_id":"n8n-rent-reconciliation-workflow-google-sheets-gmail-twilio","title":"n8n Rent Reconciliation Workflow: Google Sheets, Gmail \u0026 Twilio","description":"\u003ch3\u003eAutomatically reconcile rent, match payments, and chase arrears—hourly—using Google Sheets, Gmail, and Twilio (with OpenAI-powered reply classification)\u003c\/h3\u003e\n\u003cp\u003eThis n8n Rent Reconciliation Workflow rebuilds your rent ledger from \u003cstrong\u003eGoogle Sheets leases\u003c\/strong\u003e, matches incoming \u003cstrong\u003ebank statement lines\u003c\/strong\u003e to tenants, and automatically sends \u003cstrong\u003eSMS reminders (Twilio)\u003c\/strong\u003e and \u003cstrong\u003eemail chases (Gmail)\u003c\/strong\u003e for arrears. When tenants or managers reply, it uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract intent and evidence, then pauses, escalates, or routes cases for review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns hourly\u003c\/strong\u003e on a schedule and also triggers instantly when an \u003cstrong\u003einbound Twilio SMS\u003c\/strong\u003e or \u003cstrong\u003eGmail inbox email\u003c\/strong\u003e arrives.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads data from Google Sheets\u003c\/strong\u003e (tabs: \u003cem\u003eLeases\u003c\/em\u003e, \u003cem\u003eOwners\u003c\/em\u003e, \u003cem\u003eIndex\u003c\/em\u003e, \u003cem\u003eBank\u003c\/em\u003e, \u003cem\u003eLog\u003c\/em\u003e) to reconstruct the current rent ledger and previous actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates rent due\u003c\/strong\u003e, including proration and optional late fees, then matches bank statement credits\/returns to specific leases.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDecides what actions are due\u003c\/strong\u003e (charges, reminders, escalations, rent reviews, digests, and owner statements) based on the ledger state.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends outcomes to the Log tab\u003c\/strong\u003e as new rows for traceability (charges, matched payments, reminders, holds, reviews, and alerts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends outbound communications\u003c\/strong\u003e via \u003cstrong\u003eTwilio\u003c\/strong\u003e or \u003cstrong\u003eGmail\u003c\/strong\u003e according to each log entry’s target channel and recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses replies\u003c\/strong\u003e: normalizes inbound messages, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract intent\/evidence, updates the log with holds\/promises\/opt-outs or approvals, and acknowledges or forwards items to the manager via email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFault handling\u003c\/strong\u003e: if the workflow errors, it sends an alert email via \u003cstrong\u003eGmail\u003c\/strong\u003e with execution details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHourly rent reconciliation from Google Sheets leases and bank statement data.\u003c\/li\u003e\n  \u003cli\u003eAutomated SMS\/email arrears chasing with escalation to a manager when replies require review.\u003c\/li\u003e\n  \u003cli\u003eRent review approvals and evidence capture from tenant or manager responses.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e set, code, gmail, switch, twilio, aggregate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (tabs: Leases, Owners, Index, Bank, Log) with Google Sheets credentials.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI component:\u003c\/strong\u003e OpenAI used to classify tenant replies and determine whether to pause, escalate, or route for review.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46159503950003,"sku":"N8N-20381","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4mVnRQid1e1Gi7n6u5lVN_NbI8Lse8.png?v=1791104935","url":"https:\/\/buyflowscripts.com\/products\/n8n-rent-reconciliation-workflow-google-sheets-gmail-twilio","provider":"N8N Commerce","version":"1.0","type":"link"}