8
n8n 中文网amn8n.com

Product Hunt 发布监控器 (producthunt.com)

高级

这是一个Market Research, AI Summarization领域的自动化工作流,包含 23 个节点。主要使用 Slack, GoogleSheets, ManualTrigger, SplitInBatches, Agent 等节点。 使用 BrowserAct 和 Gemini AI 抓取并总结 Product Hunt 反馈

前置要求
  • Slack Bot Token 或 Webhook URL
  • Google Sheets API 凭证
  • Google Gemini API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "ps9FWi8KPM1vbxYU",
  "meta": {
    "instanceId": "88804d8e264d231c18413147cc92e4245b20ae7b97d774bad847556f645c8192",
    "templateCredsSetupCompleted": true
  },
  "name": "Product Hunt 发布监控器 (producthunt.com)",
  "tags": [],
  "nodes": [
    {
      "id": "01d6695a-a665-4699-8b9d-52bbed741e63",
      "name": "点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -512,
        -48
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "95abc443-7c72-4ad8-bcbb-6087f294115d",
      "name": "运行工作流任务",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        48,
        -32
      ],
      "parameters": {
        "workflowId": "56972105791704183",
        "inputParameters": {
          "parameters": [
            {
              "name": "ProductName",
              "value": "={{ $json[\"Product name\"] }}"
            },
            {
              "name": "Total_review",
              "value": "30"
            }
          ]
        },
        "additionalFields": {
          "saveBrowserData": true
        }
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5e3296c3-9211-4c57-8067-353241fa2e81",
      "name": "获取工作流任务的详情",
      "type": "n8n-nodes-browseract-workflows.browserAct",
      "position": [
        208,
        -32
      ],
      "parameters": {
        "taskId": "={{ $json.id }}",
        "operation": "getTask",
        "maxWaitTime": "=600",
        "waitForFinish": true
      },
      "credentials": {
        "browserActApi": {
          "id": "AzKMhR2eAlOjzDiJ",
          "name": "BrowserAct account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "b8ae01a0-1c97-449f-abc0-88a84d3dbe7f",
      "name": "AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        496,
        -32
      ],
      "parameters": {
        "text": "=Analyze the following text, which consists of all scraped comments from a competitor's Product Hunt launch page. Your output must be formatted into two distinct, prioritized lists.\nConstraint 1 (Output Structure): The response must contain only the two headings and their corresponding bullet points.\nConstraint 2 (Insight Quality): The points must be succinct, summarizing the overall sentiment across the entire comment block.\n\nInput Data =  {{ $json.output.string }}\n\nSummarize the feedback into two distinct lists. The points must be succinct, summarizing the overall sentiment across the entire comment block.\n\nadd the summary of the all reviews you analyzied into the \"Summary\"\nadd Summary of positive Comemnts to \"Positive\"\nadd Summary of negative comments , issues , Key Concerns & Questions , Pricing Issues, Missing Features, or Technical Problems)\n to \"Negative\"\nadd Product name to \"Product\"\nbased on teh negative and positive comments creat recomendation for similar product to be succesfull and add it \"Recomendation\"\n\n{\n\"Positive\":\"<String>\",\n\"Negative\":\"<String>\",\n\"Summary\":\"<String>\",\n\"Product\":\"<String>\",\n\"Recommendation\":\"<String>\"\n}",
        "options": {
          "systemMessage": "You are a competitive intelligence analyst specializing in startup product launches. Your sole task is to analyze raw, unfiltered community comments and extract actionable insights. Do not add any introductory or concluding commentary."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "b069b4cb-aaf8-4f7a-9889-2ecf7a86250d",
      "name": "多表:您可以连接多个表以实现有组织的数据结构",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        640,
        128
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\"Positive\":\"<String>\",\n\"Negative\":\"<String>\",\n\"Summary\":\"<String>\",\n\"Product\":\"<String>\",\n\"Recommendation\":\"<String>\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "05ffe276-bdc7-4798-a0bb-f99b0e73590b",
      "name": "在表格中追加行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        960,
        -32
      ],
      "parameters": {
        "columns": {
          "value": {
            "Product": "={{ $json.output.Product }}",
            "Summary": "={{ $json.output.Summary }}",
            "Negative": "={{ $json.output.Negative }}",
            "Positive": "={{ $json.output.Positive }}",
            "Recomendation": "={{ $json.output.Recommendation }}"
          },
          "schema": [
            {
              "id": "Product",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Product",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Positive",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Positive",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Negative",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Negative",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Recomendation",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Recomendation",
              "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/1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc/edit#gid=0",
          "cachedResultName": "Product Hunt Launch Monitor"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc/edit?usp=drivesdk",
          "cachedResultName": "BrowserAct Test 2"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wAMAqU43zjVjlpuA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "bf4b285c-0a89-4aab-b272-e72816eaf89e",
      "name": "便签 - 介绍",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        -352
      ],
      "parameters": {
        "width": 464,
        "height": 450,
        "content": "## 立即试用!"
      },
      "typeVersion": 1
    },
    {
      "id": "95d02038-8f35-4958-a6dd-2ae2a56bcfab",
      "name": "便利贴 - 使用方法",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        112
      ],
      "parameters": {
        "width": 464,
        "height": 208,
        "content": "## 使用指南"
      },
      "typeVersion": 1
    },
    {
      "id": "1c143c62-477c-4853-9202-8e353778398b",
      "name": "便利贴 - 需要帮助",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        336
      ],
      "parameters": {
        "width": 464,
        "height": 152,
        "content": "### 需要帮助?"
      },
      "typeVersion": 1
    },
    {
      "id": "e90230ba-a6dd-47ee-b8f9-26bc20e54066",
      "name": "便利贴 - 数据收集",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -224
      ],
      "parameters": {
        "color": 5,
        "width": 384,
        "height": 164,
        "content": "### 📊 1. 数据收集"
      },
      "typeVersion": 1
    },
    {
      "id": "fbdbe782-66fb-4e04-9352-0cb3a1a1dc6e",
      "name": "便利贴 - AI 分析师",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -224
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 176,
        "content": "### 🧠 2. AI 分析师"
      },
      "typeVersion": 1
    },
    {
      "id": "700360f6-be3d-41d0-abdf-45c5e7ef043c",
      "name": "便利贴 - 报告",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -224
      ],
      "parameters": {
        "color": 3,
        "height": 164,
        "content": "### 📈 3. 存储分析结果"
      },
      "typeVersion": 1
    },
    {
      "id": "a5a04463-1e36-45ff-90bb-b1dccffa97d5",
      "name": "Gemini",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        496,
        128
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "U1olizkBYhp4g9AB",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "788e5ae3-1cea-4ced-aa46-7b28cb55a9ef",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -48
      ],
      "parameters": {
        "color": 5,
        "width": 384,
        "height": 192,
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "a0d0a408-6efc-4663-8fed-4937ac8c5655",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -32
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 272,
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "10a3b803-2196-4872-b125-75bba815918c",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        -48
      ],
      "parameters": {
        "color": 3,
        "height": 192,
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "f87d4f6e-7d30-47f2-b854-99641f9c51dc",
      "name": "发送消息",
      "type": "n8n-nodes-base.slack",
      "position": [
        32,
        -400
      ],
      "webhookId": "4433fb2b-b17e-4db2-b551-f7dbb1a7bd80",
      "parameters": {
        "text": "The Product Hunt result for has been updated - Positive and negative node analyzed the recommendation added for the product",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09LWT82KHN",
          "cachedResultName": "new_product_added"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "5rQCkyObBqbHIbZA",
          "name": "Slack account"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "c90a2b9f-3647-4e3f-9540-7f298960f7c1",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -192,
        -48
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "0629faa1-796a-4593-a12d-1c07244458f5",
      "name": "获取表中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -352,
        -48
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 546839436,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc/edit#gid=546839436",
          "cachedResultName": "Product name for Hunt Lunch"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1psgSUDUPbndb6QUT6opLXuguwJ7ysqIMdKOHCcZGOPc/edit?usp=drivesdk",
          "cachedResultName": "BrowserAct Test 2"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wAMAqU43zjVjlpuA",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "d29fb7c0-db58-408f-9b23-499bbf689354",
      "name": "便利贴 - 报告1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        224,
        -416
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 148,
        "content": "### ⏰ 4. 存储分析结果"
      },
      "typeVersion": 1
    },
    {
      "id": "5cd816bf-195a-4747-9086-8d8f0a15b402",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -416
      ],
      "parameters": {
        "color": 7,
        "width": 224,
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "afa68426-7029-47a8-85f4-0bd1e53d6305",
      "name": "便利贴 - 输入与循环",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -224
      ],
      "parameters": {
        "color": 6,
        "width": 288,
        "height": 168,
        "content": "### 📋 1. 输入与循环"
      },
      "typeVersion": 1
    },
    {
      "id": "4c9d3cee-94ef-4035-a2eb-631f2c27c999",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -48
      ],
      "parameters": {
        "color": 6,
        "width": 288,
        "height": 192,
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "f29aac0e-6ce4-40ce-a54d-1e45d1dcd708",
  "connections": {
    "Gemini": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        []
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Run a workflow task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run a workflow task": {
      "main": [
        [
          {
            "node": "Get details of a workflow task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get details of a workflow task": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

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

需要付费吗?

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

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

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

作者
Madame AI Team | Kai

Madame AI Team | Kai

@madame-ai

I’m a PhD in Physics turned AI enthusiast, passionate about uncovering how AI is transforming content creation, business, and daily life.

外部链接
在 n8n.io 查看

分享此工作流