8
n8n 中文网amn8n.com

3. 活动参与者爬虫

中级

这是一个Market Research, AI Summarization领域的自动化工作流,包含 15 个节点。主要使用 Set, GoogleSheets, McpClientTool, Agent, ScheduleTrigger 等节点。 使用 Bright Data MCP、AI 和 Google Sheets 从 10times 抓取活动数据

前置要求
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "FtzJlVWzcws353Gp",
  "meta": {
    "instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
    "templateCredsSetupCompleted": true
  },
  "name": "3. 活动参与者爬虫",
  "tags": [],
  "nodes": [
    {
      "id": "ebf3b7e1-727d-44f0-a198-4899fe5eeabd",
      "name": "🕒 日程爬虫",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "07cd890b-ac50-4c89-9082-3784efe19cc8",
      "name": "⚙️ 输入 URL 和参数",
      "type": "n8n-nodes-base.set",
      "position": [
        220,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c1e742bf-8bd2-4d18-9a51-dac7cfaa51fd",
              "name": "url",
              "type": "string",
              "value": "https://10times.com"
            },
            {
              "id": "107ffa9d-231b-4991-b362-415ec08505b7",
              "name": "format",
              "type": "string",
              "value": "scrape_as_markdown"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "06a0519f-bb0b-4c81-af7e-a34b972fa54a",
      "name": "🤖 Bright Data AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        580,
        0
      ],
      "parameters": {
        "text": "=Scrape all category, featured_event, attendee_feedback and venue data using \"MCP Client to Scrape as markdown\" tool:\nurl: {{ $json.url }}",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "d343e2d6-92b8-4a7d-b7d4-b5e83b67f8f4",
      "name": "🧠 代理记忆模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        480,
        320
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "43bfe724-c78f-4597-b9dd-ef7c3d25afa3",
      "name": "🕷️ MCP 爬虫:10times",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        680,
        320
      ],
      "parameters": {
        "toolName": "scrape_as_markdown",
        "operation": "executeTool",
        "toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}",
        "descriptionType": "manual",
        "toolDescription": "Scrape a single webpage URL with advanced options for content extraction and get back the results in markdown"
      },
      "credentials": {
        "mcpClientApi": {
          "id": "eqq94k789oJCd6jU",
          "name": "MCP Client (STDIO) account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1dab45f4-1080-40ce-8381-a83f48855715",
      "name": "📥 保存到 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1160,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "vanues": "={{ $json.output.venues }}",
            "Categories": "={{ $json.output.categories }}",
            "Featured events": "={{ $json.output.featured_events }}",
            "Attendee feedback": "={{ $json.output.attendee_feedback }}"
          },
          "schema": [
            {
              "id": "Categories",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Categories",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Featured events",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Featured events",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Attendee feedback",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Attendee feedback",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "vanues",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "vanues",
              "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/1D9wZsMdv0bUvlC5IRAEiFsRNaLGrHwdykJWKOMXOe60/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D9wZsMdv0bUvlC5IRAEiFsRNaLGrHwdykJWKOMXOe60",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D9wZsMdv0bUvlC5IRAEiFsRNaLGrHwdykJWKOMXOe60/edit?usp=drivesdk",
          "cachedResultName": "Attendies data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "r2mDaisH6e9VkwHl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "858b205e-200f-4bac-aabe-dca745da17bd",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -640
      ],
      "parameters": {
        "color": 2,
        "width": 400,
        "height": 820,
        "content": "## 🟢 **第一部分:触发器与输入配置**"
      },
      "typeVersion": 1
    },
    {
      "id": "80c31fa5-1838-40af-9416-5e1e1efdd4bf",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        500,
        -1500
      ],
      "parameters": {
        "color": 3,
        "width": 400,
        "height": 1680,
        "content": "## 🤖 **第二部分:通过 AI 代理进行智能爬取**"
      },
      "typeVersion": 1
    },
    {
      "id": "4b32365f-d9ea-4043-8901-9e882357b892",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1020,
        -520
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 700,
        "content": "## 📊 **第三部分:保存并重复使用潜在客户**"
      },
      "typeVersion": 1
    },
    {
      "id": "aa026e7b-1731-435d-b21f-3bcf150270ca",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2100,
        -640
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "029770da-da09-432a-b085-434b9d7a0660",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2100,
        -300
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 2398,
        "content": "## 🚀 **工作流标题:10times 活动情报爬虫**"
      },
      "typeVersion": 1
    },
    {
      "id": "0cd21ab6-0482-4948-a601-3bf2cc3b8264",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1540,
        -520
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 240,
        "content": "## 如果您通过此链接加入 Bright Data,我将获得少量佣金——感谢您为更多免费内容提供动力!"
      },
      "typeVersion": 1
    },
    {
      "id": "de5252a5-bc2b-4014-bb53-2891dd5d58af",
      "name": "自动修复输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
      "position": [
        820,
        320
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "4c8802f0-0dfd-4452-b413-b4b049820cef",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        780,
        560
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "35f9f084-8513-4170-bf77-bf28efb732a1",
      "name": "多表:您可以连接多个表以实现有组织的数据结构",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        960,
        540
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"categories\": [\n    \"Education & Training\",\n    \"Medical & Pharma\",\n    \"IT & Technology\",\n    \"Banking & Finance\",\n    \"Business Services\",\n    \"Entertainment & Media\",\n    \"Industrial Engineering\"\n  ],\n  \"featured_events\": [\n    {\n      \"name\": \"Texworld New York City\",\n      \"date\": \"Wed, 23 - Fri, 25 Jul 2025\",\n      \"location\": \"New York, USA\"\n    },\n    {\n      \"name\": \"Home Textiles Sourcing Expo\",\n      \"date\": \"Wed, 23 - Fri, 25 Jul 2025\",\n      \"location\": \"New York, USA\"\n    },\n    {\n      \"name\": \"Texworld Los Angeles\",\n      \"date\": \"Tue, 29 - Thu, 31 Jul 2025\",\n      \"location\": \"Los Angeles, USA\"\n    }\n  ],\n  \"attendee_feedback\": [\n    {\n      \"event\": \"Restaurants Canada Show\",\n      \"comment\": \"Great preparations\",\n      \"user\": \"MARIAH NDAGIRE\",\n      \"country\": \"Canada\"\n    },\n    {\n      \"event\": \"WoodEX for Africa\",\n      \"comment\": \"Great event, well organised...\",\n      \"user\": \"Kgometji Thosago\",\n      \"country\": \"South Africa\"\n    },\n    {\n      \"event\": \"International Hardware Fair Saudi Arabia\",\n      \"comment\": \"Well organised and clean setup...\",\n      \"user\": \"Taha Khan\",\n      \"country\": \"Saudi Arabia\"\n    },\n    {\n      \"event\": \"World Environment Expo\",\n      \"comment\": \"Very nice exhibition with lots of new information...\",\n      \"user\": \"Chauhansir\",\n      \"country\": \"India\"\n    },\n    {\n      \"event\": \"IGC Grains Conference\",\n      \"comment\": \"Learnt a lot...\",\n      \"user\": \"AbdulFatai Suleiman\",\n      \"country\": \"Nigeria\"\n    }\n  ],\n  \"venues\": [\n    {\n      \"name\": \"Jio World Convention Centre\",\n      \"city\": \"Mumbai\",\n      \"country\": \"India\",\n      \"total_events\": 204\n    },\n    {\n      \"name\": \"ExCeL London\",\n      \"city\": \"London\",\n      \"country\": \"United Kingdom\",\n      \"total_events\": 815\n    },\n    {\n      \"name\": \"Melbourne Convention and Exhibition Centre\",\n      \"city\": \"Melbourne\",\n      \"country\": \"Australia\",\n      \"total_events\": 1028\n    }\n  ]\n}\n"
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "34c237ed-c5b5-460e-a596-42bf236c5422",
  "connections": {
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Auto-fixing Output Parser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "🕒 Schedule Scraper": {
      "main": [
        [
          {
            "node": "⚙️ Input URL & Params",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Agent Memory Model": {
      "ai_languageModel": [
        [
          {
            "node": "🤖 Bright Data AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Auto-fixing Output Parser",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Auto-fixing Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "🤖 Bright Data AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "⚙️ Input URL & Params": {
      "main": [
        [
          {
            "node": "🤖 Bright Data AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🤖 Bright Data AI Agent": {
      "main": [
        [
          {
            "node": "📥 Save to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕷️ MCP Scraper: 10times": {
      "ai_tool": [
        [
          {
            "node": "🤖 Bright Data AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者
Yaron Been

Yaron Been

@yaron-nofluff

Building 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 查看

分享此工作流