8
n8n 中文网amn8n.com

使用Sora-2、GPT和YouTube创建和发布联盟产品视频

高级

这是一个Content Creation, Multimodal AI领域的自动化工作流,包含 34 个节点。主要使用 If, Set, Code, Wait, Limit 等节点。 使用Sora-2、GPT和YouTube创建和发布联盟产品视频

前置要求
  • Telegram Bot Token
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "meta": {
    "instanceId": "756edd6d940beae3bac5d73f6195ad11653c7ff41aab8f7d9821eef5ef3d9a97",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "31bc03f8-da7d-4a1d-8acc-222ac1963e08",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        112
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "d47233d2-7e94-4292-b2e6-b700fcb3f662",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        992
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "ffa0d0e8-9cdd-45df-9439-ee4c95b6c22c",
      "name": "便签12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        -16
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "30848600-9243-4a47-8206-597495209bbf",
      "name": "定时触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        912,
        416
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "f4354ce4-b32f-4d8b-ac51-813f9360ad02",
      "name": "便签11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        96
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "f3910037-8646-4522-9bc1-f782398d1fb2",
      "name": "获取表格中的行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        416
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "96211aa6-27be-4a08-8a92-77c3c4e8a81f",
      "name": "限制",
      "type": "n8n-nodes-base.limit",
      "position": [
        2352,
        416
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7e425fb9-4fed-468a-8ba6-e676c2f78ee5",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        48,
        1584
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "e0a20a5f-e41d-4001-b6ee-63dbe31b8436",
      "name": "获取产品详情",
      "type": "n8n-nodes-base.set",
      "position": [
        1792,
        416
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "fd2d4269-8bd3-4290-a756-a29d7d09a1d2",
      "name": "合作伙伴活跃且未发布",
      "type": "n8n-nodes-base.filter",
      "position": [
        1392,
        416
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "41469cc5-967d-4048-bba0-2b560b56f9d0",
      "name": "从网站获取产品详情",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueErrorOutput",
      "position": [
        992,
        704
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "7fc74493-f03a-4e73-8437-9edeb4eed6fa",
      "name": "解析产品数据",
      "type": "n8n-nodes-base.code",
      "position": [
        2384,
        704
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f0c90a16-876c-4d26-8046-7e4af25cbe2c",
      "name": "条件判断",
      "type": "n8n-nodes-base.if",
      "position": [
        1504,
        656
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "d070dc1d-1bb4-4276-ad06-f3135054b2a2",
      "name": "更新关于错误",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1280,
        752
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "9183c459-cbbe-4d4a-bceb-16b13c27230f",
      "name": "Sora2 提示生成器",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        96,
        1360
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "d1a5d4bf-49ee-4df8-8971-dd7774d166e2",
      "name": "文本转视频2",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        848,
        1360
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "ea0fe3d2-8950-4a1e-814b-56339136d9ea",
      "name": "等待4",
      "type": "n8n-nodes-base.wait",
      "position": [
        1136,
        1360
      ],
      "webhookId": "9fd30610-c0b9-4f5c-9af5-89b821c11ec3",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "dc03699b-cbe6-4ee0-88e1-29f21759a346",
      "name": "获取视频4",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1376,
        1360
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "a7313c2f-2049-43c6-9e6f-c2861d841f34",
      "name": "条件判断4",
      "type": "n8n-nodes-base.if",
      "position": [
        1440,
        1584
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "817e8ed0-b350-4c55-8ad6-950f9e9186dd",
      "name": "下载视频",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1872,
        1488
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "dd5182dd-6285-456b-a38a-28bcb83442db",
      "name": "上传视频",
      "type": "n8n-nodes-base.youTube",
      "position": [
        2416,
        1680
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b84508e4-50b8-44f3-a611-5fad320d686e",
      "name": "更新 YouTube 元数据",
      "type": "n8n-nodes-base.youTube",
      "position": [
        1856,
        2720
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b2b25b35-3425-4984-85cf-eb2981cbea0a",
      "name": "在表格中更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2304,
        2736
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "af5ea8d8-8067-4709-90f0-22456f3feb26",
      "name": "YouTube 元数据 AI 助手",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1040,
        2672
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "92180066-e80c-430b-981d-1bd2e3311ffc",
      "name": "获取视频",
      "type": "n8n-nodes-base.set",
      "position": [
        1664,
        1488
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "2d608042-b231-463f-901a-2f40207e5dac",
      "name": "结构化输出解析器 1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1264,
        2912
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d15f730b-983f-4ebd-89bc-5003996cda0c",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        848,
        2912
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ebc0e7ed-2cb5-49aa-9535-8fc87d31055a",
      "name": "便签说明5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        1920
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "7b627e39-5507-4526-94a8-15983ad62bad",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        1936
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "d17600c6-2776-4ca6-89f1-2748960de15f",
      "name": "便签 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1696,
        1936
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "21071d9b-7836-43c4-99d1-23c95453e0f8",
      "name": "## 为什么选择 4o 模型?👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        704,
        1008
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "c465c615-6a6a-4fdc-aa08-db9d033c8b8b",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2112,
        1008
      ],
      "parameters": {
        "content": "Emelia 触发器"
      },
      "typeVersion": 1
    },
    {
      "id": "b650d75e-4a53-4e61-973b-aabadfb13bf5",
      "name": "发送消息并等待响应",
      "type": "n8n-nodes-base.telegram",
      "position": [
        160,
        2688
      ],
      "webhookId": "40678ef6-c7d1-4326-993e-5ca7d7aed147",
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "3f70e2c6-a199-438c-b7d1-48cc2ec7fb85",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        -320,
        2704
      ],
      "webhookId": "a0385600-a097-43f3-a5ac-fca967f55b5c",
      "parameters": {},
      "typeVersion": 1.1
    }
  ],
  "pinData": {},
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Parse Product Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If4": {
      "main": [
        [
          {
            "node": "Get Video",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Send message and wait for response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "Get Product Details from Website",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait4": {
      "main": [
        [
          {
            "node": "Get Video4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Video": {
      "main": [
        [
          {
            "node": "Download Video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Video4": {
      "main": [
        [
          {
            "node": "If4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Video": {
      "main": [
        [
          {
            "node": "Upload a video",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Text to Video2": {
      "main": [
        [
          {
            "node": "Wait4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload a video": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent for Meta Data of Youtube",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Sora2 Prompt Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse Product Data": {
      "main": [
        [
          {
            "node": "Sora2 Prompt Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Product Details": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Partnership Active and Not Published",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sora2 Prompt Generator": {
      "main": [
        [
          {
            "node": "Text to Video2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Youtube Meta Data": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent for Meta Data of Youtube",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get Product Details from Website": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update about Error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent for Meta Data of Youtube": {
      "main": [
        [
          {
            "node": "Update Youtube Meta Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send message and wait for response": {
      "main": [
        [
          {
            "node": "AI Agent for Meta Data of Youtube",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Partnership Active and Not Published": {
      "main": [
        [
          {
            "node": "Get Product Details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 内容创作, 多模态 AI

需要付费吗?

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

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

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

作者
Amjid Ali

Amjid Ali

@amjid

I'm Amjid Ali, a CIO and automation expert with 25+ years in IT and digital transformation. I specialize in building AI-powered, low-code workflows using n8n to automate ERP, finance, reporting, and customer support processes. As the founder of SyncBricks, author of "Mastering n8n," and creator of online courses, I share practical automation solutions to help businesses scale efficiently and innovate with confidence.

外部链接
在 n8n.io 查看

分享此工作流