Templates / Generate move-out deposit statements with gpt-5.6-terra, Gmail, and Google Sheets

Generate move-out deposit statements with gpt-5.6-terra, Gmail, and Google Sheets

Ready for 3.0

by Khairul Muhtadin ✓ · 0 views · created 2026-09-03 · Document Extraction, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 26 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model, Gmail and Telegram.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

  1. Normalize Move Out (Edit Fields (Set)): sets 11 fields: moveout_id, tenant_name, tenant_email…
  2. Read MoveOutLog for Sweep (Google Sheets): uses Google Sheets
  3. Validate Move Out Input (If): checks a condition and branches into true / false
  4. Compute Unprocessed Move Outs (Code): runs custom JavaScript code
  5. Append Pending Move Out (Google Sheets): append
  6. Build Invalid Move Out Alert (Edit Fields (Set)): sets 4 fields: tenant_name, tenant_email, unit…
  7. Has Unprocessed Move Outs (If): checks a condition and branches into true / false
  8. Build Disposition Prompt (Edit Fields (Set)): sets 9 fields: moveout_id, tenant_name, tenant_email…
  9. Alert Landlord Invalid Move Out (Telegram): uses Telegram
  10. Alert Landlord Unprocessed (Telegram): uses Telegram

…plus 13 more steps. See the full node list below.

Services it uses

Google SheetsOpenAI Chat ModelGmailTelegram

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (10)

From the author

Move-outs without the paperwork headache. This workflow takes inspection data via webhook, has AI separate chargeable damages from normal wear-and-tear, computes the deposit refund or amount owed, emails an itemized statement to the tenant, and keeps the…

Excerpt from Khairul Muhtadin's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.