8
n8n 中文网amn8n.com

从Google Drive中的音频文件生成会议待办事项列表并发送到Slack

中级

这是一个自动化工作流,包含 11 个节点。主要使用 Slack, DateTime, GoogleDrive, GoogleDriveTrigger, GoogleGemini 等节点。 使用Google Gemini从音频中提取会议待办事项列表并发送到Slack

前置要求
  • Slack Bot Token 或 Webhook URL
  • Google Drive API 凭证

分类

-
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "SrM0PcHuYRxXnVGS",
  "meta": {
    "instanceId": "15d6057a37b8367f33882dd60593ee5f6cc0c59310ff1dc66b626d726083b48d",
    "templateId": "4370",
    "templateCredsSetupCompleted": true
  },
  "name": "从 Google Drive 中的音频文件生成会议待办事项列表并发送到 Slack",
  "tags": [],
  "nodes": [
    {
      "id": "ab3309d9-cb3e-4b13-bb43-a214722c50b4",
      "name": "查找上传的文件",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        2016,
        368
      ],
      "parameters": {
        "event": "fileUpdated",
        "options": {
          "fileType": "all"
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1LfNfyCnJ-XVCevq32rSULZfH0Zi6KgH8",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1LfNfyCnJ-XVCevq32rSULZfH0Zi6KgH8",
          "cachedResultName": "n8n"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "vF6uQZiyvmJMiaPb",
          "name": "Google Drive account 3"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "6c7bed41-fcb2-46de-b764-f0df6bf15d72",
      "name": "下载文件",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        2240,
        368
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        },
        "options": {},
        "operation": "download"
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "vF6uQZiyvmJMiaPb",
          "name": "Google Drive account 3"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "da7cec5f-301d-456b-8ca6-f6b676579e2d",
      "name": "获取日期",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        3088,
        368
      ],
      "parameters": {
        "options": {},
        "outputFieldName": "Date"
      },
      "typeVersion": 2
    },
    {
      "id": "b51f7dc9-2973-4f03-b160-90dc3ac0c0d2",
      "name": "格式化日期",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        3312,
        368
      ],
      "parameters": {
        "date": "={{ $json.Date }}",
        "options": {},
        "operation": "formatDate"
      },
      "typeVersion": 2
    },
    {
      "id": "cf384106-5413-4a92-9bdb-cce26b2452d4",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1936,
        240
      ],
      "parameters": {
        "color": 7,
        "width": 500,
        "height": 300,
        "content": "## 下载文件"
      },
      "typeVersion": 1
    },
    {
      "id": "895c7888-8bf1-42e9-9f9c-a610c6297433",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2480,
        240
      ],
      "parameters": {
        "color": 7,
        "width": 560,
        "height": 300,
        "content": "## 生成摘要"
      },
      "typeVersion": 1
    },
    {
      "id": "29967247-97f9-4f38-8cca-b5448b7c179d",
      "name": "转录录音1",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        2592,
        368
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-2.5-pro",
          "cachedResultName": "models/gemini-2.5-pro"
        },
        "options": {},
        "resource": "audio",
        "inputType": "binary"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "p97Z2qH28ePB7flh",
          "name": "Google Gemini(PaLM) Api account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "233b4057-9713-4412-a41b-188cb933ea0c",
      "name": "分析文档",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        2816,
        368
      ],
      "parameters": {
        "text": "=What's in this document🧠 System Prompt: Action Item Extractor (JSON Output)\n\nYou are a highly specialized AI assistant focused on task extraction. Your sole responsibility is to analyze the provided meeting transcript and extract all actionable tasks (To-Do items).\n\nYour output MUST be a valid JSON array of objects. Each object in the array represents a single action item and must contain the following keys:\n- \"task_description\": A clear and concise description of the task.\n- \"assigned_to\": The name of the person responsible. If not mentioned, use null.\n- \"deadline\": The due date for the task. If not mentioned, use null. Try to format it as YYYY-MM-DD.\n- \"priority\": The priority of the task (\"High\", \"Medium\", \"Low\"). Infer this from the context. If it's unclear, default to \"Medium\".\n\nCRITICAL RULES:\n- Only output the JSON array. Do not include any explanatory text, introductory sentences, or markdown formatting like ```json.\n- If no action items are found in the transcript, output an empty array: 対象議事録なし.\n- Do not include summaries, discussion points, or any information that is not a specific, actionable task.?\n\n{{ $('Transcribe a recording1').item.json.text }}",
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-2.5-flash",
          "cachedResultName": "models/gemini-2.5-flash"
        },
        "options": {},
        "resource": "document"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "p97Z2qH28ePB7flh",
          "name": "Google Gemini(PaLM) Api account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ef304bb1-7724-407d-b813-cf3dcb8fee54",
      "name": "发送消息",
      "type": "n8n-nodes-base.slack",
      "position": [
        3536,
        368
      ],
      "webhookId": "2955c2e8-d90e-4963-b990-c1df463c958e",
      "parameters": {
        "text": "={{ $('Analyze document').item.json.content.parts[0].text }}",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C09LK8LDW79",
          "cachedResultName": "議事録ーtodoリスト"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "Mh79DVLlriDLszt9",
          "name": "Slack account 7"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "8db74eff-3909-4b07-acfc-f4ad2c165f2b",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3072,
        240
      ],
      "parameters": {
        "color": 7,
        "width": 816,
        "height": 304,
        "content": "## 格式化并发送消息"
      },
      "typeVersion": 1
    },
    {
      "id": "9335bba9-88d5-472f-86b0-caf369db834e",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        -160
      ],
      "parameters": {
        "color": 3,
        "width": 768,
        "height": 1120,
        "content": "从 Google Drive 中的音频文件生成会议待办事项列表并发送到 Slack"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "13655ad4-7ca3-487d-919a-305ae30f5589",
  "connections": {
    "Get date": {
      "main": [
        [
          {
            "node": "Format date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format date": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "Transcribe a recording1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        []
      ]
    },
    "Analyze document": {
      "main": [
        [
          {
            "node": "Get date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transcribe a recording1": {
      "main": [
        [
          {
            "node": "Analyze document",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Looking for uploading file": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

中级

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量11
分类-
节点类型6
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

外部链接
在 n8n.io 查看

分享此工作流