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)可能需要您自行付费。
相关工作流推荐
地缘政治突发新闻警报
使用AI评分和Telegram警报过滤地缘政治突发新闻
If
Code
Merge
+9
30 节点Dev Dutta
市场调研
新抓取器_TechCrunch新闻-AI1
TechCrunch AI文章抓取与分类器,使用GPT-4.1-nano到Sheets和Telegram
Set
Code
Html
+12
18 节点Mujahid Kabae
市场调研
基于GPT-4和Apify的AI驱动竞争对手与市场情报系统
基于GPT-4和Apify的AI驱动竞争对手与市场情报系统
Code
Merge
Slack
+7
12 节点Marth
市场调研
使用GPT-4o、Sheets和Slack自动化月度Google Ads性能分析
使用GPT-4o、Sheets和Slack自动化月度Google Ads性能分析
Code
Slack
Http Request
+5
13 节点Nikan Noorafkan
市场调研
使用GPT-4洞察和Slack交付自动化每周SEO报告
通过GPT-4洞察和Slack交付自动化每周SEO报告
Set
Code
Merge
+8
42 节点Marcelo Abreu
市场调研
基于 GPT-4 专家的全面 SEO 审计,使用 Analytics、Search Console 和 PageSpeed
基于 GPT-4 专家的全面 SEO 审计,使用 Analytics、Search Console 和 PageSpeed
Set
Code
Merge
+8
38 节点Jimmy Gay
市场调研