30 跟踪区域情绪
中级
这是一个Market Research、AI Summarization领域的自动化工作流，包含 15 个节点。主要使用 Set、Trello、McpClientTool、ManualTrigger、Agent 等节点。 使用Bright Data和OpenAI跟踪社交媒体区域情绪
前置要求
- •OpenAI API Key
使用的节点 (15 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "M7Yn4F1dlwkiUFNt",
"meta": {
"instanceId": "c38e3b8a7e4240e6cdca062743f016c1029f385bf40345b6291939dfd83bfd77",
"templateCredsSetupCompleted": true
},
"name": "30 跟踪区域情绪",
"tags": [],
"nodes": [
{
"id": "a1c3cd68-4f17-4b37-a65d-aa2708eb037d",
"name": "🔘 触发器：手动执行",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-440,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "45d63021-fdb1-449f-a588-fc1263d9ebd0",
"name": "🌐 设置 Yelp URL（天气帖子 - 洛杉矶）",
"type": "n8n-nodes-base.set",
"position": [
-240,
-100
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "01728220-5a24-45b8-aa1c-54d5ea541d7c",
"name": "URL",
"type": "string",
"value": "https://www.yelp.com/search?find_desc=weather&find_loc=Los+Angeles%2C+CA%2C+United+States"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "254f2185-722c-4bf8-85e1-87a36ab88371",
"name": "💬 AI 模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-60,
160
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "8af55964-2e46-4bff-bcce-51a474e5acdc",
"name": "🌐 MCP 客户端：抓取天气帖子数据",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
80,
160
],
"parameters": {
"toolName": "scrape_as_markdown",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "dGu6Ys11ijXSTxcV",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "fed36ea2-824e-4052-a58a-a6c9be121f8d",
"name": "🤖 AI Agent：抓取 Yelp 天气帖子并定制营销活动",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
20,
-100
],
"parameters": {
"text": "=You are a data extraction agent.\n\nScrape the following Yelp search page for weather-related content in Los Angeles:\n{{ $json.URL }}\n\nFor each business or post, extract the following details:\n\n- `business_name`: The name of the business or event.\n- `location`: The location of the business or event.\n- `rating`: The Yelp rating of the business.\n- `reviews_count`: The number of reviews the business has.\n- `post_text`: The description or content provided about the weather (if available).\n- `weather_related`: Any mention, problem, or fun of weather in the description or reviews (if available).\n\nAdditionally, perform **sentiment analysis** on the extracted weather-related text, and categorize the sentiment as **Positive**, **Negative**, or **Neutral**.\n\nBased on the sentiment, create a **tailored campaign** for each weather-related post:\n- **Positive Sentiment**: Recommend promoting **outdoor activities** or **sunny weather products** (e.g., sunscreen, sunglasses).\n- **Negative Sentiment**: Suggest offering **rain-related products**, **indoor activities**, or **solutions** (e.g., umbrellas, warm drinks).\n- **Neutral Sentiment**: Suggest promoting **general services** or **upcoming events**.\n\n",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "56af8e64-3846-4002-b421-99e932cf22a2",
"name": "📋 为天气营销活动创建 Trello 卡片",
"type": "n8n-nodes-base.trello",
"position": [
480,
-100
],
"parameters": {
"name": "Campaign ",
"description": "=洛杉矶天气营销活动：",
"additionalFields": {
"due": ""
}
},
"typeVersion": 1
},
{
"id": "e733ffb4-a7c2-423c-af5b-cd0e973f0f5d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-820
],
"parameters": {
"color": 2,
"width": 400,
"height": 900,
"content": "-### 🔹 **第一部分：输入 URL 并触发工作流**"
},
"typeVersion": 1
},
{
"id": "a910ba45-e62f-4e70-9ed3-f9aaf6963845",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-1140
],
"parameters": {
"color": 3,
"width": 420,
"height": 1220,
"content": "### 🤖 **第二部分：抓取数据并结构化**"
},
"typeVersion": 1
},
{
"id": "6edd6577-fe4d-435d-8d9e-02baeb31704c",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
380,
-860
],
"parameters": {
"color": 5,
"width": 300,
"height": 940,
"content": "### 📋 **第三部分：为营销活动创建 Trello 卡片**"
},
"typeVersion": 1
},
{
"id": "42c87047-da6a-4bac-9a02-d7819ef3aa67",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2000,
-1400
],
"parameters": {
"color": 4,
"width": 1300,
"height": 2720,
"content": "## 🚀 **天气营销活动自动化工作流**"
},
"typeVersion": 1
},
{
"id": "340f317f-0113-4a3b-bb31-eb4ce34eef4a",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
-860
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入Bright Data，我将获得少量佣金 - 感谢您为更多免费内容提供支持！"
},
"typeVersion": 1
},
{
"id": "cbc65d92-9fe7-44ea-820c-14d8557c313b",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2000,
-1740
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "6b29563e-2b13-4a93-8b68-2086d90892cd",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
200,
160
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "36cfc69b-af9d-4d89-beef-fffba452e27e",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
160,
380
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "fc53117e-62fb-49a7-89af-2c0d7d3413af",
"name": "📝 将抓取数据解析为 JSON 格式1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
340,
380
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"business_name\": \"About Time\",\n \"location\": \"Wilshire Center, Los Angeles, CA\",\n \"rating\": \"3.5\",\n \"reviews_count\": 478,\n \"post_text\": \"I love the garden, I want to sit inside in cold weather but there is no space. It is a very nice...\",\n \"weather_related\": \"Mention of cold weather and a garden suitable for sitting.\",\n \"sentiment\": \"Positive\",\n \"campaign_suggestion\": \"Promote outdoor activities and cozy garden seating for cooler weather.\",\n \"trello_card\": {\n \"title\": \"Campaign for About Time - Mention of cold weather and a garden suitable for sitting.\",\n \"description\": \"Location: Wilshire Center, Los Angeles, CA\\nRating: 3.5\\nReviews Count: 478\\nSentiment: Positive\\nCampaign: Promote outdoor activities and cozy garden seating for cooler weather.\",\n \"due_date\": \"2025-07-06\",\n \"labels\": [\"Positive\"]\n }\n },\n {\n \"business_name\": \"Grand Heating and Air Conditioning\",\n \"location\": \"Los Angeles, CA\",\n \"rating\": \"3.2\",\n \"reviews_count\": 34,\n \"post_text\": \"Well, come the summer of 2015 and the weather was hot enough for me to decide that the time had come...\",\n \"weather_related\": \"Hot weather leading to decision to use HVAC services.\",\n \"sentiment\": \"Neutral\",\n \"campaign_suggestion\": \"Promote HVAC services for summer heat and general weather comfort solutions.\",\n \"trello_card\": {\n \"title\": \"Campaign for Grand Heating and Air Conditioning - Hot weather leading to HVAC use.\",\n \"description\": \"Location: Los Angeles, CA\\nRating: 3.2\\nReviews Count: 34\\nSentiment: Neutral\\nCampaign: Promote HVAC services for summer heat and general weather comfort solutions.\",\n \"due_date\": \"2025-07-06\",\n \"labels\": [\"Neutral\"]\n }\n },\n {\n \"business_name\": \"Ravenswood Apartments\",\n \"location\": \"Hancock Park, Los Angeles, CA\",\n \"rating\": \"1.9\",\n \"reviews_count\": 14,\n \"post_text\": \"The weather was getting warmer so I managed to catch Gabriella mgr in the lobby one day, and asked...\",\n \"weather_related\": \"Mention of warming weather.\",\n \"sentiment\": \"Neutral\",\n \"campaign_suggestion\": \"Promote general services or upcoming community events for residents.\",\n \"trello_card\": {\n \"title\": \"Campaign for Ravenswood Apartments - Mention of warming weather.\",\n \"description\": \"Location: Hancock Park, Los Angeles, CA\\nRating: 1.9\\nReviews Count: 14\\nSentiment: Neutral\\nCampaign: Promote general services or upcoming community events for residents.\",\n \"due_date\": \"2025-07-06\",\n \"labels\": [\"Neutral\"]\n }\n },\n {\n \"business_name\": \"Harbor City\",\n \"location\": \"Harbor City, Los Angeles, CA\",\n \"rating\": \"5.0\",\n \"reviews_count\": 1,\n \"post_text\": \"South of Carson, North of San Pedro. One of those areas of LA that don't get as much attention as their surrounding neighbors for one reason or...\",\n \"weather_related\": \"No direct weather mention despite search context.\",\n \"sentiment\": \"Neutral\",\n \"campaign_suggestion\": \"Promote local neighborhood features and upcoming events.\",\n \"trello_card\": {\n \"title\": \"Campaign for Harbor City - Promote local neighborhood features.\",\n \"description\": \"Location: Harbor City, Los Angeles, CA\\nRating: 5.0\\nReviews Count: 1\\nSentiment: Neutral\\nCampaign: Promote local neighborhood features and upcoming events.\",\n \"due_date\": \"2025-07-06\",\n \"labels\": [\"Neutral\"]\n }\n }\n]\n"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "c57bb610-51bd-490f-9277-708ec418b40d",
"connections": {
"💬 AI Model": {
"ai_languageModel": [
[
{
"node": "🤖 AI Agent: Scrape Yelp Weather Posts and tailor campaigns",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "🤖 AI Agent: Scrape Yelp Weather Posts and tailor campaigns",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🔘 Trigger: Manual Execution": {
"main": [
[
{
"node": "🌐 Set Yelp URL (Weather Posts - Los Angeles)",
"type": "main",
"index": 0
}
]
]
},
"📝 Parse Scraped Data into JSON Format1": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🌐 MCP Client: Scrape Weather Posts Data": {
"ai_tool": [
[
{
"node": "🤖 AI Agent: Scrape Yelp Weather Posts and tailor campaigns",
"type": "ai_tool",
"index": 0
}
]
]
},
"🌐 Set Yelp URL (Weather Posts - Los Angeles)": {
"main": [
[
{
"node": "🤖 AI Agent: Scrape Yelp Weather Posts and tailor campaigns",
"type": "main",
"index": 0
}
]
]
},
"🤖 AI Agent: Scrape Yelp Weather Posts and tailor campaigns": {
"main": [
[
{
"node": "📋 Create Trello Card for Weather Campaign",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于Market Research、AI Summarization等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
14 分析竞争对手内容表现
使用Bright Data MCP和GPT-4o分析竞争对手内容表现
Set
Gmail
Mcp Client Tool
+6
15 节点Yaron Been
Market Research
25收集功能请求
通过AI自动化从评论到Jira的功能请求收集与分析
Set
Code
Jira
+7
16 节点Yaron Been
Market Research
监控本地事件
使用 Bright Data MCP 和 OpenAI 分析自动监控本地事件
Set
Code
Google Sheets
+8
18 节点Yaron Been
Market Research
13 识别趋势主题
使用Bright Data MCP、GPT分析和Trello集成发现趋势主题
Set
Code
Trello
+7
16 节点Yaron Been
Market Research
分析竞争对手反向链接
使用Bright Data MCP和GPT提取和分析竞争对手反向链接数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
Market Research
监控客户支持论坛
使用Bright Data和GPT-4从支持论坛提取客户痛点
Set
Gmail
Mcp Client Tool
+6
15 节点Yaron Been
Market Research
工作流信息
难度等级
中级
节点数量15
分类2
节点类型9
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 上查看 →
分享此工作流