监控本地事件
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 18 个节点。主要使用 Set, Code, GoogleSheets, McpClientTool, ManualTrigger 等节点。 使用 Bright Data MCP 和 OpenAI 分析自动监控本地事件
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "TEik9cMOxXRNqB3y",
"meta": {
"instanceId": "c38e3b8a7e4240e6cdca062743f016c1029f385bf40345b6291939dfd83bfd77",
"templateCredsSetupCompleted": true
},
"name": "29 监控本地事件",
"tags": [],
"nodes": [
{
"id": "77a9030f-adf7-41d1-937a-f6434dba8f1b",
"name": "🔘 触发器：执行工作流",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-380,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ece3f688-4f85-494f-8cb0-bba74cd200b9",
"name": "🌐 设置 10Times URL",
"type": "n8n-nodes-base.set",
"position": [
-180,
-120
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e43ab694-0544-4809-9677-44e9bb5edd2c",
"name": "URL",
"type": "string",
"value": "https://10times.com/newyork-us"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "61113487-acc4-44b8-b5ba-96fea20d93e4",
"name": "🤖 代理：抓取事件数据",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
100,
-120
],
"parameters": {
"text": "=You are a data extraction agent.\n\nScrape the following 10Times URL for events in newYork od US :\n{{ $json.URL }}\n\nExtract data for the events listed on this page. For each event, provide the following details :\n\n- `event_name`: The name of the event.\n- `location`: The location of the event (venue name and address, if available).\n- `date`: The event date and time.\n- `category`: The event's category (e.g., Networking, Tech, Sports, etc.).\n- `description`: A brief description of the event.\n- `url`: The URL to the event page.\n- `attendees`: The number of attendees (if available, otherwise dont return ).\n\n\n",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "1b7297d3-df9b-414b-a723-bc07dfd361e5",
"name": "💬 AI 模型：数据处理",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
20,
140
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "587436b5-3bae-4a1f-b2fa-ca438246906a",
"name": "🌐 Bright Data MCP 客户端",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
180,
140
],
"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": "83a45d10-f6f5-404c-9285-101a092c2bd1",
"name": "🔀 将事件拆分为单独项目",
"type": "n8n-nodes-base.code",
"position": [
560,
-120
],
"parameters": {
"jsCode": "// Access the scraped event data (from the AI Agent output)\nconst events = items[0].json.output; \n\n// Map through each event and return individual items\nreturn events.map(event => {\n return {\n json: event\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "6bfb0096-6b80-4f2c-a11c-a1c020ccc88b",
"name": "💬 AI：分析事件的赞助机会",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
740,
-120
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=we have our own company related to tech and we launch a product about project management. following are some events and i want you to analyze them and then find the sponsership opportunities and rate it out of 10.\nThe event is given below:\n\nevent_name: {{ $json.event_name }}\nlocation: {{ $json.location }}\ndata: {{ $json.date }}\ncategory: {{ $json.category }}\ndescription: {{ $json.description }}\nurl: {{ $json.url }}\nattendees: {{ $json.attendees }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.8
},
{
"id": "e6ccb9b9-b66b-44d3-8a3c-983ec59de7e8",
"name": "📥 将事件和赞助评级保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1180,
-120
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('🔀 Split Events into Separate Items').item.json.url }}",
"Date": "={{ $('🔀 Split Events into Separate Items').item.json.date }}",
"Category": "={{ $('🔀 Split Events into Separate Items').item.json.category }}",
"Location": "={{ $('🔀 Split Events into Separate Items').item.json.location }}",
"Attendees": "={{ $('🔀 Split Events into Separate Items').item.json.attendees }}",
"Event name": "={{ $('🔀 Split Events into Separate Items').item.json.event_name }}",
"Description": "={{ $('🔀 Split Events into Separate Items').item.json.description }}",
"Sponsership opportunities": "={{ $json.message.content }}"
},
"schema": [
{
"id": "Event name",
"type": "string",
"display": true,
"required": false,
"displayName": "Event name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Category",
"type": "string",
"display": true,
"required": false,
"displayName": "Category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Attendees",
"type": "string",
"display": true,
"required": false,
"displayName": "Attendees",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sponsership opportunities",
"type": "string",
"display": true,
"required": false,
"displayName": "Sponsership opportunities",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17iJ3Qr6GwZF8gGxx7xUEnLVPV7eMADef12IaBwe8qZQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "17iJ3Qr6GwZF8gGxx7xUEnLVPV7eMADef12IaBwe8qZQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/17iJ3Qr6GwZF8gGxx7xUEnLVPV7eMADef12IaBwe8qZQ/edit?usp=drivesdk",
"cachedResultName": "sponsership opportunities"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i899RBJ6SKiYYWwx",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "f4fed95c-8f1b-444c-9a1c-76ffeec744f0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-440,
-840
],
"parameters": {
"color": 6,
"width": 420,
"height": 900,
"content": "### 🔹 **第一部分：输入 URL 并触发工作流**"
},
"typeVersion": 1
},
{
"id": "239e8142-efc2-485b-b244-d9f9ce4bba37",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-980
],
"parameters": {
"color": 2,
"width": 460,
"height": 1040,
"content": "### 🤖 **第二部分：从 10Times 抓取事件数据**"
},
"typeVersion": 1
},
{
"id": "a08bdffa-8bcc-4672-a608-6424af469ece",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-840
],
"parameters": {
"color": 3,
"width": 500,
"height": 900,
"content": "### 🧮 **第三部分：分析事件的赞助机会**"
},
"typeVersion": 1
},
{
"id": "b0d9ed91-cca6-4ff0-8aee-85fe89f94220",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
-700
],
"parameters": {
"color": 5,
"width": 360,
"height": 760,
"content": "### 📊 **第四部分：将数据存储到 Google Sheets**"
},
"typeVersion": 1
},
{
"id": "01a56a12-c19a-428e-b9c7-b648714fa750",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2240,
-1340
],
"parameters": {
"color": 4,
"width": 1300,
"height": 2900,
"content": "## 🚀 **事件赞助分析工作流**"
},
"typeVersion": 1
},
{
"id": "30175a60-0c2b-48eb-8d31-eef26660c1bf",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
-700
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得一小笔佣金 — 感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "e65d2b7a-d905-4f11-8bed-56379c19933a",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2240,
-1700
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "cc435d95-c9b9-490e-bf1e-41f2a0b9747f",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
320,
140
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "ddc0a20f-ca28-4195-af59-16ea4e539962",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
280,
360
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "kmqnyfHdWfA8k1KC",
"name": "OpenAi account 3"
}
},
"typeVersion": 1.2
},
{
"id": "a687afed-64f2-47c0-9892-9a854a700698",
"name": "📝 将抓取的数据解析为 JSON1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
460,
360
],
"parameters": {
"jsonSchemaExample": "[\n {\n \"event_name\": \"Texworld New York City\",\n \"location\": \"Jacob K. Javits Convention Center, New York\",\n \"date\": \"Wed, 23 - Fri, 25 Jul 2025\",\n \"category\": \"Apparel & Clothing\",\n \"description\": \"Your Premier Event for Textile and Fabric Sourcing\",\n \"url\": \"https://10times.com/texworld-usa\",\n \"attendees\": 9816\n },\n {\n \"event_name\": \"Home Textiles Sourcing Expo\",\n \"location\": \"Jacob K. Javits Convention Center, New York\",\n \"date\": \"Wed, 23 - Fri, 25 Jul 2025\",\n \"category\": \"Apparel & Clothing, Textile, Fabrics & Yarns, Furnishings & Decor, Home & Office\",\n \"description\": \"North Americas only tradeshow dedicated to home textiles and finished soft goods\",\n \"url\": \"https://10times.com/home-textiles-market-ney-york\",\n \"attendees\": 2238\n },\n {\n \"event_name\": \"Premiere Vision New York\",\n \"location\": \"Tribeca 360 Degree, New York\",\n \"date\": \"Tue, 15 - Wed, 16 Jul 2025\",\n \"category\": \"Apparel & Clothing, Fashion & Beauty\",\n \"description\": \"Trade Show for Apparel, Lifestyle & Fashion Industries\",\n \"url\": \"https://10times.com/premiere-vision-newyork\",\n \"attendees\": 3561\n },\n {\n \"event_name\": \"Apparel Sourcing New York City\",\n \"location\": \"Jacob K. Javits Convention Center, New York\",\n \"date\": \"Wed, 23 - Fri, 25 Jul 2025\",\n \"category\": \"Apparel & Clothing, Fashion & Beauty\",\n \"description\": \"The Largest Sourcing Show On The East Coast\",\n \"url\": \"https://10times.com/apparelsourcing\",\n \"attendees\": 5497\n },\n {\n \"event_name\": \"TECHSPO New York\",\n \"location\": \"New York Marriott at the Brooklyn Bridge, New York\",\n \"date\": \"Mon, 07 - Tue, 08 Jul 2025\",\n \"category\": \"IT & Technology\",\n \"description\": \"TECHSPO New York\",\n \"url\": \"https://10times.com/techspo-new-york\",\n \"attendees\": 231\n },\n {\n \"event_name\": \"NY NOW\",\n \"location\": \"Jacob K. Javits Convention Center, New York\",\n \"date\": \"Sun, 03 - Tue, 05 Aug 2025\",\n \"category\": \"Stationery, Furnishings & Decor, Home & Office\",\n \"description\": \"NY NOW links brands, designers, and buyers, featuring innovative designs, luxury lifestyle items, eco-conscious crafts, and various categories, serving as a vital source for trend discovery and more.\",\n \"url\": \"https://10times.com/international-gift-fair\",\n \"attendees\": 4957\n },\n {\n \"event_name\": \"SPINEXPO New York\",\n \"location\": \"Metropolitan Pavilion, New York\",\n \"date\": \"Tue, 08 - Wed, 09 Jul 2025\",\n \"category\": \"Apparel & Clothing, Textile, Fabrics & Yarns\",\n \"description\": \"International exhibition for yarns, fibres for the knitting and woven fabrics sectors\",\n \"url\": \"https://10times.com/spinexpo-newyork\",\n \"attendees\": 561\n },\n {\n \"event_name\": \"LINEAPELLE NEW YORK\",\n \"location\": \"Metropolitan Pavilion, New York\",\n \"date\": \"Wed, 16 - Thu, 17 Jul 2025\",\n \"category\": \"Apparel & Clothing, Leather & Leatherite, Textile, Fabrics & Yarns, Fashion & Beauty\",\n \"description\": \"International Fair of Leather, Textiles and Synthetics Industry\",\n \"url\": \"https://10times.com/trend-selection-newyork\",\n \"attendees\": 1174\n },\n {\n \"event_name\": \"Functional Fabric Fair\",\n \"location\": \"Jacob K. Javits Convention Center, New York\",\n \"date\": \"Mon, 21 - Wed, 23 Jul 2025\",\n \"category\": \"Apparel & Clothing\",\n \"description\": \"The Functional Fabric Fair is a premier trade-exclusive event designed for verified designers, product managers, purchasing agents, and material managers.\",\n \"url\": \"https://10times.com/functionalfabricfair\",\n \"attendees\": 429\n },\n {\n \"event_name\": \"Man/Woman New York\",\n \"location\": \"Spring Studios, New York\",\n \"date\": \"Wed, 16 - Fri, 18 Jul 2025\",\n \"category\": \"Apparel & Clothing, Fashion & Beauty, Fashion Shows\",\n \"description\": \"The human scale fashion trade show\",\n \"url\": \"https://10times.com/man-new-york\",\n \"attendees\": 515\n }\n]\n"
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "23dcf0d9-99e6-40b4-afc7-6f4b9326f8c0",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🌐 Set 10Times URL ": {
"main": [
[
{
"node": "🤖 Agent: Scrape Events Data ",
"type": "main",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "🤖 Agent: Scrape Events Data ",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🌐 Bright Data MCP Client": {
"ai_tool": [
[
{
"node": "🤖 Agent: Scrape Events Data ",
"type": "ai_tool",
"index": 0
}
]
]
},
"💬 AI Model: Data Processing": {
"ai_languageModel": [
[
{
"node": "🤖 Agent: Scrape Events Data ",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"🔘 Trigger: Execute Workflow": {
"main": [
[
{
"node": "🌐 Set 10Times URL ",
"type": "main",
"index": 0
}
]
]
},
"🤖 Agent: Scrape Events Data ": {
"main": [
[
{
"node": "🔀 Split Events into Separate Items",
"type": "main",
"index": 0
}
]
]
},
"📝 Parse Scraped Data into JSON1": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🔀 Split Events into Separate Items": {
"main": [
[
{
"node": "💬 AI: Analyze Events for Sponsorship Opportunities",
"type": "main",
"index": 0
}
]
]
},
"💬 AI: Analyze Events for Sponsorship Opportunities": {
"main": [
[
{
"node": "📥 Save Events & Sponsorship Ratings to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
分析竞争对手反向链接
使用Bright Data MCP和GPT提取和分析竞争对手反向链接数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
35 监控竞争对手财务状况
使用Bright Data MCP、OpenAI和Google Sheets监控竞争对手财务表现
Set
Code
Gmail
+8
18 节点Yaron Been
市场调研
监控竞争对手社交媒体互动
使用Bright Data和AI监控LinkedIn竞争对手参与度与分析
Set
Code
Google Sheets
+7
19 节点Yaron Been
市场调研
追踪本地搜索趋势
使用Bright Data MCP和AI分析本地Google趋势搜索数据
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
从Trustpilot抓取评论
使用OpenAI和Bright Data进行Trustpilot评论情感分析并同步到Google Sheets
Set
Code
Google Sheets
+7
16 节点Yaron Been
市场调研
25收集功能请求
通过AI自动化从评论到Jira的功能请求收集与分析
Set
Code
Jira
+7
16 节点Yaron Been
市场调研
工作流信息
难度等级
高级
节点数量18
分类2
节点类型11
作者
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 查看 →
分享此工作流