AI-Powered Real Estate Market Radar & Pain Point Detector

{
  "id": "mxi77QamrosSQS1S",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae"
  },
  "name": "AI-Powered Real Estate Market Radar & Pain Point Detector",
  "tags": [],
  "nodes": [
    {
      "id": "bc0232b7-456e-4423-b05b-1a61483b16f9",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1020,
        440
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f755765f-46e7-44a9-8706-d9e0c2cf1e03",
      "name": "Apify Scraper",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1220,
        440
      ],
      "parameters": {
        "url": "=https://api.apify.com/v2/acts/apify~google-search-scraper/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "c6036651-2d22-4a2e-b5db-647699c87ba2",
      "name": "Extract Summary",
      "type": "n8n-nodes-base.code",
      "position": [
        1440,
        440
      ],
      "parameters": {
        "jsCode": "return [{ json: { summary: $json.organicResults.map((item, i) => `${i + 1}. ${item.title} — ${item.description}`).join('\\n\\n') } }];"
      },
      "typeVersion": 1
    },
    {
      "id": "1e769591-d570-4e7a-a99f-53ba33dc9e96",
      "name": "Extract Pain Points",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1660,
        440
      ],
      "parameters": {
        "text": "={{ $json.summary }}",
        "options": {
          "systemMessage": "You are an AI market researcher. Analyze the text and extract the top 3 pain points real estate agents face. Only include what’s directly or implicitly mentioned."
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0068d0b1-925b-481d-8b24-df27c1d57d65",
      "name": "Read Yesterday Pain Points",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1820,
        680
      ],
      "parameters": {
        "table": "YOUR_TABLE_ID",
        "application": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "airtableTokenApi"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "CLqWz0zZEI8Oc8z1",
          "name": "Temp"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "696aee0b-f40a-4f3a-ba74-a5356ddbcf43",
      "name": "Compare Pain Points",
      "type": "n8n-nodes-base.code",
      "position": [
        2100,
        440
      ],
      "parameters": {
        "jsCode": "const today = $json.output.split('\\n').map(p => p.trim());\nconst yesterday = $items('Read Yesterday Pain Points')[0].json.Summary.split('\\n').map(p => p.trim());\n\nconst newPoints = today.filter(p => !yesterday.includes(p));\nconst recurring = today.filter(p => yesterday.includes(p));\n\nreturn [{ json: { newPainPoints: newPoints, recurring } }];"
      },
      "typeVersion": 1
    },
    {
      "id": "bca26987-b59c-4c85-b0c2-8f0668d2ccbb",
      "name": "Telegram Notifier",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2320,
        440
      ],
      "webhookId": "ddbf26e0-fcd8-42a4-a374-0210fc85c796",
      "parameters": {
        "text": "📊 Real Estate Radar\nNew Pain Points:\n={{ $json.newPainPoints.join('\\n') }}\nRecurring:\n={{ $json.recurring.join('\\n') }}",
        "chatId": "YOUR_TELEGRAM_CHAT_ID",
        "additionalFields": {}
      },
      "typeVersion": 1
    },
    {
      "id": "ac5bde38-928b-4e2a-b9b0-8bcf07feb96f",
      "name": "Store to Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2100,
        680
      ],
      "parameters": {
        "table": "YOUR_TABLE_ID",
        "operation": "create",
        "application": {
          "__rl": true,
          "mode": "url",
          "value": ""
        },
        "authentication": "airtableTokenApi"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "CLqWz0zZEI8Oc8z1",
          "name": "Temp"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e996520c-56e6-46de-955b-baff944df0c2",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1460,
        660
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "WbMi3ZLLBnECFAAV",
          "name": "Temp"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "3c63b0e1-715f-4ced-84dd-dbd20bbc0a95",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        400
      ],
      "parameters": {
        "width": 1040,
        "height": 200,
        "content": "## Flow\n"
      },
      "typeVersion": 1
    },
    {
      "id": "1fe74c93-6a01-4bef-8c74-62a7f77611a9",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1380,
        620
      ],
      "parameters": {
        "color": 3,
        "content": "## Engine\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9710d293-7bf2-4305-be40-d095397b280e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2020,
        400
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 200,
        "content": "## Sinyal"
      },
      "typeVersion": 1
    },
    {
      "id": "05f0cb64-1b18-43aa-9707-50256406e4a3",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2020,
        640
      ],
      "parameters": {
        "color": 5,
        "width": 260,
        "height": 200,
        "content": "## Database\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4503a495-f86f-486d-9dd4-29eb45d7dc42",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1760,
        640
      ],
      "parameters": {
        "color": 4,
        "width": 220,
        "height": 200,
        "content": "## Get yesterday data "
      },
      "typeVersion": 1
    },
    {
      "id": "b7a0cddd-8e75-4b07-bd61-740443b9a202",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        400
      ],
      "parameters": {
        "color": 6,
        "width": 640,
        "height": 960,
        "content": "# 🧠 AI-Powered Real Estate Market Radar & Pain Point Detector\n\n## ❗️Problem  \nReal estate professionals often miss market signals due to the lack of consistent monitoring and analysis. Manually searching for updates, identifying pain points, and reacting to trends takes too much time and often gets skipped — resulting in lost leads and revenue opportunities.\n\n## ✅ Solution  \nThis automation runs a daily AI-powered \"market radar\" to:\n- Scrape top Google results about real estate industry queries  \n- Extract 3 current pain points using GPT-4o  \n- Compare with yesterday’s data to detect trends  \n- Notify stakeholders via Telegram  \n- Log insights into Airtable for long-term tracking\n\nAll fully automated using n8n.\n\n## 🧭 Scope  \n- Scheduled Google scraping with Apify  \n- AI summarization & pain point extraction via GPT-4o  \n- Trend detection (recurring vs new pain points)  \n- Telegram alerts  \n- Airtable storage for historical analysis  \n- Ready for extension: cold email generation, CRM sync, outreach workflows\n\n## 👥 For Who  \n- Real estate agencies  \n- PropTech founders  \n- Sales/marketing teams in real estate  \n- Freelancers or AI consultants  \n- Anyone needing market intelligence automation\n\n---\n\n💡 **Deploy this workflow to stay 10 steps ahead of your competition — fully automated, zero manual tracking.**\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c0b36601-3082-415f-9a65-77b4ed6bd20c",
  "connections": {
    "Apify Scraper": {
      "main": [
        [
          {
            "node": "Extract Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Summary": {
      "main": [
        [
          {
            "node": "Extract Pain Points",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Apify Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Extract Pain Points",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Compare Pain Points": {
      "main": [
        [
          {
            "node": "Telegram Notifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Pain Points": {
      "main": [
        [
          {
            "node": "Store to Airtable",
            "type": "main",
            "index": 0
          },
          {
            "node": "Compare Pain Points",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Yesterday Pain Points": {
      "main": [
        [
          {
            "node": "Compare Pain Points",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}