基于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": "When clicking ‘Test workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2080,
1060
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bfcb7e03-565e-41ff-92b7-0d46a4b7a0ba",
"name": "Output The Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
780
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fb104b49-491f-4e0d-a6ae-705b1d937abe",
"name": "Filter Posts By Features",
"type": "n8n-nodes-base.if",
"position": [
-1660,
1060
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e8ea75f0-d9ea-4130-ab09-dc1257d61218",
"name": "Select Key Fields",
"type": "n8n-nodes-base.set",
"position": [
-1420,
1040
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2c128a1d-4d1d-4689-ad45-db46935db494",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2140,
800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "259f2744-5d0f-4214-956e-5c16759df33c",
"name": "Sticky Note3",
"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": "Merge Input",
"type": "n8n-nodes-base.merge",
"position": [
-140,
700
],
"parameters": {},
"typeVersion": 3
},
{
"id": "794c1540-ba98-4b72-9308-7dc428a89cda",
"name": "Sticky Note2",
"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 Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
-820,
1280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6e8ab536-f6a9-42b4-be7c-70a0733c8401",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
-700,
1280
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "11c2e37d-49d4-4b2a-a3b6-af9d3161b7e1",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1060,
1040
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9245443f-85df-4441-8183-0e832aff5e44",
"name": "If Topic1",
"type": "n8n-nodes-base.if",
"position": [
-460,
980
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "9c5deea1-62bd-4833-8523-732517cf78af",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-560,
1280
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7f1a35a2-8002-492a-a82e-a2d5ad0200db",
"name": "Assign Sheet Headers",
"type": "n8n-nodes-base.set",
"position": [
-280,
840
],
"parameters": {},
"typeVersion": 3.4
}
],
"pinData": {},
"connections": {
"fd47e921-92f0-426d-86d2-71bdda5aef96": {
"main": [
[
{
"node": "9245443f-85df-4441-8183-0e832aff5e44",
"type": "main",
"index": 0
}
]
]
},
"9245443f-85df-4441-8183-0e832aff5e44": {
"main": [
[
{
"node": "7f1a35a2-8002-492a-a82e-a2d5ad0200db",
"type": "main",
"index": 0
}
],
[
{
"node": "11c2e37d-49d4-4b2a-a3b6-af9d3161b7e1",
"type": "main",
"index": 0
}
]
]
},
"b07873ab-8c0f-4d44-ab52-bc53a64c1b6b": {
"main": [
[
{
"node": "fb104b49-491f-4e0d-a6ae-705b1d937abe",
"type": "main",
"index": 0
}
]
]
},
"9e838833-f10e-4b7d-8b99-68be60c4b2d4": {
"main": [
[
{
"node": "bfcb7e03-565e-41ff-92b7-0d46a4b7a0ba",
"type": "main",
"index": 0
}
]
]
},
"6e8ab536-f6a9-42b4-be7c-70a0733c8401": {
"ai_tool": [
[
{
"node": "fd47e921-92f0-426d-86d2-71bdda5aef96",
"type": "ai_tool",
"index": 0
}
]
]
},
"11c2e37d-49d4-4b2a-a3b6-af9d3161b7e1": {
"main": [
[],
[
{
"node": "fd47e921-92f0-426d-86d2-71bdda5aef96",
"type": "main",
"index": 0
}
]
]
},
"e8ea75f0-d9ea-4130-ab09-dc1257d61218": {
"main": [
[
{
"node": "9e838833-f10e-4b7d-8b99-68be60c4b2d4",
"type": "main",
"index": 0
},
{
"node": "11c2e37d-49d4-4b2a-a3b6-af9d3161b7e1",
"type": "main",
"index": 0
}
]
]
},
"7f1a35a2-8002-492a-a82e-a2d5ad0200db": {
"main": [
[
{
"node": "9e838833-f10e-4b7d-8b99-68be60c4b2d4",
"type": "main",
"index": 1
}
]
]
},
"1bd78b3e-7997-463e-bf8a-e70fcfca1393": {
"ai_languageModel": [
[
{
"node": "fd47e921-92f0-426d-86d2-71bdda5aef96",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"fb104b49-491f-4e0d-a6ae-705b1d937abe": {
"main": [
[
{
"node": "e8ea75f0-d9ea-4130-ab09-dc1257d61218",
"type": "main",
"index": 0
}
]
]
},
"9c5deea1-62bd-4833-8523-732517cf78af": {
"ai_outputParser": [
[
{
"node": "fd47e921-92f0-426d-86d2-71bdda5aef96",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"34f5ab5b-1ae2-4d77-8c54-34c893b1dc7f": {
"main": [
[
{
"node": "b07873ab-8c0f-4d44-ab52-bc53a64c1b6b",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 产品, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+
If
Set
Code
23 节点Ari Nakos
销售
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
If
Set
Gmail
+
If
Set
Gmail
51 节点Willemijn
产品
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+
If
Set
Code
52 节点Willemijn
产品
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+
If
Set
Wait
51 节点Cyril Nicko Gaspar
销售
使用正则表达式和 AI 发现隐藏的网站 API 端点
使用正则表达式和人工智能发现隐藏的网站API端点
If
Set
Html
+
If
Set
Html
58 节点Yulia
工程
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+
Set
Code
Gmail
37 节点Derek Cheung
产品
