{
  "name": "Analyze real estate investment potential: Zillow properties to Google Sheets with GPT-4o",
  "nodes": [
    {
      "id": "214c6129-834c-46a1-9a58-0e3bad219bc1",
      "name": "Start Zillow Scraper",
      "type": "@apify/n8n-nodes-apify.apifyTrigger",
      "position": [
        144,
        192
      ]
    },
    {
      "id": "8c9824bb-7699-4304-8e02-333a867b9fb8",
      "name": "Clean & Format Data",
      "type": "n8n-nodes-base.set",
      "position": [
        672,
        192
      ]
    },
    {
      "id": "f9b3948c-d50e-4091-aea5-cc028fc822bb",
      "name": "Process Each Property",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1424,
        -32
      ]
    },
    {
      "id": "95c2f8d0-93f9-4c64-9070-738d43e54dea",
      "name": "AI Scoring: Investment Potential",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1712,
        384
      ]
    },
    {
      "id": "f49bab12-4ba0-49c3-95fc-beb1f2c4d578",
      "name": "Update Google Sheets Database",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1184,
        336
      ]
    },
    {
      "id": "df151b4d-ebbf-42b1-adec-06f0821c5598",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -48
      ],
      "parameters": {
        "width": 480,
        "height": 624,
        "content": "# 🟩 STEP 1: Zillow Data Extraction\n## This section starts the Apify Actor to scrape property listings from Zillow.\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## It retrieves essential details such as price, location, and pro"
      }
    },
    {
      "id": "22743f36-d1e9-4597-9890-be29448788ae",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        112
      ],
      "parameters": {
        "width": 544,
        "height": 464,
        "content": "# 🟦 STEP 2: AI Investment Scoring\n## n8n uses OpenAI to analyze each property’s details and assign an investment potential score (1–10).\n\n\n\n\n\n\n\n\n\n\n\n\n## This helps prioritize which listings are worth d"
      }
    },
    {
      "id": "8e29afbc-2ec8-4166-b024-31d7df25f1a7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        112
      ],
      "parameters": {
        "width": 576,
        "height": 464,
        "content": "# 🟨 STEP 3: Google Sheets Data Storage\n## The processed and scored results are automatically added to your Google Sheet database.\n\n\n\n\n\n\n\n\n\n\n\n\n## Each new run updates or appends data, keeping your prop"
      }
    },
    {
      "id": "0ca5dc6a-075f-46c9-94b5-16caab3dc3ad",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -656
      ],
      "parameters": {
        "width": 1920,
        "height": 592,
        "content": "# Zillow Property Scraper with AI Scoring to Google Sheets\n\n## This workflow automates real estate data collection and AI-based analysis using Apify, OpenAI, and Google Sheets.\n\nIt scrapes live proper"
      }
    },
    {
      "id": "e50095df-e436-4937-b3ce-f7a1b30d8c25",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -48
      ],
      "parameters": {
        "width": 1136,
        "height": 144,
        "content": "# Process Each Property"
      }
    },
    {
      "id": "a9827e50-75da-43af-ac15-44dc1e591d52",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        592,
        -48
      ],
      "parameters": {
        "width": 272,
        "height": 624,
        "content": "# Clean & Format Data"
      }
    },
    {
      "id": "1edbc36b-b65d-4989-a30e-37dba5d19814",
      "name": "Extract Individual Property Data",
      "type": "@apify/n8n-nodes-apify.apify",
      "position": [
        352,
        192
      ]
    }
  ],
  "connections": {
    "Clean & Format Data": {
      "main": [
        [
          {
            "node": "Process Each Property",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Zillow Scraper": {
      "main": [
        [
          {
            "node": "Extract Individual Property Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Each Property": {
      "main": [
        [],
        [
          {
            "node": "AI Scoring: Investment Potential",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Google Sheets Database": {
      "main": [
        [
          {
            "node": "Process Each Property",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Scoring: Investment Potential": {
      "main": [
        [
          {
            "node": "Update Google Sheets Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Individual Property Data": {
      "main": [
        [
          {
            "node": "Clean & Format Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}