仅限表单提交_双源音频转录 --> 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)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量22
分类2
节点类型10
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Sridevi Edupuganti

Sridevi Edupuganti

@edupuganti

I 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 上查看 →

分享此工作流