{"product_id":"move-out-deposit-statement-automation-with-n8n-gmail-gpt-4","title":"Move-Out Deposit Statement Automation with n8n, Gmail \u0026 GPT-4","description":"\u003ch3\u003eAutomatically generate move-out deposit statements—from inspection data to emailed itemization\u003c\/h3\u003e\n\u003cp\u003eIf you manage residential rentals, this \u003cstrong\u003eMove-Out Deposit Statement Automation\u003c\/strong\u003e for \u003cstrong\u003en8n\u003c\/strong\u003e turns move-out inspection details into a calculated, itemized security deposit disposition. It logs records in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eGPT-4\u003c\/strong\u003e to classify damages, emails tenants via \u003cstrong\u003eGmail\u003c\/strong\u003e, and keeps landlords updated with \u003cstrong\u003eTelegram\u003c\/strong\u003e reminders.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts move-out details via webhook:\u003c\/strong\u003e receives a POST request containing tenant\/unit info, deposit\/unpaid balances, and a damages list.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes the intake:\u003c\/strong\u003e required fields are checked; invalid submissions trigger \u003cstrong\u003eTelegram\u003c\/strong\u003e alerts and an email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e appends the move-out as pending in the \u003cstrong\u003eMoveOutLog\u003c\/strong\u003e tab for review and tracking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies damage with OpenAI (GPT-4):\u003c\/strong\u003e each damage item is classified as \u003cem\u003echargeable\u003c\/em\u003e or \u003cem\u003ewear-and-tear\u003c\/em\u003e, with estimated costs returned as parsed JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates deductions and outcomes:\u003c\/strong\u003e totals deductions, applies unpaid rent\/utilities, and produces an itemized statement showing the \u003cstrong\u003enet refund\u003c\/strong\u003e or \u003cstrong\u003eamount owed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails and updates records:\u003c\/strong\u003e sends the statement to the tenant using \u003cstrong\u003eGmail\u003c\/strong\u003e, then updates the matching row in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the landlord:\u003c\/strong\u003e sends a \u003cstrong\u003eTelegram\u003c\/strong\u003e message; if the tenant owes money, a copy is also sent by Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily pending reminders:\u003c\/strong\u003e scheduled runs scan Google Sheets for pending move-outs older than 3+ days and send Telegram\/Gmail reminders, or an all-clear.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStreamlining security deposit disputes by turning inspection notes into consistent, itemized statements.\u003c\/li\u003e\n  \u003cli\u003eReducing manual bookkeeping: automated deduction calculations and spreadsheet updates for each move-out.\u003c\/li\u003e\n  \u003cli\u003eKeeping landlords on track with automated daily “pending” follow-ups until statements are sent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, set, code, webhook, gmail, telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (MoveOutLog tab), OpenAI (Chat\/GPT-4), Gmail, Telegram\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore flow:\u003c\/strong\u003e webhook intake → Sheets logging → GPT-4 classification → refund\/owed calculation → Gmail statement → Sheets update → Telegram notifications → daily pending scheduler\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950260478131,"sku":"N8N-19124","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Mpo6kqavAQfMDjXaaloeO_4ih3nAb4.png?v=1788514246","url":"https:\/\/buyflowscripts.com\/products\/move-out-deposit-statement-automation-with-n8n-gmail-gpt-4","provider":"N8N Commerce","version":"1.0","type":"link"}