AI Home Inspection Defect Scoring & Repair Letters (n8n)

Turn Home Inspection Text into Defect Scores + Repair Letters—Automatically

This n8n workflow ingests a finalized home inspection report via webhook, uses OpenAI to extract and score defects, drafts the appropriate repair negotiation letter, routes it for inspector approval in Gmail, then saves and emails the approved packet through Google Drive—all with outcomes logged in an n8n Data Table.

What this workflow does

• Receives inspection reports by POSTing a payload to the workflow webhook (property address + inspection report text).
• Extracts defects with OpenAI (gpt-4o-mini) to produce a structured list of defects, including categories and estimated costs.
• Calculates severity + repair totals by computing a weighted severity score and total estimated repair cost.
• Classifies the report tier as either major or standard based on a score threshold.
• Drafts the correct negotiation/repair letter using OpenAI:
  • Major tier: a firm, code-focused negotiation letter.
  • Standard tier: a more collaborative repair request letter.
• Routes for approval via Gmail using a send-and-wait approval step to the lead inspector (approve/reject).
• Saves and emails results if approved: stores the letter as a text file in Google Drive, emails it (with the Drive link) to the client and listing agent.
• Handles rejection by emailing the inspector that manual revision is needed.
• Logs outcomes (tier, severity score, approval outcome, timestamp, and Drive link when available) to an n8n Data Table.

Use cases

• Generate consistent home inspection defect scoring and negotiation letters immediately after inspections are finalized.
• Speed up your repair request workflow with inspector approval managed through Gmail.
• Maintain an auditable history of severity scoring and approvals using an n8n Data Table.

Technical details

• Trigger: Webhook (POST)
• Automation logic: if, set, code, merge
• Messaging + approval: Gmail (send-and-wait approval step)
• File storage: Google Drive (text file save + Drive link sharing)
• AI processing: OpenAI (gpt-4o-mini) for defect extraction and letter drafting
• Data logging: n8n Data Table