8
n8n 中文网amn8n.com

25收集功能请求

高级

这是一个Market Research, AI Summarization领域的自动化工作流,包含 16 个节点。主要使用 Set, Code, Jira, McpClientTool, ManualTrigger 等节点。 通过AI自动化从评论到Jira的功能请求收集与分析

前置要求
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "FAL2gIZB1DbRSWZe",
  "meta": {
    "instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
    "templateCredsSetupCompleted": true
  },
  "name": "25 收集功能请求",
  "tags": [],
  "nodes": [
    {
      "id": "ea6c476a-1bd8-4fca-be69-95ae7103d0e1",
      "name": "🔘 开始手动执行",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "30863bd5-2e0b-4f52-831f-43500fa124d1",
      "name": "🖊️ 编辑目标网站 URL",
      "type": "n8n-nodes-base.set",
      "position": [
        200,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "2e6b2a54-7505-418c-a429-4429e2a4535c",
              "name": "URL",
              "type": "string",
              "value": "https://www.trustpilot.com/review/clickup.com"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "79e21868-a09d-4b05-b5ee-c96de87355bb",
      "name": "🤖 使用 Agent 抓取评论",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        440,
        0
      ],
      "parameters": {
        "text": "=Extract review text, title, date and username (if any) from the following url. Make sure to extract only those reviews that are asking for functionality for better user experiance.\n\nURL: {{ $json.URL }}",
        "options": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "93f540b0-8767-4fdb-8317-d86a56bd4a4b",
      "name": "🧩 格式化单个评论",
      "type": "n8n-nodes-base.code",
      "position": [
        860,
        0
      ],
      "parameters": {
        "jsCode": "// Get the array of reviews from the previous node's output\nconst reviews = items[0].json.output;\n\n// Return each review as a separate item so n8n can iterate over them\nreturn reviews.map(review => ({\n  json: review\n}));\n"
      },
      "typeVersion": 2
    },
    {
      "id": "a21702be-0720-4232-a283-ad2963ddd9ad",
      "name": "🗂️ 在 Jira 中创建功能工单",
      "type": "n8n-nodes-base.jira",
      "position": [
        1040,
        0
      ],
      "parameters": {
        "project": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "summary": "=Below are the feature requests from the users on trustpilot:\n\nTitle: {{ $json.title }}\nURL: {{ $json.url }}\nDate: {{ $json.date }}\nUsername: {{ $json.username }}\nFeature request: {{ $json.review_text }}",
        "issueType": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "additionalFields": {}
      },
      "typeVersion": 1
    },
    {
      "id": "5b761525-8484-4191-9206-ada550f0d494",
      "name": "🌐 Bright Data MCP 抓取器",
      "type": "n8n-nodes-mcp.mcpClientTool",
      "position": [
        560,
        260
      ],
      "parameters": {
        "toolName": "scrape_as_markdown",
        "operation": "executeTool",
        "toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
      },
      "credentials": {
        "mcpClientApi": {
          "id": "eqq94k789oJCd6jU",
          "name": "MCP Client (STDIO) account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "8374ad84-6d94-4957-b071-8bd0dcddd151",
      "name": "🧠 OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        400,
        260
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "598209e8-3618-4c54-819a-27a862674742",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -40,
        -980
      ],
      "parameters": {
        "color": 5,
        "width": 380,
        "height": 1160,
        "content": "## 🧩 **第一部分:启动和目标设置**"
      },
      "typeVersion": 1
    },
    {
      "id": "77c6fff4-321b-4bea-893c-92da762d96b3",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -1300
      ],
      "parameters": {
        "color": 3,
        "width": 320,
        "height": 1480,
        "content": "## 🤖 **第二部分:抓取和构建用户评论**"
      },
      "typeVersion": 1
    },
    {
      "id": "0e802510-132c-40ab-89c0-99c53e5b84ec",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        -1020
      ],
      "parameters": {
        "color": 6,
        "width": 360,
        "height": 1200,
        "content": "## 🧾 **第三部分:将评论转换为 Jira 任务**"
      },
      "typeVersion": 1
    },
    {
      "id": "32241104-9e0f-4959-905b-598c1c24f59f",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1820,
        -980
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "7ff8c929-3499-4bb8-85a6-263906eea08f",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1820,
        -640
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 2898,
        "content": "## 🌟 工作流标题:"
      },
      "typeVersion": 1
    },
    {
      "id": "f29c4e05-8305-45e8-81a9-01b0441e5438",
      "name": "便利贴5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1260,
        -1020
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 240,
        "content": "## 如果您通过此链接加入 Bright Data,我将获得一小笔佣金 — 感谢您支持更多免费内容!"
      },
      "typeVersion": 1
    },
    {
      "id": "1267372e-f1e9-49cb-812d-985d0f73c56f",
      "name": "自动修复输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
      "position": [
        720,
        260
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "83ca91a6-aae8-4c66-8265-016ddf461682",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        700,
        480
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8sEyPDkC5p4w4Jha",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "9a686cdb-d1bf-439a-85c1-984391421b37",
      "name": "结构化输出解析器",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        860,
        480
      ],
      "parameters": {
        "jsonSchemaExample": "[\n  {\n    \"title\": \"Accessed blocked if you don't give in to their relentless demands for more money\",\n    \"url\": \"https://www.trustpilot.com/reviews/68545e853e1c35a6c56f3cdf\",\n    \"date\": \"2025-06-19\",\n    \"username\": \"Sam Rimmer\",\n    \"review_text\": \"Useful but limited during the free trial period, as soon as I paid it got worse and all I get now is messages saying I am being charged more for using a feature that wasn't kicked and appeared free. They are trying to charge me 4 times what I agreed to.\"\n  },\n  {\n    \"title\": \"Sneaky thievery\",\n    \"url\": \"https://www.trustpilot.com/reviews/6853a8b8f4a7682e23040c20\",\n    \"date\": \"2025-06-19\",\n    \"username\": \"Marisa Taylor\",\n    \"review_text\": \"I was very excited to join ClickUp due to its features and the supposed flexibility. The package I bought was supposedly for 15 users. Long story short, when members were added to the package it was not made clear that additional seats would be automatically debited from my account - without warning.\"\n  },\n  {\n    \"title\": \"Misleading Storage Limits, Buggy System, and Clueless Support\",\n    \"url\": \"https://www.trustpilot.com/reviews/684add985445fa4b95152b78\",\n    \"date\": \"2025-06-12\",\n    \"username\": \"Dovid Kaleky\",\n    \"review_text\": \"ClickUp talks a big game, but the actual experience is frustrating and unreliable. Here’s the real issue: The system claims I’ve used 80MB of file space, but I only have about 1MB of actual files. I even deleted a bunch... but despite being well under the supposed limit, ClickUp still acts like I’m maxed out.\"\n  },\n  {\n    \"title\": \"Is it theft? ClickUp's \\\"downgrade\\\" money-taking\",\n    \"url\": \"https://www.trustpilot.com/reviews/682a3f93cc1817e84578bfb5\",\n    \"date\": \"2025-05-18\",\n    \"username\": \"CMJP\",\n    \"review_text\": \"ClickUp's \\\"downgrade\\\" policy looks very much like theft. As soon as you disable recurrent billing for an 'annual' plan, you lose all the time you prepaid for.\"\n  },\n  {\n    \"title\": \"Lots of functionality, not intuitive\",\n    \"url\": \"https://www.trustpilot.com/reviews/67fd967ce994c1648b704ffe\",\n    \"date\": \"2025-04-15\",\n    \"username\": \"James\",\n    \"review_text\": \"Looks like there is a lot of functionality here, but I find the user experience to be a bit clunky. It would be nice to see a simplified home screen and much more personalized dashboards.\"\n  }\n]\n"
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "06c4d683-3f3f-4ec3-81e2-cd251c275e87",
  "connections": {
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Auto-fixing Output Parser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "🧠 OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "🤖 Scrape Reviews using 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": "🤖 Scrape Reviews using Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "🔘 Start Manual Execution": {
      "main": [
        [
          {
            "node": "🖊️ Edit Target Site URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🌐 Bright Data MCP Scraper": {
      "ai_tool": [
        [
          {
            "node": "🤖 Scrape Reviews using Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "🖊️ Edit Target Site URL": {
      "main": [
        [
          {
            "node": "🤖 Scrape Reviews using Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧩 Format Individual Reviews": {
      "main": [
        [
          {
            "node": "🗂️ Create Feature Ticket in Jira",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🤖 Scrape Reviews using Agent": {
      "main": [
        [
          {
            "node": "🧩 Format Individual Reviews",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

工作流信息
难度等级
高级
节点数量16
分类2
节点类型10
难度说明

适合高级用户,包含 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 查看

分享此工作流