8
n8n 中文网amn8n.com

使用Sonnet 3.5、Pinecone和Creatomate生成谜语短视频并

高级

这是一个Other, AI, Marketing领域的自动化工作流,包含 32 个节点。主要使用 If, Code, Wait, Gmail, Merge 等节点,结合人工智能技术实现智能自动化。 使用Sonnet 3.5、Pinecone和Creatomate生成谜语短视频并发布到YouTube

前置要求
  • Google 账号和 Gmail API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • Anthropic API Key
  • OpenAI API Key
  • Pinecone API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "35SXmvC53Lb0eJDt",
  "meta": {
    "instanceId": "b3c467df4053d13fe31cc98f3c66fa1d16300ba750506bfd019a0913cec71ea3",
    "templateCredsSetupCompleted": true
  },
  "name": "Quizzes Shorts Generator copy",
  "tags": [],
  "nodes": [
    {
      "id": "8a9a9a67-9f49-4b45-b0e3-e3a6ab4e08e6",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -300,
        -760
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "913b9093-7811-4118-8f6d-11ab9c2cacf5",
      "name": "Anthropic Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        -160,
        -580
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "ead88caa-7cca-4f35-a130-3c8ac7c79a2f",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        20,
        -240
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "f5c9f6d6-3f16-4d23-9d12-b4be3bfbccf6",
      "name": "Default Data Loader",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        800,
        -900
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "27c0589d-a85d-463a-960c-a562fdd021a2",
      "name": "Recursive Character Text Splitter",
      "type": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
      "position": [
        800,
        -680
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b328ffee-9ccd-4d15-8229-91bdbb159cc1",
      "name": "Embeddings OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        640,
        -920
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "07f9280c-54d7-473d-a2f3-293ca1af41d0",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1580,
        -680
      ],
      "parameters": {},
      "typeVersion": 3.1
    },
    {
      "id": "582e8cb0-17cb-4141-8e25-062bac70f385",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        1940,
        -680
      ],
      "webhookId": "02a83906-d093-41e6-9b90-e565bb8c1e3b",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "3b1df4bc-72eb-4452-ab1c-bac9daecb932",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        160,
        -580
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "530101d9-6b00-4c6a-8062-7a64960ba6a8",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        2300,
        -440
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "d575df6d-0bad-43af-a9bb-d33c841d9878",
      "name": "Riddle generation AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -80,
        -760
      ],
      "parameters": {},
      "typeVersion": 1.9
    },
    {
      "id": "b7017156-c5fb-4d4d-a951-511b5942471e",
      "name": "Vector Store to Find Previous Riddles",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        -80,
        -400
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "31865d0d-0b08-42dc-814c-cfb43562aca6",
      "name": "Fetch Audio From Sheet (Ensuring Rotation)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        600,
        -460
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 4.5
    },
    {
      "id": "a63baebb-7658-4b31-a8c1-698b5099b4f3",
      "name": "Insert Riddles to Vector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        620,
        -1100
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "a857ddb7-8e55-48ad-be99-6f68f385ba95",
      "name": "Convert Riddles JSON to 1 Text item for Vector Insertion",
      "type": "n8n-nodes-base.code",
      "position": [
        460,
        -1100
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ae014584-3e1f-425b-937d-6b1491680c95",
      "name": "Fetch Current Shorts Title (Numbered)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        960,
        -1100
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "f04ffdab-5309-46d1-b4db-5e5aab68f04a",
      "name": "Calculate Next Shorts Title Number (To update at the end)",
      "type": "n8n-nodes-base.code",
      "position": [
        1160,
        -1100
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "46d5e44c-ca87-40a3-a3c3-2f23587a5034",
      "name": "Render Youtube Short",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1760,
        -680
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "dc9e9174-becc-4d24-abb4-48d8c1a9d254",
      "name": "Youtube Upload HTTP request Setup",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2120,
        -680
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "4a5a3e7e-5323-4be4-bea8-13267d9cc879",
      "name": "Get Binary for Rendered Short",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2300,
        -680
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "8a561692-413f-4bff-9a87-da8fe5e8e961",
      "name": "Upload Binary to Youtube HTTP",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2480,
        -680
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "b3c52e07-0f65-4a46-8e72-f391ae9a9b3d",
      "name": "Send Notification with YouTube link",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1580,
        -440
      ],
      "webhookId": "6517cd12-3cf1-46c3-b56f-4a14d63f3757",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "70aef838-2a53-4ec6-8dc0-c4987b3fce27",
      "name": "Update Audio Used Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1760,
        -440
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "215c4ca7-5292-4761-9876-2238d2dcec7a",
      "name": "Update Next Shorts title",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1940,
        -440
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "7e8bf144-7669-4d5d-aaaa-b8e7dd3a71cf",
      "name": "Check if all audio tracks have been used",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2120,
        -440
      ],
      "parameters": {},
      "typeVersion": 4.5,
      "alwaysOutputData": true
    },
    {
      "id": "e20e90a6-7125-4c14-95cf-807424cbd9c1",
      "name": "get all track rows",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2560,
        -340
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "1fde9116-b24f-4307-81b0-4faf54052e02",
      "name": "update all track rows back to unused",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2760,
        -340
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "bfe2c945-abcc-48f4-bad9-d93c0ff71bf5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        -480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "480cb231-26c1-4b65-9a02-666961a985fc",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1520,
        -720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d6173a8e-7b78-4b05-96a4-b833a5dd1d8a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        460,
        -1320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "31093814-6058-48fe-bff9-2dfa03ccf76d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        940,
        -1320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e16200b1-bdfd-4395-944a-078de86bebe1",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -1040
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "081eec97-96f2-47a3-8f20-c6f0ccf1b114",
  "connections": {
    "530101d9-6b00-4c6a-8062-7a64960ba6a8": {
      "main": [
        [],
        [
          {
            "node": "e20e90a6-7125-4c14-95cf-807424cbd9c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "582e8cb0-17cb-4141-8e25-062bac70f385": {
      "main": [
        [
          {
            "node": "dc9e9174-becc-4d24-abb4-48d8c1a9d254",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "07f9280c-54d7-473d-a2f3-293ca1af41d0": {
      "main": [
        [
          {
            "node": "46d5e44c-ca87-40a3-a3c3-2f23587a5034",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8a9a9a67-9f49-4b45-b0e3-e3a6ab4e08e6": {
      "main": [
        [
          {
            "node": "d575df6d-0bad-43af-a9bb-d33c841d9878",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ead88caa-7cca-4f35-a130-3c8ac7c79a2f": {
      "ai_embedding": [
        [
          {
            "node": "b7017156-c5fb-4d4d-a951-511b5942471e",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "b328ffee-9ccd-4d15-8229-91bdbb159cc1": {
      "ai_embedding": [
        [
          {
            "node": "a63baebb-7658-4b31-a8c1-698b5099b4f3",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "e20e90a6-7125-4c14-95cf-807424cbd9c1": {
      "main": [
        [
          {
            "node": "1fde9116-b24f-4307-81b0-4faf54052e02",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f5c9f6d6-3f16-4d23-9d12-b4be3bfbccf6": {
      "ai_document": [
        [
          {
            "node": "a63baebb-7658-4b31-a8c1-698b5099b4f3",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "913b9093-7811-4118-8f6d-11ab9c2cacf5": {
      "ai_languageModel": [
        [
          {
            "node": "d575df6d-0bad-43af-a9bb-d33c841d9878",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "46d5e44c-ca87-40a3-a3c3-2f23587a5034": {
      "main": [
        [
          {
            "node": "582e8cb0-17cb-4141-8e25-062bac70f385",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3b1df4bc-72eb-4452-ab1c-bac9daecb932": {
      "ai_outputParser": [
        [
          {
            "node": "d575df6d-0bad-43af-a9bb-d33c841d9878",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "70aef838-2a53-4ec6-8dc0-c4987b3fce27": {
      "main": [
        [
          {
            "node": "215c4ca7-5292-4761-9876-2238d2dcec7a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "215c4ca7-5292-4761-9876-2238d2dcec7a": {
      "main": [
        [
          {
            "node": "7e8bf144-7669-4d5d-aaaa-b8e7dd3a71cf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d575df6d-0bad-43af-a9bb-d33c841d9878": {
      "main": [
        [
          {
            "node": "31865d0d-0b08-42dc-814c-cfb43562aca6",
            "type": "main",
            "index": 0
          },
          {
            "node": "a857ddb7-8e55-48ad-be99-6f68f385ba95",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a5a3e7e-5323-4be4-bea8-13267d9cc879": {
      "main": [
        [
          {
            "node": "8a561692-413f-4bff-9a87-da8fe5e8e961",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8a561692-413f-4bff-9a87-da8fe5e8e961": {
      "main": [
        [
          {
            "node": "b3c52e07-0f65-4a46-8e72-f391ae9a9b3d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a63baebb-7658-4b31-a8c1-698b5099b4f3": {
      "main": [
        [
          {
            "node": "ae014584-3e1f-425b-937d-6b1491680c95",
            "type": "main",
            "index": 0
          }
        ]
      ],
      "ai_tool": [
        []
      ]
    },
    "27c0589d-a85d-463a-960c-a562fdd021a2": {
      "ai_textSplitter": [
        [
          {
            "node": "f5c9f6d6-3f16-4d23-9d12-b4be3bfbccf6",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "dc9e9174-becc-4d24-abb4-48d8c1a9d254": {
      "main": [
        [
          {
            "node": "4a5a3e7e-5323-4be4-bea8-13267d9cc879",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b3c52e07-0f65-4a46-8e72-f391ae9a9b3d": {
      "main": [
        [
          {
            "node": "70aef838-2a53-4ec6-8dc0-c4987b3fce27",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ae014584-3e1f-425b-937d-6b1491680c95": {
      "main": [
        [
          {
            "node": "f04ffdab-5309-46d1-b4db-5e5aab68f04a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b7017156-c5fb-4d4d-a951-511b5942471e": {
      "ai_tool": [
        [
          {
            "node": "d575df6d-0bad-43af-a9bb-d33c841d9878",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "7e8bf144-7669-4d5d-aaaa-b8e7dd3a71cf": {
      "main": [
        [
          {
            "node": "530101d9-6b00-4c6a-8062-7a64960ba6a8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "31865d0d-0b08-42dc-814c-cfb43562aca6": {
      "main": [
        [
          {
            "node": "07f9280c-54d7-473d-a2f3-293ca1af41d0",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "a857ddb7-8e55-48ad-be99-6f68f385ba95": {
      "main": [
        [
          {
            "node": "a63baebb-7658-4b31-a8c1-698b5099b4f3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f04ffdab-5309-46d1-b4db-5e5aab68f04a": {
      "main": [
        [
          {
            "node": "07f9280c-54d7-473d-a2f3-293ca1af41d0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 其他, 人工智能, 营销

需要付费吗?

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

工作流信息
难度等级
高级
节点数量32
分类3
节点类型16
难度说明

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

作者
Joseph

Joseph

@mjomba

Automation expert specializing in building smart, scalable workflows using tools like n8n, Make, and Airtable. I help businesses save time, reduce manual work, and grow faster with tailored automation solutions. Feel free to reach out at joseph@uppfy.com to discuss your project.

外部链接
在 n8n.io 查看

分享此工作流

分类

分类: 34