从HackerNews提取结构化数据，使用Google Gemini导出到Google Docs
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 Set, GoogleDocs, HackerNews, HttpRequest, ManualTrigger 等节点。 使用Gemini 2.0 Flash提取和转换HackerNews数据到Google Docs
前置要求
- •可能需要目标 API 的认证凭证
- •Google Gemini API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "qgOiQsPSKD08eiB3",
"meta": {
"instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
"templateCredsSetupCompleted": true
},
"name": "Extract Structured Data from HackerNews, Export to Google Docs with Google Gemini",
"tags": [
{
"id": "Kujft2FOjmOVQAmJ",
"name": "Engineering",
"createdAt": "2025-04-09T01:31:00.558Z",
"updatedAt": "2025-04-09T01:31:00.558Z"
},
{
"id": "ZOwtAMLepQaGW76t",
"name": "Building Blocks",
"createdAt": "2025-04-13T15:23:40.462Z",
"updatedAt": "2025-04-13T15:23:40.462Z"
},
{
"id": "ddPkw7Hg5dZhQu2w",
"name": "AI",
"createdAt": "2025-04-13T05:38:08.053Z",
"updatedAt": "2025-04-13T05:38:08.053Z"
}
],
"nodes": [
{
"id": "2f6e390d-47d2-46c0-b032-00e1541a8def",
"name": "When clicking ‘Execute workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-380,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "da17296e-a0b0-423f-8f6a-6636f77ff79e",
"name": "Hacker News",
"type": "n8n-nodes-base.hackerNews",
"position": [
60,
0
],
"parameters": {
"limit": "={{ $json.Count }}",
"resource": "all",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "8481d533-2ef1-4e97-afe1-8f182d17b390",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
280,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "5d88db37-0e3b-4900-af10-78a4f7152231",
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
940,
240
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "YeO7dHZnuGBVQKVZ",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "0fcf5b56-87f8-4dca-9478-7f0753c195e7",
"name": "Create a Google Doc",
"type": "n8n-nodes-base.googleDocs",
"position": [
1320,
20
],
"parameters": {
"title": "={{ $('Set the url, author').item.json.author }}-HackerNews",
"folderId": "default"
},
"credentials": {
"googleDocsOAuth2Api": {
"id": "39XPsztp1DX0svZQ",
"name": "Google Docs account"
}
},
"executeOnce": false,
"retryOnFail": true,
"typeVersion": 2,
"alwaysOutputData": false
},
{
"id": "2855e7e7-ea99-4acc-901a-54bffa7b3113",
"name": "Update Google Docs",
"type": "n8n-nodes-base.googleDocs",
"position": [
1500,
20
],
"parameters": {
"actionsUi": {
"actionFields": [
{
"text": "={{ $('Extract Human Readable Data').item.json.text }}",
"action": "insert"
}
]
},
"operation": "update",
"documentURL": "={{ $json.id }}"
},
"credentials": {
"googleDocsOAuth2Api": {
"id": "39XPsztp1DX0svZQ",
"name": "Google Docs account"
}
},
"typeVersion": 2
},
{
"id": "ef59d4a1-4176-4702-996d-5a710b432b4b",
"name": "Set the Input Fields",
"type": "n8n-nodes-base.set",
"position": [
-160,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "52ddafbb-536f-45d6-9697-7ddf5b9b3869",
"name": "Count",
"type": "string",
"value": "5"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "aa74a371-94cf-4a0b-93d9-fd503f1abbed",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-320
],
"parameters": {
"content": "## Step 1\n\nSet the input field with the \"Count\", how many record needs to be feteched."
},
"typeVersion": 1
},
{
"id": "79674295-f331-4e5b-81d4-09d45aedb883",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-320
],
"parameters": {
"content": "## Step 2\n\nSet the Google Gemini Credentials as part of the human readable data extraction"
},
"typeVersion": 1
},
{
"id": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
"name": "Extract Human Readable Data",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
980,
20
],
"parameters": {
"text": "=Extract a human readable content. \n\nHere's the context :\n\n{{ $json.data }}",
"batching": {},
"promptType": "define"
},
"retryOnFail": true,
"typeVersion": 1.7
},
{
"id": "d922ad6e-0959-465f-810f-3f0e8d8a3626",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-400
],
"parameters": {
"color": 6,
"width": 540,
"height": 240,
"content": "## Extract Structured Data from Hacker News, Export to Google Docs with Google Gemini\n\nHacker news data extraction with Google Gemini. Export the clean data to Google Document."
},
"typeVersion": 1
},
{
"id": "79f3eca6-df7d-4e72-816e-b17452f476b5",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
-320
],
"parameters": {
"content": "## Step 3\n\nSet the Google Document Credentials for the Hacker News data export"
},
"typeVersion": 1
},
{
"id": "b3cfee88-735c-4474-b7c0-75511d44e26c",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-140
],
"parameters": {
"color": 5,
"width": 1060,
"height": 520,
"content": "## Hacker News Data Extraction"
},
"typeVersion": 1
},
{
"id": "36302c89-82a4-4098-9ca6-7822bb4d6c33",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-140
],
"parameters": {
"color": 3,
"width": 540,
"height": 120,
"content": "## LLM Usages\n\nGoogle Gemini -> Gemini 2.0 Flash Exp Model"
},
"typeVersion": 1
},
{
"id": "80c3a993-6c82-43c9-9612-e20e989012ef",
"name": "Set the url, author",
"type": "n8n-nodes-base.set",
"position": [
500,
20
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "267f21f5-d483-4e74-9773-b1d8a02dd984",
"name": "author",
"type": "string",
"value": "={{ $json.author }}"
},
{
"id": "667a3ffb-a07c-4f66-b253-a7c64b2aa8e0",
"name": "url",
"type": "string",
"value": "={{ $json._highlightResult.url.value }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ad6eb942-17a1-48af-9d41-f728c9127106",
"name": "Create an HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
20
],
"parameters": {
"url": "={{ $json.url }}",
"options": {}
},
"retryOnFail": true,
"typeVersion": 4.2,
"alwaysOutputData": true
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "640bfa35-72c3-4d4d-8e38-a98fee2248e9",
"connections": {
"da17296e-a0b0-423f-8f6a-6636f77ff79e": {
"main": [
[
{
"node": "8481d533-2ef1-4e97-afe1-8f182d17b390",
"type": "main",
"index": 0
}
]
]
},
"8481d533-2ef1-4e97-afe1-8f182d17b390": {
"main": [
[],
[
{
"node": "80c3a993-6c82-43c9-9612-e20e989012ef",
"type": "main",
"index": 0
}
]
]
},
"2855e7e7-ea99-4acc-901a-54bffa7b3113": {
"main": [
[
{
"node": "8481d533-2ef1-4e97-afe1-8f182d17b390",
"type": "main",
"index": 0
}
]
]
},
"0fcf5b56-87f8-4dca-9478-7f0753c195e7": {
"main": [
[
{
"node": "2855e7e7-ea99-4acc-901a-54bffa7b3113",
"type": "main",
"index": 0
}
]
]
},
"80c3a993-6c82-43c9-9612-e20e989012ef": {
"main": [
[
{
"node": "ad6eb942-17a1-48af-9d41-f728c9127106",
"type": "main",
"index": 0
}
]
]
},
"ef59d4a1-4176-4702-996d-5a710b432b4b": {
"main": [
[
{
"node": "da17296e-a0b0-423f-8f6a-6636f77ff79e",
"type": "main",
"index": 0
}
]
]
},
"ad6eb942-17a1-48af-9d41-f728c9127106": {
"main": [
[
{
"node": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
"type": "main",
"index": 0
}
]
]
},
"5d88db37-0e3b-4900-af10-78a4f7152231": {
"ai_languageModel": [
[
{
"node": "80ed14eb-6ead-46d8-81d0-5502cb5f44db",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"80ed14eb-6ead-46d8-81d0-5502cb5f44db": {
"main": [
[
{
"node": "0fcf5b56-87f8-4dca-9478-7f0753c195e7",
"type": "main",
"index": 0
}
]
]
},
"2f6e390d-47d2-46c0-b032-00e1541a8def": {
"main": [
[
{
"node": "ef59d4a1-4176-4702-996d-5a710b432b4b",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富工具
Set
Code
Wait
+
Set
Code
Wait
29 节点Ranjan Dailata
潜在客户开发
竞争对手情报代理：SERP监控+Thordata+OpenAI的摘要洞察
竞争对手情报代理：SERP 监控 + Thordata + OpenAI 摘要洞察
Set
Merge
Google Sheets
+
Set
Merge
Google Sheets
23 节点Ranjan Dailata
市场调研
通过Bright Data提取、总结和分析亚马逊产品降价情况
使用Bright Data和Google Gemini提取、总结和分析亚马逊降价信息
Set
Wait
Merge
+
Set
Wait
Merge
26 节点Ranjan Dailata
人工智能
Google SERP追踪器+趋势与推荐（使用Bright Data和Google Gemini）
使用Bright Data和Google Gemini的Google搜索结果页面追踪、趋势分析和推荐
Set
Code
Http Request
+
Set
Code
Http Request
23 节点Ranjan Dailata
人工智能
Indeed公司数据抓取与Airtable、Bright Data和Google Gemini的汇总
使用Airtable、Bright Data和Google Gemini进行Indeed数据抓取与汇总
If
Set
Wait
+
If
Set
Wait
19 节点Ranjan Dailata
人力资源
法律案例研究提取器
法律案例研究提取器，使用Bright Data MCP和Google Gemini的数据挖掘器
Set
Code
Wait
+
Set
Code
Wait
22 节点Ranjan Dailata
人工智能
工作流信息
难度等级
高级
节点数量16
分类2
节点类型9
作者
Ranjan Dailata
@ranjancseA Professional based out of India specialized in handling AI-powered automations. Contact me at ranjancse@gmail.com
外部链接
在 n8n.io 查看 →
分享此工作流