8
n8n 中文网amn8n.com

AI驱动的房地产市场雷达与痛点检测器

中级

这是一个Market Research, AI Summarization领域的自动化工作流,包含 15 个节点。主要使用 Code, Airtable, Telegram, HttpRequest, Agent 等节点。 使用Apify、GPT-4o和Telegram提醒跟踪房地产市场痛点

前置要求
  • Airtable API Key
  • Telegram Bot Token
  • 可能需要目标 API 的认证凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "mxi77QamrosSQS1S",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae"
  },
  "name": "AI驱动的房地产市场雷达与痛点检测器",
  "tags": [],
  "nodes": [
    {
      "id": "bc0232b7-456e-4423-b05b-1a61483b16f9",
      "name": "计划触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1020,
        440
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f755765f-46e7-44a9-8706-d9e0c2cf1e03",
      "name": "Apify 爬虫",
      "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": "提取摘要",
      "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": "提取痛点",
      "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": "读取昨日痛点",
      "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": "比较痛点",
      "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 通知器",
      "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": "存储到 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 聊天模型",
      "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": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        400
      ],
      "parameters": {
        "width": 1040,
        "height": 200,
        "content": "## 流程"
      },
      "typeVersion": 1
    },
    {
      "id": "1fe74c93-6a01-4bef-8c74-62a7f77611a9",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1380,
        620
      ],
      "parameters": {
        "color": 3,
        "content": "## 引擎"
      },
      "typeVersion": 1
    },
    {
      "id": "9710d293-7bf2-4305-be40-d095397b280e",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2020,
        400
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 200,
        "content": "## 信号"
      },
      "typeVersion": 1
    },
    {
      "id": "05f0cb64-1b18-43aa-9707-50256406e4a3",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2020,
        640
      ],
      "parameters": {
        "color": 5,
        "width": 260,
        "height": 200,
        "content": "## 数据库"
      },
      "typeVersion": 1
    },
    {
      "id": "4503a495-f86f-486d-9dd4-29eb45d7dc42",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1760,
        640
      ],
      "parameters": {
        "color": 4,
        "width": 220,
        "height": 200,
        "content": "## 获取昨日数据"
      },
      "typeVersion": 1
    },
    {
      "id": "b7a0cddd-8e75-4b07-bd61-740443b9a202",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        400
      ],
      "parameters": {
        "color": 6,
        "width": 640,
        "height": 960,
        "content": "# 🧠 AI驱动的房地产市场雷达与痛点检测器"
      },
      "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
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

中级 - 市场调研, AI 摘要总结

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量15
分类2
节点类型8
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

外部链接
在 n8n.io 查看

分享此工作流