8
n8n 中文网amn8n.com

YouTube 视频摘要发送至 Discord（GPT-4o、Slack 审批和 Google Sheets）

中级

这是一个AI, Marketing领域的自动化工作流，包含 15 个节点。主要使用 Code, Slack, Discord, HttpRequest, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 使用 GPT-4o 生成 YouTube 视频摘要，发送至 Discord，支持 Slack 审批和 Google Sheets

前置要求
  • •Slack Bot Token 或 Webhook URL
  • •Discord Bot Token 或 Webhook
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (15)

Code
Slack
Discord
StickyNote
HttpRequest
GoogleSheets
Agent
RssFeedReadTrigger
LmChatOpenAi

分类

人工智能
营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "5aaf4236c70e34e423fbdb2c7b754d19253a933bb1476d548f75848a01e473cf",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8a2b5bef-97b5-4fb9-933c-3bdf48c72bea",
      "name": "YouTube RSS 触发器",
      "type": "n8n-nodes-base.rssFeedReadTrigger",
      "position": [
        -1240,
        460
      ],
      "parameters": {
        "feedUrl": "https://www.youtube.com/feeds/videos.xml?channel_id=UCf3dc-Y3k5vBTCVpPCAfG6g",
        "pollTimes": {
          "item": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "bf9d4831-e6ea-4bb4-a4e8-e4f7708a049c",
      "name": "提取频道 ID",
      "type": "n8n-nodes-base.code",
      "position": [
        -1020,
        460
      ],
      "parameters": {
        "jsCode": "// 'items' is already defined in n8n and contains incoming data\n\nreturn items.map(item => {\n  const link = item.json.link; // e.g., \"https://www.youtube.com/watch?v=Y0DYmRnfHlc\"\n  const videoId = link.split(\"v=\")[1].split(\"&\")[0];\n  return {\n    json: {\n      videoId,\n    },\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "34208ab9-a3ba-4226-942a-33024118b8bc",
      "name": "获取视频详情",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -640,
        460
      ],
      "parameters": {
        "url": "https://www.googleapis.com/youtube/v3/videos",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "part",
              "value": "snippet"
            },
            {
              "name": "id",
              "value": "={{ $json.videoId }}"
            },
            {
              "name": "key",
              "value": "YOUR-API_KEY"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "8d210fe5-1278-409f-8176-3a313c1adc5d",
      "name": "摘要生成代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -220,
        460
      ],
      "parameters": {
        "text": "=Title: {{ $json.items[0].snippet.title }}\nDescription: {{ $json.items[0].snippet.description }}",
        "options": {
          "systemMessage": "You are a YouTube video summarizer. If the description is not available just tell that it is not available. Summarize the following video description"
        },
        "promptType": "define"
      },
      "typeVersion": 1.9
    },
    {
      "id": "472ebda0-35fb-4aa8-8bb8-96fcf7e3eca1",
      "name": "OpenAI GPT 摘要模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -260,
        680
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "efff4f36-e382-4d68-80a0-8bd649d009f2",
      "name": "存储结果到 Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        260,
        460
      ],
      "parameters": {
        "columns": {
          "value": {
            "Title": "={{ $('Fetch Video Details').item.json.items[0].snippet.title }}",
            "Summary": "={{ $json.output }}",
            "Video URL": "={{ $('YouTube RSS Trigger').item.json.link }}",
            "Video Published Date": "={{ $('YouTube RSS Trigger').item.json.isoDate }}"
          },
          "schema": [
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Video URL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Video URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Summary",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Summary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Video Published Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Video Published Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ImEKVtyBlxVvXzWKQw4wGbp4IzT_L2EUVqVj5txqY8A/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1ImEKVtyBlxVvXzWKQw4wGbp4IzT_L2EUVqVj5txqY8A",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1ImEKVtyBlxVvXzWKQw4wGbp4IzT_L2EUVqVj5txqY8A/edit?usp=drivesdk",
          "cachedResultName": "Youtube video summarizer"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DwjQkQSmdk0Zj6Wj",
          "name": "Google Sheets account 2"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "4c5dcb17-7510-479a-8276-0ac86e3312c6",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1300,
        -20
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 680,
        "content": "### 🔹 第一部分：**触发器与元数据提取**"
      },
      "typeVersion": 1
    },
    {
      "id": "c00b667c-3272-4e18-bb2f-1ee5b5a4a0aa",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3140,
        -160
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "923883a0-2f05-46f8-bbb2-d6ea80e4be69",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3140,
        180
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 2378,
        "content": "# 📺 YouTube 视频摘要工作流 – 文档说明"
      },
      "typeVersion": 1
    },
    {
      "id": "4ced7d41-bbed-4825-8fcd-b2c8c280a431",
      "name": "发送摘要等待审批",
      "type": "n8n-nodes-base.slack",
      "position": [
        440,
        460
      ],
      "webhookId": "24d232e5-aaa6-49e4-b070-479d86ed0aee",
      "parameters": {
        "select": "channel",
        "message": "=The summary of a video titled \"{{ $json.Title }}\" is given below:\n\n{{ $json.Summary }}",
        "options": {
          "appendAttribution": false
        },
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": "C08TTV0CC3E",
          "cachedResultName": "all-nathing"
        },
        "operation": "sendAndWait"
      },
      "typeVersion": 2.3
    },
    {
      "id": "b625cc87-62a3-4d1c-89a9-aedd348c5be0",
      "name": "发布已批准摘要",
      "type": "n8n-nodes-base.discord",
      "position": [
        760,
        460
      ],
      "webhookId": "f687b811-e348-4f76-8a8e-0abb35dab2fc",
      "parameters": {
        "content": "=New Video Summary\nTitle: {{ $('Store results to Google Sheet').item.json.Title }}\nSummary: {{ $('Store results to Google Sheet').item.json.Summary }}\n",
        "guildId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "options": {},
        "resource": "message",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "typeVersion": 2
    },
    {
      "id": "04f9dc44-0d22-4d4a-9ade-58b8596ed3f5",
      "name": "便签说明5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        80
      ],
      "parameters": {
        "color": 2,
        "width": 380,
        "height": 580,
        "content": "### 🔹 第二部分：**视频元数据获取**"
      },
      "typeVersion": 1
    },
    {
      "id": "89452ce8-1bfb-48b6-9572-ef28f959f4f4",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        120
      ],
      "parameters": {
        "color": 4,
        "width": 400,
        "height": 700,
        "content": "### 🔹 第三部分：**AI 摘要生成**"
      },
      "typeVersion": 1
    },
    {
      "id": "b357e45b-94a5-40b5-8e09-461d2176d0e2",
      "name": "便签 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        180,
        -140
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 820,
        "content": "### 🔹 第四部分：**存储与人工审批**"
      },
      "typeVersion": 1
    },
    {
      "id": "4fbedef1-b1ea-460b-9842-ce0ae0d8d4d2",
      "name": "## 为什么选择 4o 模型？👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        660,
        180
      ],
      "parameters": {
        "color": 6,
        "width": 320,
        "height": 480,
        "content": "### 🔹 第五部分：**最终发布**"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Summarize Agent": {
      "main": [
        [
          {
            "node": "Store results to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Channel ID": {
      "main": [
        [
          {
            "node": "Fetch Video Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Video Details": {
      "main": [
        [
          {
            "node": "Summarize Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "YouTube RSS Trigger": {
      "main": [
        [
          {
            "node": "Extract Channel ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI GPT Summary Model": {
      "ai_languageModel": [
        [
          {
            "node": "Summarize Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Send Summary for Approval": {
      "main": [
        [
          {
            "node": "Post Approved Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store results to Google Sheet": {
      "main": [
        [
          {
            "node": "Send Summary for Approval",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人工智能, 营销

需要付费吗？

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

相关工作流推荐

YouTube 视频摘要生成器（GPT-4o、Slack 审批与 Reddit 发布）
使用 GPT-4o 生成 YouTube 视频摘要，支持 Slack 审批和 Reddit 发布
Code
Slack
Reddit
+6
15 节点Yaron Been
人工智能
AI YouTube分析助手：评论分析与洞察报告
AI YouTube分析助手：评论分析器与洞察报告生成器
If
Set
Code
+9
19 节点Yaron Been
人工智能
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
If
Code
Limit
+8
14 节点Yaron Been
人工智能
FireCrawl摘要机器人
Firecrawl AI驱动的市场情报机器人：自动新闻洞察交付
Code
Slack
Http Request
+4
10 节点Yaron Been
人工智能
YouTube 到 Instagram_Facebook
使用 AI 生成字幕自动发布 YouTube 视频到 Facebook 和 Instagram
Http Request
Agent
Rss Feed Read Trigger
+2
13 节点Yaron Been
设计
使用 Phantombuster 的 LinkedIn 帖子互动
使用 Phantombuster、OpenAI GPT 和 Google Sheets 跟踪自动化 LinkedIn 互动
Http Request
Google Sheets
Agent
+3
14 节点Yaron Been
人工智能
工作流信息
难度等级
中级
节点数量15
分类2
节点类型9
难度说明

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

作者
Yaron Been

Yaron Been

@yaron-nofluff

Building AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos

外部链接
在 n8n.io 查看 →

分享此工作流