基于HackerNews帖子和GPT-4.1分析的商业创意发现
高级
这是一个Product, AI领域的自动化工作流，包含 16 个节点。主要使用 If, Set, Merge, HackerNews, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 通过GPT-4.1分析和Google Sheets从HackerNews帖子中发现商业创意
前置要求
- •Google Sheets API 凭证
- •可能需要目标 API 的认证凭证
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "5b9aff0ecdeb17791c04b93eac72e39e69151cfa63708980e5d936abe9308b8c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "34f5ab5b-1ae2-4d77-8c54-34c893b1dc7f",
"name": "当点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2080,
1060
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bfcb7e03-565e-41ff-92b7-0d46a4b7a0ba",
"name": "输出结果",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
780
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fb104b49-491f-4e0d-a6ae-705b1d937abe",
"name": "按特征筛选帖子",
"type": "n8n-nodes-base.if",
"position": [
-1660,
1060
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e8ea75f0-d9ea-4130-ab09-dc1257d61218",
"name": "选择关键字段",
"type": "n8n-nodes-base.set",
"position": [
-1420,
1040
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2c128a1d-4d1d-4689-ad45-db46935db494",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2140,
800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "259f2744-5d0f-4214-956e-5c16759df33c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
100,
600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b07873ab-8c0f-4d44-ab52-bc53a64c1b6b",
"name": "Hacker News",
"type": "n8n-nodes-base.hackerNews",
"position": [
-1860,
1060
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9e838833-f10e-4b7d-8b99-68be60c4b2d4",
"name": "合并输入",
"type": "n8n-nodes-base.merge",
"position": [
-140,
700
],
"parameters": {},
"typeVersion": 3
},
{
"id": "794c1540-ba98-4b72-9308-7dc428a89cda",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fd47e921-92f0-426d-86d2-71bdda5aef96",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-780,
1060
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "1bd78b3e-7997-463e-bf8a-e70fcfca1393",
"name": "OpenRouter 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
-820,
1280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6e8ab536-f6a9-42b4-be7c-70a0733c8401",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
-700,
1280
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "11c2e37d-49d4-4b2a-a3b6-af9d3161b7e1",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1060,
1040
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9245443f-85df-4441-8183-0e832aff5e44",
"name": "如果主题1",
"type": "n8n-nodes-base.if",
"position": [
-460,
980
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "9c5deea1-62bd-4833-8523-732517cf78af",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-560,
1280
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7f1a35a2-8002-492a-a82e-a2d5ad0200db",
"name": "分配表格标题",
"type": "n8n-nodes-base.set",
"position": [
-280,
840
],
"parameters": {},
"typeVersion": 3.4
}
],
"pinData": {},
"connections": {
"AI Agent": {
"main": [
[
{
"node": "If Topic1",
"type": "main",
"index": 0
}
]
]
},
"If Topic1": {
"main": [
[
{
"node": "Assign Sheet Headers",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Hacker News": {
"main": [
[
{
"node": "Filter Posts By Features",
"type": "main",
"index": 0
}
]
]
},
"Merge Input": {
"main": [
[
{
"node": "Output The Results",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Select Key Fields": {
"main": [
[
{
"node": "Merge Input",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Assign Sheet Headers": {
"main": [
[
{
"node": "Merge Input",
"type": "main",
"index": 1
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Filter Posts By Features": {
"main": [
[
{
"node": "Select Key Fields",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Hacker News",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 产品, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+12
23 节点Ari Nakos
销售
使用AI生成评论和邮件摘要在Reddit上推广YouTube视频
使用AI生成评论和邮件摘要在Reddit上推广YouTube视频
If
Set
Code
+13
29 节点Ari Nakos
人工智能
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
If
Set
Gmail
+14
51 节点Willemijn
产品
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
产品
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
使用正则表达式和 AI 发现隐藏的网站 API 端点
使用正则表达式和人工智能发现隐藏的网站API端点
If
Set
Html
+19
58 节点Yulia
工程
