{
  "name": "Automate property inspections and reporting with OpenAI, Google Sheets and Slack",
  "nodes": [
    {
      "id": "94cf7180-1e81-4a37-aa3e-d6bf590fc94a",
      "name": "Schedule Inspections",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        416
      ]
    },
    {
      "id": "8db1a3da-5617-42a0-b622-e3f0e07ed4ff",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        416
      ]
    },
    {
      "id": "ded30ecc-be74-4f6b-9cc3-b5e85260cdb5",
      "name": "Fetch Property & Tenant Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        448,
        416
      ]
    },
    {
      "id": "017bb844-3b0a-43f5-bc15-fd6ab17a4bbc",
      "name": "Normalize Property Data",
      "type": "n8n-nodes-base.set",
      "position": [
        672,
        416
      ]
    },
    {
      "id": "c7f331f7-a2be-47dd-8ada-cb74873197c8",
      "name": "Generate Inspection Checklist",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        880,
        496
      ]
    },
    {
      "id": "a243f942-d059-43df-96ec-7a33488ce9ad",
      "name": "Send Checklist to Inspector",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1248,
        416
      ]
    },
    {
      "id": "60fab16e-d319-4fff-b2de-a84312708ff3",
      "name": "Receive Inspection Submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        0,
        96
      ]
    },
    {
      "id": "bad85ea6-a5aa-41e7-8e6d-7da7057bac50",
      "name": "Store Raw Inspection Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        96
      ]
    },
    {
      "id": "ef849102-8cd3-4163-837a-f21e1de9c825",
      "name": "Analyze Inspection & Flag Issues",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        448,
        128
      ]
    },
    {
      "id": "f7880b41-bedc-4139-b8b1-caaf6aeea4ad",
      "name": "Route by Priority",
      "type": "n8n-nodes-base.switch",
      "position": [
        800,
        80
      ]
    },
    {
      "id": "dc91f303-6475-4216-8198-a557438ca826",
      "name": "Notify Manager (High Priority)",
      "type": "n8n-nodes-base.slack",
      "position": [
        1024,
        0
      ]
    },
    {
      "id": "0c800a36-25b7-41a5-ab67-49f0c15076e4",
      "name": "Email Manager (Medium Priority)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1024,
        192
      ]
    },
    {
      "id": "a2363619-759a-4077-939d-53d4b292e0ce",
      "name": "Log Inspection Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1248,
        96
      ]
    },
    {
      "id": "fd126f1b-f393-4f27-bdec-3b5ad4e48cfa",
      "name": "Aggregate Weekly Inspections",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1472,
        96
      ]
    },
    {
      "id": "4d33675a-9b79-4a00-af5a-57677d33b6fa",
      "name": "Send Summary Report",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1696,
        96
      ]
    },
    {
      "id": "38f01006-ecf2-4c89-b745-99928b1cb339",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        32
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "6bd80071-511e-4322-b5c6-72d57f246702",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        32
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9faf4b4c-f29c-45fc-b59f-672d9c53f85f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        416,
        16
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "d1f9aa0f-e215-45a5-a865-5db18e18a7ba",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        912,
        -144
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "71003242-b696-488d-bf19-a62ce83c704e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        -128
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "36955b7a-4de1-40f5-9a07-9d29fea1527a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        352
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "18d9341e-f3d3-4b42-b884-75f672adf946",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        352
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "e80a6a7d-aa09-4540-a7b4-3507391abc95",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        368
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Route by Priority": {
      "main": [
        [
          {
            "node": "Notify Manager (High Priority)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Email Manager (Medium Priority)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Inspections": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Inspection Results": {
      "main": [
        [
          {
            "node": "Aggregate Weekly Inspections",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Fetch Property & Tenant Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Property Data": {
      "main": [
        [
          {
            "node": "Generate Inspection Checklist",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Raw Inspection Data": {
      "main": [
        [
          {
            "node": "Analyze Inspection & Flag Issues",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Weekly Inspections": {
      "main": [
        [
          {
            "node": "Send Summary Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Property & Tenant Data": {
      "main": [
        [
          {
            "node": "Normalize Property Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Inspection Checklist": {
      "main": [
        [
          {
            "node": "Send Checklist to Inspector",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Receive Inspection Submission": {
      "main": [
        [
          {
            "node": "Store Raw Inspection Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify Manager (High Priority)": {
      "main": [
        [
          {
            "node": "Log Inspection Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Manager (Medium Priority)": {
      "main": [
        [
          {
            "node": "Log Inspection Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze Inspection & Flag Issues": {
      "main": [
        [
          {
            "node": "Route by Priority",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}