8
n8n 中文网amn8n.com

自动化论坛监控_via_Bright_data

高级

这是一个AI领域的自动化工作流,包含 17 个节点。主要使用 Set, Code, Html, HttpRequest, GoogleSheets 等节点,结合人工智能技术实现智能自动化。 使用Bright Data和n8n的论坛监控自动化

前置要求
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "hEt4K6p0NxH8EKdf",
  "meta": {
    "instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480"
  },
  "name": "自动化论坛监控_via_Bright_data",
  "tags": [],
  "nodes": [
    {
      "id": "d46077f8-080f-4611-afd9-75b3c50fd912",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3280,
        820
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e8147cbd-97f6-40c3-84b3-2d30d10e7e04",
      "name": "定期运行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1780,
        600
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e60c1249-dc44-46b9-b691-5329f58d7e41",
      "name": "定义搜索关键词",
      "type": "n8n-nodes-base.set",
      "position": [
        2000,
        600
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "96c78660-315e-491f-8942-56dc4365c093",
              "name": "keyword",
              "type": "string",
              "value": "iPhone+16"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "fd3c6b86-2f82-4290-84cf-50627dc38fb7",
      "name": "Google 搜索结果",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2240,
        600
      ],
      "parameters": {
        "url": "https://api.brightdata.com/request",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"zone\": \"n8n_unblocker\",\n  \"url\": \"https://www.google.com/search?q=site:quora.com+{{ $json.keyword }}\",\n  \"country\": \"us\",\n  \"format\": \"raw\",\n  \"headers\": {\n    \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64)\"\n  }\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "edddbf94-87ed-4d59-9fed-4994dedc618d",
      "name": "从 Google HTML 提取链接",
      "type": "n8n-nodes-base.html",
      "position": [
        2440,
        600
      ],
      "parameters": {
        "options": {},
        "operation": "extractHtmlContent",
        "extractionValues": {
          "values": [
            {
              "key": "Thread Titles",
              "cssSelector": "h3",
              "returnArray": true
            },
            {
              "key": "b",
              "cssSelector": "div.yuRUbf a",
              "returnArray": true,
              "returnValue": "attribute"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2bb4b2c0-49a5-49e5-afc8-220d0e39d0ce",
      "name": "格式化线程 URL",
      "type": "n8n-nodes-base.code",
      "position": [
        2620,
        600
      ],
      "parameters": {
        "jsCode": "const titles = items[0].json[\"Thread Titles\"];\nconst urls = items[0].json[\"b\"].map(obj => obj.href);\n\n// Build array of { title, url }\nconst output = [];\n\nfor (let i = 0; i < Math.min(titles.length, urls.length); i++) {\n  output.push({\n    json: {\n      title: titles[i],\n      url: urls[i]\n    }\n  });\n}\n\nreturn output;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "a3f3ad74-a548-4135-b07f-69f38bf7dd9b",
      "name": "单个 Quora 线程",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2860,
        600
      ],
      "parameters": {
        "url": "https://api.brightdata.com/request",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"zone\": \"n8n_unblocker\",\n  \"url\": \"{{ $json.url }}\",\n  \"country\": \"us\",\n  \"format\": \"raw\",\n  \"headers\": {\n    \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64)\"\n  }\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3c1de319-64fc-4cb8-b78f-92fbf0d7ecba",
      "name": "保存到 Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3660,
        600
      ],
      "parameters": {
        "columns": {
          "value": {
            "Topic": "={{ $('Define Search Keyword').item.json.keyword }}",
            "Discussion Summary": "={{ $json.output }}"
          },
          "schema": [
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Discussion Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Discussion Summary",
              "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/1eCtVRklGjweUv7HS4wfMEGtdyd8YGzNl0D-3zNbExgM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1eCtVRklGjweUv7HS4wfMEGtdyd8YGzNl0D-3zNbExgM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eCtVRklGjweUv7HS4wfMEGtdyd8YGzNl0D-3zNbExgM/edit?usp=drivesdk",
          "cachedResultName": "Quora discussion summary"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "r2mDaisH6e9VkwHl",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "efd597da-ed96-49b5-94d9-c5202e39eeca",
      "name": "AI 反馈摘要1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        3300,
        600
      ],
      "parameters": {
        "text": "=Summarize the following consumer feedback from Quora:\n{{ $json.answers }}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2
    },
    {
      "id": "99bc2765-9f81-449c-9eac-9138aad22117",
      "name": "来自线程的答案",
      "type": "n8n-nodes-base.html",
      "position": [
        3080,
        600
      ],
      "parameters": {
        "options": {},
        "operation": "extractHtmlContent",
        "extractionValues": {
          "values": [
            {
              "key": "answers",
              "cssSelector": "=<span style=\"font-weight: normal; font-style: normal; background: none;\">Well, from what I know, it depends what you're hoping to get out of it . Like , honestly, if your 15 is working fine , why bother ? I mean , my brother just got the 15 and he's already talking about the 16 , it's crazy . He's always gotta have the newest thing, you know ? Waste of money, probably . Unless there's something *really* different, a game changer , a must-have feature.. . which there probably isnt, but marketing makes you think there is! I upgraded from a 13 to a 14, and honestly? Didn't notice much difference . The camera was *slightly* better, I guess , but not a huge jump. Maybe </span>",
              "returnArray": true
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "e80004d6-b806-40cc-b91c-f04315a2cbf5",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1740,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 420,
        "height": 780,
        "content": "### 🔹 **第一部分:定义和触发搜索**"
      },
      "typeVersion": 1
    },
    {
      "id": "875b5fef-45b8-494d-9984-252731491437",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2180,
        40
      ],
      "parameters": {
        "color": 6,
        "width": 580,
        "height": 740,
        "content": "### 🔹 **第二部分:通过 Google 抓取 Quora 讨论链接**"
      },
      "typeVersion": 1
    },
    {
      "id": "198121dc-1955-4528-a4be-9f80b837e98c",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2780,
        100
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 680,
        "content": "### 🔹 **第三部分:抓取实际 Quora 答案**"
      },
      "typeVersion": 1
    },
    {
      "id": "8a48bc8d-18fc-4561-81dd-4bdb47118a29",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3240,
        140
      ],
      "parameters": {
        "color": 2,
        "width": 580,
        "height": 800,
        "content": "### 🔹 **第四部分:总结和存储洞察**"
      },
      "typeVersion": 1
    },
    {
      "id": "afb12d4e-a33e-4075-af50-6baea9823663",
      "name": "便签9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "50dca867-69b8-4f76-a72f-4d528d721da0",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        340
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 1958,
        "content": "## 🧠 **自动化论坛监控和洞察生成器**"
      },
      "typeVersion": 1
    },
    {
      "id": "ae18ba38-888b-4cf1-b6fb-6d0648d1bbdb",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3900,
        140
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 240,
        "content": "## 如果您通过此链接加入 Bright Data,我将获得少量佣金——感谢您为更多免费内容提供动力!"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f3426c3d-894c-4ba7-bb50-8ffc1f444bb7",
  "connections": {
    "Run Periodically": {
      "main": [
        [
          {
            "node": "Define Search Keyword",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Feedback Summary1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Format Thread URLs": {
      "main": [
        [
          {
            "node": "Individual Quora Threads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Feedback Summary1": {
      "main": [
        [
          {
            "node": "Save to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Answers from Threads": {
      "main": [
        [
          {
            "node": "AI Feedback Summary1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Define Search Keyword": {
      "main": [
        [
          {
            "node": "Google Search Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Search Results": {
      "main": [
        [
          {
            "node": "Links from Google HTML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Links from Google HTML": {
      "main": [
        [
          {
            "node": "Format Thread URLs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Individual Quora Threads": {
      "main": [
        [
          {
            "node": "Answers from Threads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 人工智能

需要付费吗?

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

工作流信息
难度等级
高级
节点数量17
分类1
节点类型9
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
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 查看

分享此工作流