8
n8n 中文网amn8n.com

YouTube 视频摘要生成器(GPT-4o、Slack 审批与 Reddit 发布)

中级

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

前置要求
  • Slack Bot Token 或 Webhook URL
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "5aaf4236c70e34e423fbdb2c7b754d19253a933bb1476d548f75848a01e473cf"
  },
  "nodes": [
    {
      "id": "dc53327e-392e-44db-b633-657f1edbad9d",
      "name": "YouTube RSS 触发器",
      "type": "n8n-nodes-base.rssFeedReadTrigger",
      "position": [
        2120,
        500
      ],
      "parameters": {
        "feedUrl": "https://www.youtube.com/feeds/videos.xml?channel_id=UCf3dc-Y3k5vBTCVpPCAfG6g",
        "pollTimes": {
          "item": [
            {}
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d0665878-6c71-4994-9e24-410d6c8dfe94",
      "name": "提取频道ID",
      "type": "n8n-nodes-base.code",
      "position": [
        2340,
        500
      ],
      "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": "8b22e2ec-9710-4c61-8a4b-bf86fb10db68",
      "name": "获取视频详情",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2720,
        500
      ],
      "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": "d3bc260c-ec32-44ac-9cb5-22cefe3dd124",
      "name": "摘要代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        3140,
        500
      ],
      "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 availablee. Summarize the following video description"
        },
        "promptType": "define"
      },
      "typeVersion": 1.9
    },
    {
      "id": "6ffc23a3-5a6d-4333-b2b5-5ca89d6f0003",
      "name": "OpenAI GPT 摘要模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        3100,
        720
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "028dbd84-3e46-4a88-8c04-33fa4c14db73",
      "name": "将结果存储到 Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3600,
        500
      ],
      "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"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "a8583d95-e8da-41e3-ac2b-1f33cdedfd71",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2060,
        20
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 680,
        "content": "### 🔹 第1部分:**触发器与元数据提取**"
      },
      "typeVersion": 1
    },
    {
      "id": "8629cc8d-9f91-4a02-a243-02255338cc02",
      "name": "### 替换 Airtable 连接",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        -120
      ],
      "parameters": {
        "color": 4,
        "width": 1300,
        "height": 320,
        "content": "======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "f423c1f0-4a5d-4c5c-a32d-e2e4818de5a8",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        220
      ],
      "parameters": {
        "color": 4,
        "width": 1289,
        "height": 2378,
        "content": "# 📺 YouTube 视频摘要工作流 - 文档"
      },
      "typeVersion": 1
    },
    {
      "id": "896302ec-7449-4cb7-a318-06c80d3bec0e",
      "name": "发送摘要等待批准",
      "type": "n8n-nodes-base.slack",
      "position": [
        3780,
        500
      ],
      "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": "db3482aa-eb72-45fb-951b-8f979b092e7a",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2580,
        120
      ],
      "parameters": {
        "color": 2,
        "width": 380,
        "height": 580,
        "content": "### 🔹 第2部分:**视频元数据检索**"
      },
      "typeVersion": 1
    },
    {
      "id": "d7695161-f1fd-4ae2-95d7-471ce387842e",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3040,
        160
      ],
      "parameters": {
        "color": 4,
        "width": 400,
        "height": 700,
        "content": "### 🔹 第3部分:**AI 摘要生成**"
      },
      "typeVersion": 1
    },
    {
      "id": "36d3ed80-e31b-4154-b433-5fd2c5f37405",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3520,
        -100
      ],
      "parameters": {
        "color": 5,
        "width": 400,
        "height": 820,
        "content": "### 🔹 第4部分:**存储与人工批准**"
      },
      "typeVersion": 1
    },
    {
      "id": "ef7f236c-0fa1-4049-889e-1eacbdef5bb2",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4000,
        220
      ],
      "parameters": {
        "color": 6,
        "width": 320,
        "height": 480,
        "content": "### 🔹 第5部分:**最终发布**"
      },
      "typeVersion": 1
    },
    {
      "id": "c942edf3-ed74-4fe8-970c-e9600b6912ce",
      "name": "发布到 Reddit",
      "type": "n8n-nodes-base.reddit",
      "position": [
        4100,
        500
      ],
      "parameters": {
        "text": "={{ $('Store results to Google Sheet').item.json.Summary }}",
        "title": "={{ $('Store results to Google Sheet').item.json.Title }}",
        "subreddit": "Youtube"
      },
      "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": "Publish To Reddit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store results to Google Sheet": {
      "main": [
        [
          {
            "node": "Send Summary for Approval",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

中级 - 人工智能, 营销

需要付费吗?

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

工作流信息
难度等级
中级
节点数量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 查看

分享此工作流