8
n8n 中文网amn8n.com

自动保存Zoom录制到Google云端硬盘并在Airtable记录会议

中级

这是一个File Management, Multimodal AI领域的自动化工作流,包含 7 个节点。主要使用 Code, Webhook, Airtable, GoogleDrive, HttpRequest 等节点。 自动保存Zoom录制到Google云端硬盘并在Airtable记录会议

前置要求
  • HTTP Webhook 端点(n8n 会自动生成)
  • Airtable API Key
  • Google Drive API 凭证
  • 可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "f57bfeb3-65d7-45c3-85fa-45f4c0e94d9f",
      "name": "创建或更新记录",
      "type": "n8n-nodes-base.airtable",
      "position": [
        944,
        400
      ],
      "parameters": {
        "base": {
          "__rl": true,
          "mode": "list",
          "value": "appCV1g03wAMk91ZL",
          "cachedResultUrl": "https://airtable.com/appCV1g03wAMk91ZL",
          "cachedResultName": "contacts"
        },
        "table": {
          "__rl": true,
          "mode": "list",
          "value": "tblvmGsSf7xTDtIwS",
          "cachedResultUrl": "https://airtable.com/appCV1g03wAMk91ZL/tblvmGsSf7xTDtIwS",
          "cachedResultName": "Zoom Meeting Log"
        },
        "columns": {
          "value": {
            "Host": "={{ $json.host }}",
            "Topic": "={{ $json.topic }}",
            "File Size": "={{ $json.file_type }}",
            "File Type": "Other",
            "Meeting ID": "={{ $json.meeting_id }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "id",
              "defaultMatch": true
            },
            {
              "id": "Meeting ID",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Meeting ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Topic",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Topic",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Host",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Host",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "File Type",
              "type": "options",
              "display": true,
              "options": [
                {
                  "name": "MP4",
                  "value": "MP4"
                },
                {
                  "name": "M4A",
                  "value": "M4A"
                },
                {
                  "name": "Other",
                  "value": "Other"
                }
              ],
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "File Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "File Size",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "File Size",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Google Drive Saved",
              "type": "options",
              "display": true,
              "options": [
                {
                  "name": "Yes",
                  "value": "Yes"
                },
                {
                  "name": "No",
                  "value": "No"
                }
              ],
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Google Drive Saved",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Timestamp",
              "type": "dateTime",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Timestamp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Related Contact",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "Related Contact",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "upsert"
      },
      "credentials": {
        "airtableTokenApi": {
          "id": "ungHc0pnbSXnUtl8",
          "name": "full access"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "a3d54194-cfb0-4497-8600-95399203959d",
      "name": "记录结果",
      "type": "n8n-nodes-base.code",
      "position": [
        768,
        400
      ],
      "parameters": {
        "jsCode": "// Collect metadata + Drive result\nconst driveFile = $input.first().json;\nconst prev = $('Normalize Recording Data').item.json;\n\nreturn {\n  json: {\n    ...prev,\n    saved_to_drive: true,\n    drive_file_id: driveFile.id,\n    drive_link: driveFile.webViewLink\n  }\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "03064eac-432f-452b-8170-6e661b7f39b0",
      "name": "上传到 Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        576,
        400
      ],
      "parameters": {
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "root",
          "cachedResultName": "/ (Root folder)"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "fede097e-50ae-452c-b317-819629e31d97",
      "name": "下载录制文件",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        368,
        400
      ],
      "parameters": {
        "url": "={{ $json.file_url }}",
        "options": {}
      },
      "typeVersion": 4.1
    },
    {
      "id": "606783f7-091d-488b-bef8-12d25b88a42a",
      "name": "标准化录制数据",
      "type": "n8n-nodes-base.code",
      "position": [
        176,
        400
      ],
      "parameters": {
        "jsCode": "// Normalize Zoom webhook payload\nconst event = $input.first().json;\nconst recording = event.payload.object.recording_files[0];\n\nreturn {\n  json: {\n    meeting_id: event.payload.object.id,\n    topic: event.payload.object.topic,\n    host: event.payload.object.host_email,\n    file_url: recording.download_url,\n    file_type: recording.file_type,\n    file_size: recording.file_size,\n    timestamp: new Date().toISOString()\n  }\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "e33a40c8-508e-43af-9b4f-991b35ec2f4a",
      "name": "Zoom 录制 Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -32,
        400
      ],
      "webhookId": "243c60a4-9f5a-4afc-afa4-33bf0cfab5de",
      "parameters": {
        "path": "zoom-recording",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 1
    },
    {
      "id": "c82aaea6-6404-456b-991b-59674090864f",
      "name": "设置说明",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        192
      ],
      "parameters": {
        "content": "🎥 **需要设置:**"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Log Result": {
      "main": [
        [
          {
            "node": "Create or update a record",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Recording": {
      "main": [
        [
          {
            "node": "Upload to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload to Google Drive": {
      "main": [
        [
          {
            "node": "Log Result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Zoom Recording Webhook": {
      "main": [
        [
          {
            "node": "Normalize Recording Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Recording Data": {
      "main": [
        [
          {
            "node": "Download Recording",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 文件管理, 多模态 AI

需要付费吗?

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

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

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

作者
David Olusola

David Olusola

@dae221

I help ambitious businesses eliminate operational bottlenecks and scale faster with AI automation. My clients typically see 40-60% efficiency gains within 90 days. Currently accepting 3 new projects this quarter - david@daexai.com

外部链接
在 n8n.io 查看

分享此工作流