🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
高级
这是一个Other, AI领域的自动化工作流，包含 21 个节点。主要使用 If, Set, Merge, GoogleDrive, HttpRequest 等节点，结合人工智能技术实现智能自动化。 🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (21)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "6a5e68bcca67c4cdb3e0b698d01739aea084e1ec06e551db64aeff43d174cb23",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "bc49829b-45f2-4910-9c37-907271982f14",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2240,
-840
],
"parameters": {
"width": 780,
"height": 540,
"content": "### 5. 需要更多详细信息吗？"
},
"typeVersion": 1
},
{
"id": "f0defc20-f099-4c7c-83a7-bb687b86a6b7",
"name": "Google翻译",
"type": "n8n-nodes-base.googleTranslate",
"notes": "Translation -> 中文",
"position": [
-3500,
-420
],
"parameters": {
"text": "={{ $json.initialText }}",
"translateTo": "zh-CN"
},
"notesInFlow": true,
"typeVersion": 2
},
{
"id": "588d011c-d7e0-4b31-87be-d0c7ff6bf4b7",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "Pinyin + Example",
"position": [
-3080,
-380
],
"parameters": {
"text": "={{ $json.translatedText }}",
"options": {
"systemMessage": "# Role\nYou are a helpful translation agent that will help users to extract the pinyin from Chinese characters to create flashcard for language learning.\n\n# Context\nYou will receive a word or sentence in simplified Chinese characters; you are expected to extract the pinyin and generate a simple sentence in Chinese to illustrate the sense of the word. \n\n# Tasks\n1. Generate the pinyin of the characters presented\n2. Propose a short sentence in mandarin to illustrate the definition of the word.\n\n# Notes\n- Generate the output in JSON format following the example below:\n{\"pinyin\": \"Cāngkù\",\n\"sentence\": \"卡车抵达仓库。\"}\n\n- Be very diligent in thinking about the task being asked from you.\n- Generate concise sentences as they need to fit in flash cards.\n"
},
"promptType": "define",
"hasOutputParser": true
},
"notesInFlow": true,
"typeVersion": 1.7
},
{
"id": "cc04e0be-0eea-4d92-a85f-10bd75c03081",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-3080,
-200
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "d98262f4-9066-420b-a440-fdbc83ca0ef0",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-2900,
-200
],
"parameters": {
"jsonSchemaExample": "{\n \"pinyin\": \"Cāngkù\",\n \"sentence\": \"货物存放在仓库里。\"\n}"
},
"typeVersion": 1.2
},
{
"id": "e4ed388f-7520-4df2-8e37-d2b85b1ce532",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-2580,
-400
],
"parameters": {
"mode": "combineBySql"
},
"typeVersion": 3
},
{
"id": "c1431b36-77ee-4b50-a4e1-05489e998894",
"name": "触发添加行",
"type": "n8n-nodes-base.googleSheetsTrigger",
"notes": "Write a word in a new row",
"position": [
-3920,
-420
],
"parameters": {
"event": "rowAdded",
"options": {
"valueRender": "UNFORMATTED_VALUE",
"dateTimeRenderOption": "SERIAL_NUMBER"
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1051887098,
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_GOOGLE_SHEET_ID>",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "4bafdddc-3c7f-40d4-ab17-75c6728bd5a3",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"notes": "If cell empty, do nothing",
"position": [
-3500,
-260
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1
},
{
"id": "adabd9e0-13de-409b-a3ce-3c76c9624fc0",
"name": "上传图片",
"type": "n8n-nodes-base.googleDrive",
"position": [
-2740,
460
],
"parameters": {
"name": "={{ $('Trigger Added Row').item.json.initialText }}.jpeg",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive",
"cachedResultUrl": "https://drive.google.com/drive/my-drive",
"cachedResultName": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "url",
"value": ""
}
},
"typeVersion": 3
},
{
"id": "9cfa6722-ff5e-4ee2-a4ca-2b4175767c84",
"name": "获取图片",
"type": "n8n-nodes-base.httpRequest",
"position": [
-2900,
460
],
"parameters": {
"url": "={{ $json.photos[0].src.medium }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "4bfa5fc7-dd76-4611-916e-5b33a0a9acdb",
"name": "调用API Pexels",
"type": "n8n-nodes-base.httpRequest",
"position": [
-3080,
460
],
"parameters": {
"url": "https://api.pexels.com/v1/search",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "={{ $('Trigger Added Row').item.json.initialText }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "<PEXELS_API_KEY>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "01c5dc70-3cf5-483e-bad7-4814ca7b1f97",
"name": "获取初始文本",
"type": "n8n-nodes-base.set",
"position": [
-3240,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "80661db0-175f-4346-a95b-5d1e73f82fb8",
"name": "entry",
"type": "string",
"value": "={{ $json.initialText }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7630fc44-3a0c-442b-9c3b-17bd831cdb50",
"name": "提取图片链接",
"type": "n8n-nodes-base.set",
"position": [
-2580,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "019a529f-9447-4d49-9a91-04666d2c8fb6",
"name": "image_link",
"type": "string",
"value": "={{ $json.webContentLink }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "69645673-87c7-48cc-982f-b4e747fdf1ec",
"name": "最终合并",
"type": "n8n-nodes-base.merge",
"position": [
-2100,
20
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3
},
{
"id": "1ee7aca7-5b9d-424f-b49f-2ee9ca7fafdc",
"name": "提取拼音和示例",
"type": "n8n-nodes-base.set",
"position": [
-2780,
-380
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c67839b8-abd5-47c9-b1e2-db599fbb5e9e",
"name": "phonetic",
"type": "string",
"value": "={{ $json.output.pinyin }}"
},
{
"id": "3983d009-85c4-46fd-8651-90462249f164",
"name": "example",
"type": "string",
"value": "={{ $json.output.sentence }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "baee6926-5031-43fa-94b8-8c7d36a9a6f0",
"name": "提取字段",
"type": "n8n-nodes-base.set",
"notes": "Initial text and its translation",
"position": [
-3000,
-540
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6d08361f-bb45-40a0-9934-f1e7bf90a171",
"name": "initialText",
"type": "string",
"value": "={{ $('Trigger Added Row').item.json.initialText }}"
},
{
"id": "0a64ccc0-5a8b-4925-9111-6b7e8c0f9368",
"name": "translatedText",
"type": "string",
"value": "={{ $json.translatedText }}"
},
{
"id": "84a2cfbd-a6da-4a94-a26c-153cbf73fefb",
"name": "image_name",
"type": "string",
"value": "={{ $('Trigger Added Row').item.json.initialText }}.jpeg"
}
]
}
},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "1f86fb6b-3ec7-4ea3-9748-a69db5d0c9f2",
"name": "初始文本为空？",
"type": "n8n-nodes-base.if",
"notes": "Verify is the word is not empty",
"position": [
-3700,
-420
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "266614ab-f9e3-486d-929f-ce14ce67e5ff",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.initialText }}",
"rightValue": ""
}
]
}
},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "5c1afb76-3b5a-4c35-80b9-4a05f2d2aa2d",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3280,
140
],
"parameters": {
"color": 7,
"width": 820,
"height": 480,
"content": "## 3. 从Pexels免费数据库检索图片"
},
"typeVersion": 1
},
{
"id": "ebacc192-9dba-4cab-ae0f-d5a2e885c208",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3960,
-780
],
"parameters": {
"color": 7,
"width": 600,
"height": 680,
"content": "## 1. Google表格触发器和使用API翻译"
},
"typeVersion": 1
},
{
"id": "5bdeb1de-d535-484d-83d6-12d72d8e5ba7",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3220,
-800
],
"parameters": {
"color": 7,
"width": 760,
"height": 740,
"content": "## 2. 简单的AI代理获取音标并生成例句"
},
"typeVersion": 1
},
{
"id": "4f3f2a71-f137-4e91-8b1e-8a7342bac293",
"name": "在表格中添加结果",
"type": "n8n-nodes-base.googleSheets",
"notes": "initialtext, translation, sentence",
"position": [
-1940,
20
],
"parameters": {
"columns": {
"value": {
"phonetic": "={{ $json.phonetic }}",
"sentence": "={{ $json.example }}",
"image_link": "={{ $json.image_name }}",
"image_name": "={{ $json.image_link }}",
"initialText": "={{ $json.initialText }}",
"translatedText": "={{ $json.translatedText }}"
},
"schema": [
{
"id": "initialText",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "initialText",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "translatedText",
"type": "string",
"display": true,
"required": false,
"displayName": "translatedText",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phonetic",
"type": "string",
"display": true,
"required": false,
"displayName": "phonetic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentence",
"type": "string",
"display": true,
"required": false,
"displayName": "sentence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_name",
"type": "string",
"display": true,
"required": false,
"displayName": "image_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image_link",
"type": "string",
"display": true,
"required": false,
"displayName": "image_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"initialText"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "<YOUR_GOOGLE_SHEET_TAB_ID>",
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<YOUR_GOOGLE_SHEET_ID>",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"notesInFlow": true,
"typeVersion": 4.5
},
{
"id": "42a20d7e-03bf-4f4e-877b-04ff185cbf1c",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2220,
-280
],
"parameters": {
"color": 7,
"width": 580,
"height": 460,
"content": "## 4. 合并结果以更新Google表格"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Final Merge",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Extract Pinyin and Example",
"type": "main",
"index": 0
}
]
]
},
"Final Merge": {
"main": [
[
{
"node": "Add Results in Sheet",
"type": "main",
"index": 0
}
]
]
},
"Get Picture": {
"main": [
[
{
"node": "Upload Picture",
"type": "main",
"index": 0
}
]
]
},
"Extract Fields": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Upload Picture": {
"main": [
[
{
"node": "Extract Image Link",
"type": "main",
"index": 0
}
]
]
},
"Call API Pexels": {
"main": [
[
{
"node": "Get Picture",
"type": "main",
"index": 0
}
]
]
},
"Google Translate": {
"main": [
[
{
"node": "Extract Fields",
"type": "main",
"index": 0
},
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Take initialText": {
"main": [
[
{
"node": "Call API Pexels",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Trigger Added Row": {
"main": [
[
{
"node": "initialText is empty?",
"type": "main",
"index": 0
},
{
"node": "Take initialText",
"type": "main",
"index": 0
}
]
]
},
"Extract Image Link": {
"main": [
[
{
"node": "Final Merge",
"type": "main",
"index": 1
}
]
]
},
"initialText is empty?": {
"main": [
[
{
"node": "Google Translate",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Extract Pinyin and Example": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
音乐生成工作流
使用 Suno API、Flux、Runway 和 Creatomate 生成 AI 歌曲和音乐视频
Set
Wait
Merge
+16
60 节点Joseph
其他
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
🗞️ AI驱动的可持续性营销简报（使用Gmail、GPT-4o）
If
Set
Code
+12
21 节点Samir Saci
人工智能
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
AI 代理餐厅 [模板]
🤖 WhatsApp、Instagram 和 Messenger 的 AI 餐厅助手
If
N8n
Set
+37
239 节点Amanda Benks
其他
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
工作流信息
难度等级
高级
节点数量21
分类2
节点类型13
作者
Samir Saci
@samirsaciAutomation, AI and Analytics for Supply Chain & Business Optimization Helping businesses streamline operations using n8n, AI agents, and data science to enhance efficiency and sustainability. Linkedin: www.linkedin.com/in/samir-saci
外部链接
在 n8n.io 查看 →
分享此工作流