仅限表单提交_双源音频转录 --> AI摘要与情感分析 --> Gmail投递
高级
这是一个Document Extraction、AI Summarization领域的自动化工作流,包含 22 个节点。主要使用 If、Code、Wait、Gmail、FormTrigger 等节点。 音频转执行简报:使用AssemblyAI和GPT-4进行转录与分析
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "wtRwIBJPAbnyUbe9",
"meta": {
"instanceId": "c6db2bbd15df605c52b03ec6457f801cfcd738d259ddbb148b61be2fb93e4e29",
"templateCredsSetupCompleted": true
},
"name": "仅限表单提交_双源音频转录 --> AI 摘要与情感分析 --> Gmail 投递",
"tags": [],
"nodes": [
{
"id": "45c9716a-3d65-4fdc-bdc1-8feb130ecf38",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
-304,
-240
],
"webhookId": "8796adc6-5f2b-4859-a62e-925c59adf474",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "b1163157-dc8c-4573-a967-93a9dea55dcf",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
64,
-240
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d49d90fa-7138-48b8-a149-7dfcc86a1dd9",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "completed"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "62aec10f-d637-4cbb-b457-f9bd7a086932",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1264,
-144
],
"parameters": {
"color": 4,
"width": 736,
"height": 432,
"content": "### 执行流程 表单提交 + 本地文件"
},
"typeVersion": 1
},
{
"id": "8b93808e-44cb-4f86-aac7-c8ead6cca669",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
-368
],
"parameters": {
"color": 2,
"width": 608,
"height": 352,
"content": "### 从语音到文本生成转录稿"
},
"typeVersion": 1
},
{
"id": "bb2672af-35a4-4e59-8654-baba7b97d624",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
256,
-368
],
"parameters": {
"color": 6,
"width": 608,
"height": 352,
"content": "### 生成摘要、情感分析并发送电子邮件"
},
"typeVersion": 1
},
{
"id": "ea81f226-67de-4a39-92d8-bf315845cd28",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
-96
],
"parameters": {
"color": 5,
"width": 432,
"height": 272,
"content": "### Assembly AI"
},
"typeVersion": 1
},
{
"id": "d9e4b12c-80e2-480d-980d-379c751c9531",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-304
],
"parameters": {
"color": 5,
"width": 192,
"height": 224,
"content": "### Assembly AI"
},
"typeVersion": 1
},
{
"id": "f0d81a15-4490-47bf-8414-56c6348ec1bd",
"name": "获取转录稿",
"type": "n8n-nodes-base.httpRequest",
"position": [
-96,
-240
],
"parameters": {
"url": "=https://api.assemblyai.com/v2/transcript/{{ $json.id }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "<< PROVIDE YOUR ASSEMBLY API KEY >>"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "1957c1fe-7bc3-4db9-ab6e-f25daf24b5e7",
"name": "转录分析 (AI)",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
320,
-256
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "id",
"value": "={{ \"gpt-4.1-mini\" }}"
},
"options": {},
"messages": {
"values": [
{
"content": "You are a precise meeting analyst. Output must be valid JSON only."
},
{
"role": "system",
"content": "=Analyze the following transcript and return strict JSON:\n\nTranscript:\n{{ $node[\"Get Transcript\"].json[\"text\"] }}\n\nRequirements:\n- summary: 120–180 words, crisp and neutral\n- sentiment_label: one of [\"Positive\",\"Neutral\",\"Negative\"]\n- sentiment_score: number from -1 to 1\n- key_points: 5–8 bullet points (short phrases)\n- action_items: array of {owner, task, due?} if present, else []\n- notable_quotes: array of short verbatim quotes (<=120 chars)\n- topics: 3–6 tags\n\nReturn JSON with keys in snake_case:\n{\n \"summary\": \"...\",\n \"sentiment_label\": \"Positive\",\n \"sentiment_score\": 0.64,\n \"key_points\": [\"...\"],\n \"action_items\": [{\"owner\":\"Alice\",\"task\":\"...\",\"due\":\"2025-09-30\"}],\n \"notable_quotes\": [\"...\"],\n \"topics\": [\"...\",\"...\"]\n}\nNo preamble or Markdown—JSON only."
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "abJxg6bdFN3Tv87x",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "6c2e15bf-ee10-43b0-befc-49001a41a9e6",
"name": "发送分析邮件",
"type": "n8n-nodes-base.gmail",
"position": [
512,
-256
],
"webhookId": "176798ab-298e-4ea9-b5c7-cf72c212fbfa",
"parameters": {
"sendTo": "=<< PROVIDE YOUR GMAIL ID >>",
"message": "={{\n(() => {\n const d = $node[\"Transcript Analysis (AI)\"].json.message.content;\n\n const row = (label, value, i) =>\n `<tr style=\"background-color:${i % 2 === 0 ? '#f9f9f9' : '#ffffff'};\">\n <td style=\"padding:12px 16px;border:1px solid #ccc;font-weight:bold;width:220px;background:#f2f2f2;\">${label}</td>\n <td style=\"padding:12px 16px;border:1px solid #ccc;\">${value || ''}</td>\n </tr>`;\n\n const ul = arr => `<ul style=\"margin:0;padding-left:22px;\">${(arr || []).map(x => `<li>${x}</li>`).join('')}</ul>`;\n\n const actions = (d.action_items || []).length\n ? `<ol style=\"margin:0;padding-left:22px;\">${d.action_items.map(a =>\n `<li><strong>${a.owner || '—'}</strong>: ${a.task || ''}${a.due ? ' (Due: ' + a.due + ')' : ''}</li>`\n ).join('')}</ol>`\n : \"No explicit action items detected.\";\n\n let html = `\n <div style=\"font-family:Arial,sans-serif;font-size:16px;line-height:1.5;\">\n <h2 style=\"color:#2c3e50;border-bottom:2px solid #2c3e50;padding-bottom:6px;margin-bottom:12px;\">Transcript Analysis</h2>\n <table style=\"border-collapse:collapse;border:1px solid #ccc;width:100%;font-size:16px;\">\n <thead>\n <tr style=\"background:#2c3e50;color:#ffffff;\">\n <th style=\"padding:12px 16px;text-align:left;width:220px;\">Section</th>\n <th style=\"padding:12px 16px;text-align:left;\">Details</th>\n </tr>\n </thead>\n <tbody>\n ${row(\"Executive Summary\", d.summary, 0)}\n ${row(\"Sentiment\", `<strong>Label:</strong> ${d.sentiment_label || ''}<br/><strong>Score:</strong> ${d.sentiment_score ?? ''}`, 1)}\n ${row(\"Key Points\", ul(d.key_points), 2)}\n ${row(\"Action Items\", actions, 3)}\n ${row(\"Notable Quotes\", ul(d.notable_quotes), 4)}\n ${row(\"Topics\", (d.topics || []).join(\", \"), 5)}\n </tbody>\n </table>\n </div>\n `;\n\n return html;\n})()\n}}\n",
"options": {},
"subject": "=Transcript summary & sentiment – \n {{ $now.toISO() }} \n"
},
"credentials": {
"gmailOAuth2": {
"id": "Fy5fuwOcFQfLWPg8",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "19968c49-4e8b-41e4-89f6-54460867dbff",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1248,
-720
],
"parameters": {
"color": 3,
"width": 736,
"height": 528,
"content": "### 执行流程 表单提交 + Google Drive 链接"
},
"typeVersion": 1
},
{
"id": "65a9f81c-f35a-445e-89d4-17388693fbef",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
-448
],
"parameters": {
"color": 5,
"width": 448,
"height": 240,
"content": "### Assembly AI"
},
"typeVersion": 1
},
{
"id": "30f56c7f-ede6-4037-bce3-a5c43227e28f",
"name": "结束",
"type": "n8n-nodes-base.noOp",
"position": [
704,
-256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "00ade2c9-7a3e-4e92-abff-342c71c0bc8f",
"name": "从链接提取文件 ID",
"type": "n8n-nodes-base.code",
"position": [
-1040,
-592
],
"parameters": {
"jsCode": "const link =\n $json['Provide the URL/Link of the audio file'] ||\n $json.drive_link ||\n '';\n\nconst m = link.match(/(?:\\/d\\/|id=)([A-Za-z0-9_-]{20,})/);\nif (!m) {\n throw new Error('Could not extract Google Drive file ID from the form field.');\n}\n\nreturn [{ fileId: m[1] }];\n"
},
"typeVersion": 2
},
{
"id": "9b86268c-57e6-4778-981b-f55d587be75d",
"name": "从 Google Drive 获取文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
-784,
-592
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.fileId }}"
},
"options": {
"binaryPropertyName": "file"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "RVWXcWPinJDBkS1P",
"name": "<< PROVIDE THE DRIVE NAME >>"
}
},
"typeVersion": 3
},
{
"id": "504cfac0-19d2-4d0a-b7e8-97be9f450212",
"name": "上传文件到 AssemblyAI",
"type": "n8n-nodes-base.httpRequest",
"position": [
-928,
-368
],
"parameters": {
"url": "https://api.assemblyai.com/v2/upload",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "<< PROVIDE YOUR ASSEMBLY API KEY >>"
}
]
},
"inputDataFieldName": "file"
},
"typeVersion": 4.2
},
{
"id": "2b514d7f-49b2-4e82-aaa9-6ead8b7154bf",
"name": "上传音频文件到 AssemblyAI1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-944,
-64
],
"parameters": {
"url": "https://api.assemblyai.com/v2/upload",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "<< PROVIDE YOUR ASSEMBLY API KEY >>"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"inputDataFieldName": "Upload_file"
},
"typeVersion": 4.2
},
{
"id": "25c8cc0e-f416-4d3b-b0e6-e96388cff8e8",
"name": "向 AssemblyAI 请求转录稿",
"type": "n8n-nodes-base.httpRequest",
"position": [
-688,
-368
],
"parameters": {
"url": "https://api.assemblyai.com/v2/transcript",
"method": "POST",
"options": {},
"jsonBody": "={\n \"audio_url\": \"{{$json.upload_url}}\",\n \"speaker_labels\": false,\n \"auto_highlights\": true,\n \"punctuate\": true\n}\n",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "<< PROVIDE YOUR ASSEMBLY API KEY >>"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "78b5a8c9-8f58-41c1-bcee-b149a183d1c0",
"name": "向 AssemblyAI1 请求转录稿",
"type": "n8n-nodes-base.httpRequest",
"position": [
-704,
-64
],
"parameters": {
"url": "https://api.assemblyai.com/v2/transcript",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "audio_url",
"value": "={{ $json.upload_url }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "<< PROVIDE YOUR ASSEMBLY API KEY >>"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "9fac3888-e100-4d1c-8af7-9764a930177f",
"name": "表单提交音频",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1232,
-592
],
"webhookId": "5fcc6c50-5848-4f95-9cac-dc750a25dcc7",
"parameters": {
"options": {},
"formTitle": "Upload your Audio file",
"formFields": {
"values": [
{
"fieldLabel": "Name of the Audio file",
"requiredField": true
},
{
"fieldLabel": "Provide the URL/Link of the audio file",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "E-mail",
"placeholder": "abc@gmail.com",
"requiredField": true
}
]
},
"formDescription": "The audio file will be transcribed, Analysed and summarised. "
},
"typeVersion": 2.3
},
{
"id": "6faa3fbf-269b-4bd3-9ff3-633ba4e88603",
"name": "表单提交音频1",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1216,
48
],
"webhookId": "ee0a5a6c-d73e-42e1-8f45-91c56db65f69",
"parameters": {
"options": {},
"formTitle": "Upload your Audio file",
"formFields": {
"values": [
{
"fieldLabel": "Name of the Audio file",
"requiredField": true
},
{
"fieldType": "file",
"fieldLabel": "Upload file",
"requiredField": true,
"acceptFileTypes": "e.g .MP4"
},
{
"fieldType": "email",
"fieldLabel": "E-mail",
"placeholder": "abc@gmail.com",
"requiredField": true
}
]
},
"formDescription": "The audio file will be transcribed, Analysed and summarised. "
},
"typeVersion": 2.3
},
{
"id": "28b5a48c-2a91-4583-bd8a-aae180890768",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2016,
-752
],
"parameters": {
"width": 656,
"height": 1200,
"content": "# 立即试用!"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "719df1dc-95af-42bb-9cca-3a83b2f4b6b6",
"connections": {
"If": {
"main": [
[
{
"node": "Transcript Analysis (AI)",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Get Transcript",
"type": "main",
"index": 0
}
]
]
},
"Get Transcript": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Send Analysis Email": {
"main": [
[
{
"node": "The End",
"type": "main",
"index": 0
}
]
]
},
"Audio_on form submission": {
"main": [
[
{
"node": "Extract File ID from Link",
"type": "main",
"index": 0
}
]
]
},
"Transcript Analysis (AI)": {
"main": [
[
{
"node": "Send Analysis Email",
"type": "main",
"index": 0
}
]
]
},
"Audio_on form submission1": {
"main": [
[
{
"node": "Upload Audio file to Assembly AI1",
"type": "main",
"index": 0
}
]
]
},
"Extract File ID from Link": {
"main": [
[
{
"node": "Fetch File from Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Upload File to AssemblyAI": {
"main": [
[
{
"node": "Request Transcript from AssemblyAI",
"type": "main",
"index": 0
}
]
]
},
"Fetch File from Google Drive": {
"main": [
[
{
"node": "Upload File to AssemblyAI",
"type": "main",
"index": 0
}
]
]
},
"Upload Audio file to Assembly AI1": {
"main": [
[
{
"node": "Request Transcript from AssemblyAI1",
"type": "main",
"index": 0
}
]
]
},
"Request Transcript from AssemblyAI": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Request Transcript from AssemblyAI1": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
这是一个高级难度的工作流,适用于Document Extraction、AI Summarization等场景。适合高级用户,包含 16+ 个节点的复杂工作流
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Telegram 语音消息_音频转录--> AI 摘要和情感分析--> Gmail 投递
使用 AssemblyAI 和 GPT-4.1 转录分析 Telegram 语音消息并发送至 Gmail
If
Wait
Gmail
+7
17 节点Sridevi Edupuganti
Miscellaneous
智能文档流
使用Foxit和Diffbot提取机构信息并总结文档
If
Code
Wait
+5
16 节点Raymond Camden
Document Extraction
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
Lead Generation
照片自动OCR → AI摘要 → Google表格和Gmail通知
使用OCR.space从Google Drive图片中提取文本,通过OpenRouter AI生成摘要至表格和Gmail通知
Code
Gmail
Google Drive
+7
15 节点Tsubasa Shukuwa
Document Extraction
使用 AI 和 Gmail 自动更新 YNAB 中的亚马逊交易备注
使用 AI 和 Gmail 自动更新 YNAB 中的亚马逊交易备注
If
Set
Wait
+13
30 节点Angel Menendez
Document Extraction
使用 Gemini 和 Jina AI 自动化供应商尽职调查研究
使用 Gemini 和 Jina AI 自动化供应商尽职调查研究
If
Set
Code
+12
27 节点Adnan
Document Extraction
工作流信息
难度等级
高级
节点数量22
分类2
节点类型10
作者
Sridevi Edupuganti
@edupugantiI help customers experience 10x faster ROI through AI Automation. AI Generalist | Pursuing Generative AI & ML(IIT-G) | Google Certified Prompt Engineer | Ex-VP | Ex-Microsoft | ISB Certified CTO & AI Leader | Azure & AI Strategist | 5X Azure | n8n level2 | Wellness Advocate & Cult Ninja
外部链接
在 n8n.io 上查看 →
分享此工作流