{"product_id":"ai-home-inspection-defect-scoring-repair-letters-n8n","title":"AI Home Inspection Defect Scoring \u0026 Repair Letters (n8n)","description":"\u003ch3\u003eTurn Home Inspection Text into Defect Scores + Repair Letters—Automatically\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inspection reports\u003c\/strong\u003e by POSTing a payload to the workflow webhook (property address + inspection report text).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts defects with OpenAI (gpt-4o-mini)\u003c\/strong\u003e to produce a structured list of defects, including categories and estimated costs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates severity + repair totals\u003c\/strong\u003e by computing a weighted severity score and total estimated repair cost.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies the report tier\u003c\/strong\u003e as either \u003cstrong\u003emajor\u003c\/strong\u003e or \u003cstrong\u003estandard\u003c\/strong\u003e based on a score threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDrafts the correct negotiation\/repair letter\u003c\/strong\u003e using OpenAI:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eMajor tier:\u003c\/strong\u003e a firm, code-focused negotiation letter.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eStandard tier:\u003c\/strong\u003e a more collaborative repair request letter.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes for approval via Gmail\u003c\/strong\u003e using a send-and-wait approval step to the lead inspector (approve\/reject).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves and emails results\u003c\/strong\u003e if approved: stores the letter as a text file in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, emails it (with the Drive link) to the \u003cstrong\u003eclient\u003c\/strong\u003e and \u003cstrong\u003elisting agent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles rejection\u003c\/strong\u003e by emailing the inspector that manual revision is needed.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs outcomes\u003c\/strong\u003e (tier, severity score, approval outcome, timestamp, and Drive link when available) to an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate consistent home inspection defect scoring and negotiation letters immediately after inspections are finalized.\u003c\/li\u003e\n  \u003cli\u003eSpeed up your repair request workflow with inspector approval managed through Gmail.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable history of severity scoring and approvals using an n8n Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Webhook (POST)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation logic:\u003c\/strong\u003e if, set, code, merge\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMessaging + approval:\u003c\/strong\u003e Gmail (send-and-wait approval step)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFile storage:\u003c\/strong\u003e Google Drive (text file save + Drive link sharing)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI processing:\u003c\/strong\u003e OpenAI (gpt-4o-mini) for defect extraction and letter drafting\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData logging:\u003c\/strong\u003e n8n Data Table\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45945696518323,"sku":"N8N-19101","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nvEsdjGT1zO1NTDuDvAbe_PDXLw9Oq.png?v=1788426362","url":"https:\/\/buyflowscripts.com\/products\/ai-home-inspection-defect-scoring-repair-letters-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}