模板演示-chatgpt-图片-1-带-drive-和-sheet副本
高级
这是一个Design, AI, IT Ops领域的自动化工作流，包含 16 个节点。主要使用 Set, SplitOut, Aggregate, GoogleDrive, HttpRequest 等节点，结合人工智能技术实现智能自动化。 使用GPT-image-1生成图像并存储到Google Drive，包含成本跟踪
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "0GCQ1fO3d5MBdKmi",
"meta": {
"instanceId": "fddb3e91967f1012c95dd02bf5ad21f279fc44715f47a7a96a33433621caa253"
},
"name": "模板演示-chatgpt-图片-1-带-drive-和-sheet 副本",
"tags": [],
"nodes": [
{
"id": "7d78d4e3-cbb3-4f32-82d9-73c9d7f6c892",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"disabled": true,
"position": [
-480,
-245
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b32b61bb-c837-4697-9742-a1bb2854b628",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
-260,
-120
],
"parameters": {
"url": "https://api.openai.com/v1/images/generations",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "predefinedCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "model",
"value": "gpt-image-1"
},
{
"name": "prompt",
"value": "={{ $json.chatInput }}"
},
{
"name": "output_format",
"value": "jpeg"
},
{
"name": "quality",
"value": "low"
},
{
"name": "output_compression",
"value": "={{parseInt('80')}}"
},
{
"name": "size",
"value": "1024x1024"
},
{
"name": "n",
"value": "={{parseInt('1')}}"
},
{
"name": "moderation",
"value": "low"
}
]
},
"nodeCredentialType": "openAiApi"
},
"credentials": {
"openAiApi": {
"id": "GgwYNKMKKqKJICYO",
"name": "OpenAi account - Image"
}
},
"typeVersion": 4.2
},
{
"id": "0ead70d0-9e3b-4f19-afee-b5d4a7b532e9",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
860,
-20
],
"parameters": {
"name": "=chatgpt_created_by_n8n_{{ $('HTTP Request').item.json.created }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1sIbMHDtcOafBVdCq0gTEuGvnT63s8Fdy",
"cachedResultUrl": "https://drive.google.com/drive/folders/1sIbMHDtcOafBVdCq0gTEuGvnT63s8Fdy",
"cachedResultName": "n8n-demo-gpt_image_1"
},
"inputDataFieldName": "=data"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "iQdqjdvLVh5ldUIq",
"name": "Personal-Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "a76c4340-9f34-49d1-a831-1ba4515933ee",
"name": "分离输出",
"type": "n8n-nodes-base.splitOut",
"position": [
-40,
-120
],
"parameters": {
"options": {
"includeBinary": true
},
"fieldToSplitOut": "data"
},
"typeVersion": 1
},
{
"id": "c8090e15-b9b9-4999-89f0-97d45e6176d6",
"name": "转换为文件",
"type": "n8n-nodes-base.convertToFile",
"position": [
640,
-20
],
"parameters": {
"options": {
"fileName": "={{ $now.format(\"yyyyMMddHHmmSSS\") }}"
},
"operation": "toBinary",
"sourceProperty": "b64_json"
},
"typeVersion": 1.1
},
{
"id": "692a71fb-6fe3-4728-a588-f9283f5ab968",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
200,
-20
],
"parameters": {
"options": {
"reset": false
},
"batchSize": "=1"
},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "dfa88c15-4d38-4670-9c5a-4e52a9ce9d33",
"name": "编辑字段-文件名",
"type": "n8n-nodes-base.set",
"position": [
420,
-20
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "10e6d39e-c44c-4db4-bf88-806b2f36c09f",
"name": "file_name",
"type": "string",
"value": "={{ $now.format(\"yyyyMMddHHmmSSS\") }}"
},
{
"id": "c2610584-aafa-4d90-8977-399e49015c32",
"name": "b64_json",
"type": "string",
"value": "={{ $json.b64_json }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c34c1a91-2601-4750-8134-d31cf377c349",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
1080,
-20
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "dcfa49d6-a8ed-43a2-9aaa-86751f34e61d",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "d2f7f22d-9453-4b61-bd46-fb3e8d5ad4d8",
"name": "webViewLink",
"type": "string",
"value": "={{ $json.webViewLink }}"
},
{
"id": "b8cf5a41-e354-416e-b548-8d1a274873e0",
"name": "thumbnailLink",
"type": "string",
"value": "={{ $json.thumbnailLink }}"
},
{
"id": "76c11a24-087c-4a6c-a5b4-8901e9436786",
"name": "file_name",
"type": "string",
"value": "={{ $('Edit Fields-file_name').item.json.file_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "6bd8f7dc-1006-4d7f-b3eb-0a3aaa1b9a84",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1300,
-20
],
"parameters": {
"columns": {
"value": {
"image": "={{ $json.webViewLink }}",
"prompt": "={{ $('When chat message received').item.json.chatInput }}",
"image_thumb": "==IMAGE(\"{{ $('Edit Fields1').item.json.thumbnailLink }}\")"
},
"schema": [
{
"id": "prompt",
"type": "string",
"display": true,
"required": false,
"displayName": "prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image",
"type": "string",
"display": true,
"required": false,
"displayName": "image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_thumb",
"type": "string",
"display": true,
"required": false,
"displayName": "image_thumb",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"cellFormat": "USER_ENTERED"
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88/edit#gid=0",
"cachedResultName": "工作表1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88/edit?usp=drivesdk",
"cachedResultName": "n8n-chatgpt-image-1-model"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tufEzuSTEveV3tuA",
"name": "(Personal)Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "8ee28143-d9e7-4d14-929f-c9b6592c366e",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-480,
-45
],
"webhookId": "f64b2006-672a-4ad6-8c30-428b76f5a332",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "1e687fde-8465-4490-8738-c9832904f2b5",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
-400
],
"parameters": {
"columns": {
"value": {
"prompt": "={{ $('When chat message received').item.json.chatInput }}",
"datetime": "={{ $('HTTP Request').item.json.created.toDateTime('s').format('yyyy-MM-dd HH:mm:ss') }}",
"input token": "={{ $('HTTP Request').item.json.usage.input_tokens }}",
"output token": "={{ $('HTTP Request').item.json.usage.output_tokens }}",
"input estimated price": "={{ ( ($('HTTP Request').item.json.usage.input_tokens || 0) * 10 / 1000000 ).toFixed(6) }}",
"total estimated price": "={{ \n (\n (($('HTTP Request').item.json.usage.input_tokens || 0) * 10 / 1000000) +\n (($('HTTP Request').item.json.usage.output_tokens || 0) * 40 / 1000000)\n ).toFixed(6)\n}}",
"output estimated price": "={{ ( ($('HTTP Request').item.json.usage.output_tokens || 0) * 40 / 1000000 ).toFixed(6) }}"
},
"schema": [
{
"id": "prompt",
"type": "string",
"display": true,
"required": false,
"displayName": "prompt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "datetime",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "datetime",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input token",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "input token",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "input estimated price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "input estimated price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "output token",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "output token",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "output estimated price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "output estimated price",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "total estimated price",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "total estimated price",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 929800828,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88/edit#gid=929800828",
"cachedResultName": "usage"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11K1tui8itMzcSZqHOmzvFnM0G-ihn1uiLUZ_o478j88/edit?usp=drivesdk",
"cachedResultName": "n8n-chatgpt-image-1-model"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "tufEzuSTEveV3tuA",
"name": "(Personal)Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "5e1f6dd3-6c1a-4838-86c7-2a3c0cf05c3d",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
480,
-400
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "f14edb71-0778-40dc-9f2d-4cfc72b8a351",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-600
],
"parameters": {
"color": 7,
"width": 340,
"height": 240,
"content": "## 由darrell_tw_创建"
},
"typeVersion": 1
},
{
"id": "6bbe2346-287b-491d-bf20-a76d39a6e297",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-340
],
"parameters": {
"width": 660,
"height": 480,
"content": "## 使用聊天输入提示词进行图片生成"
},
"typeVersion": 1
},
{
"id": "8dd6607a-16cf-424d-902a-04c43e68f424",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-200
],
"parameters": {
"color": 2,
"width": 1260,
"height": 420,
"content": "## 使用循环处理图片数组数据"
},
"typeVersion": 1
},
{
"id": "f8d0819a-e38a-4f7a-aa79-594ebca465a0",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-480
],
"parameters": {
"color": 6,
"width": 480,
"height": 260,
"content": "## 处理完成后，将成本保存到 Sheet"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "cf533114-4aa9-4b06-8247-3c06f9dcbc79",
"connections": {
"Aggregate": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Convert to File": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Aggregate",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields-file_name",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields-file_name": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"When clicking 'Test workflow'": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 设计, 人工智能, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
n8napi-检查使用哪个模型的工作流
检查工作流中使用的AI模型
N8n
Set
Filter
+5
12 节点darrell_tw
人工智能
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
AI智能助手：与Supabase存储和Google Drive文件对话
AI智能助手：与Supabase存储和Google Drive文件对话
If
Set
Wait
+20
62 节点Mark Shcherbakov
工程
使用 Qdrant 的完整 RAG 系统，带自动来源引用
使用Qdrant、Gemini和OpenAI构建带自动引用的RAG系统
Set
Code
Wait
+15
29 节点Davide
人工智能
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
工程
使用Apify→Google Sheets/CSV提取并丰富LinkedIn评论为潜在客户
使用Apify→Google Sheets/CSV提取并丰富LinkedIn评论为潜在客户
If
Set
Code
+10
39 节点Saverflow AI
销售
工作流信息
难度等级
高级
节点数量16
分类3
节点类型11
作者
darrell_tw
@darrelltwMartech Engineer with automation. here is my website: https://www.darrelltw.com/
外部链接
在 n8n.io 查看 →
分享此工作流