使用AI和RSS的多平台YouTube内容生成器
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 37 个节点。主要使用 If, Set, Code, Html, Telegram 等节点。 使用AI和RSS从YouTube生成多平台内容
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (37)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "QXf3TVkS1KH8wvhN",
"meta": {
"instanceId": "0d045f8fe3802ff2be0bb9a9ea445ee6c9ed61973377effe00767e483681e2f4",
"templateCredsSetupCompleted": true
},
"name": "使用 AI 和 RSS 的多平台 YouTube 内容生成器",
"tags": [],
"nodes": [
{
"id": "8b5a2b6f-7d13-4cb7-a681-0fe46c6cafb8",
"name": "无操作，不执行任何操作1",
"type": "n8n-nodes-base.noOp",
"position": [
1860,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6795a41f-a99a-4830-9019-788d096394b1",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
560,
-20
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "channel_id",
"attribute": "href",
"cssSelector": "link[rel=\"canonical\"]",
"returnValue": "attribute"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "bb5fb2a1-2868-44c1-ba60-fa592d2d5880",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
-20
],
"parameters": {
"url": "={{ $json['channel url'] }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "d0b2ee4a-9121-43d3-afce-9152cbe53ecb",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-80,
-20
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "901a0d9b-9fef-4fa3-ad15-5d3abfecc391",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-20
],
"parameters": {
"options": {},
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "wPmZzacn7hIP4akd",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "5ad50f2e-f186-4e49-852d-15206f014bb8",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
780,
-20
],
"parameters": {
"jsCode": "return items.map(item => {\n const fullUrl = item.json.channel_id; // contoh: \"https://www.youtube.com/channel/UCxxxxxxx\"\n const parts = fullUrl.split('/');\n const channelId = parts[parts.length - 1];\n\n return {\n json: {\n channel_id: channelId,\n rss_url: `https://www.youtube.com/feeds/videos.xml?channel_id=${channelId}`,\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "a330c281-7630-46af-b81e-516f4738e019",
"name": "RSS 阅读",
"type": "n8n-nodes-base.rssFeedRead",
"position": [
980,
-20
],
"parameters": {
"url": "={{ $json.rss_url }}",
"options": {}
},
"typeVersion": 1.2
},
{
"id": "edb3159f-9da7-47f1-bdcc-73db762090aa",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-760,
-800
],
"parameters": {
"width": 580,
"height": 1500,
"content": "# 使用 AI 和 RSS 的多平台 YouTube 内容生成器"
},
"typeVersion": 1
},
{
"id": "88493779-31d5-44ff-b8ce-828ba83522a7",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-220
],
"parameters": {
"color": 2,
"width": 600,
"height": 360,
"content": "- 定期触发自动化流程"
},
"typeVersion": 1
},
{
"id": "e23861ee-6554-479d-89b3-48ad3c7ccca8",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-220
],
"parameters": {
"color": 4,
"width": 600,
"height": 360,
"content": "- 从 YouTube 页面提取频道链接，特别是为了获取频道 ID"
},
"typeVersion": 1
},
{
"id": "872f0643-8c94-44ef-80de-8e82a4907748",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1160,
-220
],
"parameters": {
"color": 5,
"width": 600,
"height": 360,
"content": "- 将视频元数据保存到 Google Sheet"
},
"typeVersion": 1
},
{
"id": "be5e5de0-f6e9-4e49-9679-aadfbf9a97d1",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
-20
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.id }}",
"link": "={{ $json.link }}",
"title": "={{ $json.title }}",
"author": "={{ $json.author }}",
"pubDate": "={{ $json.pubDate }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook",
"type": "string",
"display": true,
"required": false,
"displayName": "facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "18adb456-c1e6-4862-b4bc-ff1dd2cd4335",
"name": "获取表格中的行2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1420,
-20
],
"parameters": {
"options": {},
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "6c3d39ef-108d-4b4b-bee8-a323c1b16b46",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
1640,
-20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "9a922382-22cb-4d0b-83f1-de9015e17ea9",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.summary }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dc892dc3-5f44-4993-88a7-0ba26659f6bd",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1860,
-360
],
"parameters": {
"color": 6,
"width": 600,
"height": 360,
"content": "- 使用 API 自动从 YouTube 视频检索字幕"
},
"typeVersion": 1
},
{
"id": "170fbac8-7e7b-46e2-ba25-32cb594a9723",
"name": "HTTP 请求1",
"type": "n8n-nodes-base.httpRequest",
"position": [
1900,
-180
],
"parameters": {
"url": "=https://api.supadata.ai/v1/transcript?url={{ $json.link }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "YOUR_SUPADATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "2ec5a701-7669-42dc-82da-a0a5ebe46d01",
"name": "设置语言",
"type": "n8n-nodes-base.set",
"position": [
2340,
-180
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "2c0793b5-85fb-46af-967a-f3807274104e",
"name": "language",
"type": "string",
"value": "English"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "f6e6ed41-b04a-4a6b-8ee5-175ad61d7baa",
"name": "合并字幕",
"type": "n8n-nodes-base.code",
"position": [
2120,
-180
],
"parameters": {
"jsCode": "const transcriptParts = items[0].json.content; // Ambil hanya dari 1 item (karena semua content ada di dalam satu objek)\n\nconst transcript = transcriptParts\n .map(part => part.text)\n .filter(Boolean) // Buang null atau undefined\n .join(' ');\n\nreturn [\n {\n json: {\n full_transcript: transcript\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "0577db2f-e07e-490b-9239-688d60e2e5b7",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2500,
-360
],
"parameters": {
"color": 6,
"width": 580,
"height": 360,
"content": "- 提示 AI 模型从字幕生成摘要"
},
"typeVersion": 1
},
{
"id": "12910fa9-fdc3-4831-9c3b-5fa07459c5ef",
"name": "OpenRouter 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
2560,
20
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "fd9823e3-4fe5-4721-b385-c6802096ece3",
"name": "在表格中追加或更新行1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2920,
-180
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('If').item.json.id }}",
"summary": "={{ $json.text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "f2ab8fc8-5fd8-4fb1-84cd-6e16ca1727b2",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3380,
-980
],
"parameters": {
"color": 6,
"width": 620,
"height": 1660,
"content": "- 向 AI 模型提供提示以基于摘要生成内容"
},
"typeVersion": 1
},
{
"id": "bfdab252-b418-44bd-a5d3-2f87bf830196",
"name": "基础 LLM 链",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
2560,
-180
],
"parameters": {
"text": "={{ $('Merge Transcripts').item.json.full_transcript }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=You are an AI assistant that helps you create summaries of YouTube videos based on the complete transcript.\n\nCreate a summary using informative, neutral, and easy to understand language.\n\nFocus on the main points of the conversation, who the speaker is, the main topic, and the insights discussed. Do not add information that is not included in the transcript.\n\nWrite in {{ $json.language }} language."
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "ba358aba-9a6b-42c2-9b59-fe7e43e7acc5",
"name": "基础 LLM 链1",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3460,
-720
],
"parameters": {
"text": "={{ $('Basic LLM Chain').item.json.text }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=Create a LinkedIn post based on the transcript.\n\nUse a storytelling style that highlights the key lesson, insight, or takeaway from the video. Write as if you’re sharing a personal experience or a meaningful conversation that adds value to professionals, entrepreneurs, or creators.\n\nStructure the post with a strong hook, a few short and easy-to-read paragraphs, and a closing sentence that invites reflection or discussion.\n\nWrite in Write in {{ $('Set Language').item.json.language }} language.\n\nWrite in a natural, professional tone. Do not exceed 1,300 characters.\n"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "32a78552-dff4-474f-bdc0-421dcde3b75d",
"name": "OpenRouter 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
3460,
-560
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "af7e5fc3-10df-47b6-ac29-e69d65455a00",
"name": "基础 LLM 链2",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3460,
-340
],
"parameters": {
"text": "={{ $('Basic LLM Chain').item.json.text }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=Create a post for X (formerly Twitter) based on the video transcript.\n\nThe post should be punchy, bold, or thought-provoking — something that stops scrolling. Focus on delivering one key insight, surprising fact, or controversial idea from the video.\n\nLimit to 280 characters. Write with energy and make it feel like the start of a conversation. Write in Write in {{ $('Set Language').item.json.language }} language.\n"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "967f34ce-1950-4b9e-9622-a0e41d144c5d",
"name": "OpenRouter 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
3460,
-180
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "7abe71e8-53bb-4d6c-b289-116d2abd3c85",
"name": "基础 LLM 链3",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3460,
0
],
"parameters": {
"text": "={{ $('Basic LLM Chain').item.json.text }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=Create a post for Threads based on the video transcript.\n\nUse a casual, friendly tone — as if you’re talking to your audience directly. Present the insight or story from the video in a relatable, open way.\n\nBreak into 1–3 short paragraphs. Avoid being overly formal or promotional. Write in Write in {{ $('Set Language').item.json.language }} language.\n"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "0219715e-4825-4ba8-98fe-804f5854379a",
"name": "OpenRouter 聊天模型3",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
3460,
160
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "097d5665-f384-4c9d-adb6-b37bcbd97247",
"name": "基础 LLM 链4",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
3460,
340
],
"parameters": {
"text": "={{ $('Basic LLM Chain').item.json.text }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=Create an Instagram caption based on the video transcript.\n\nFocus on short, emotionally resonant phrases that capture the core message or feeling of the video. Each sentence should be no longer than 150 characters and stand alone visually.\n\nWrite as if these lines will be used in a carousel post or overlaid on a reel. Write in Write in {{ $('Set Language').item.json.language }} language.\n"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "d930db61-50fe-41d8-b99e-c136811c8a66",
"name": "OpenRouter 聊天模型4",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
3460,
500
],
"parameters": {
"model": "google/gemini-2.0-flash-exp:free",
"options": {}
},
"typeVersion": 1
},
{
"id": "c8f6c47e-238a-4c42-8116-5e5034eaeb11",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
4300,
-340
],
"parameters": {
"color": 6,
"width": 380,
"height": 340,
"content": "- 将数据发送到 Telegram 进行监控并更快获取结果"
},
"typeVersion": 1
},
{
"id": "bea84a2a-fd83-433d-be23-2494c1f272a6",
"name": "发送文本消息",
"type": "n8n-nodes-base.telegram",
"position": [
4440,
-180
],
"webhookId": "80e7dccc-9a23-48bc-ad0a-eddd31fd357d",
"parameters": {
"text": "=Title : {{ $('If').item.json.title }}\nFrom : {{ $('If').item.json.author }}\n---\nCONTENT IDEAS\n---\nLinkedin :\n{{ $json.linkedin }}\n---\nX :\n{{ $json.x }}\n---\nThreads :\n{{ $json.threads }}\n---\nInstagram :\n{{ $json.instagram }}",
"chatId": "YOUR_TELEGRAM_CHAT_ID",
"additionalFields": {
"appendAttribution": false
}
},
"typeVersion": 1.2
},
{
"id": "986762b4-75e0-4418-b813-538ac890c076",
"name": "在表格中追加或更新行2",
"type": "n8n-nodes-base.googleSheets",
"position": [
3800,
-720
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('If').item.json.id }}",
"linkedin": "={{ $json.text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "9c9de77a-dea5-47fc-9e82-43ff78817072",
"name": "在表格中追加或更新行3",
"type": "n8n-nodes-base.googleSheets",
"position": [
3800,
-340
],
"parameters": {
"columns": {
"value": {
"x": "={{ $json.text }}",
"id": "={{ $('If').item.json.id }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "e1929aea-7b1a-4a73-80f5-59c954d5db17",
"name": "在表格中追加或更新行5",
"type": "n8n-nodes-base.googleSheets",
"position": [
3800,
0
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('If').item.json.id }}",
"threads": "={{ $json.text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
},
{
"id": "edc9505c-7eca-4cf4-aa61-96afd345ed71",
"name": "在表格中追加或更新行4",
"type": "n8n-nodes-base.googleSheets",
"position": [
3800,
340
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('If').item.json.id }}",
"instagram": "={{ $json.text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pubDate",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pubDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "author",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "x",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "x",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "threads",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "threads",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "instagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": false,
"mode": "name",
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": false,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "9399a753-fcfc-4fe4-8d8a-6955c19c3fdb",
"connections": {
"If": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing1",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "RSS Read",
"type": "main",
"index": 0
}
]
]
},
"HTML": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"RSS Read": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "HTML",
"type": "main",
"index": 0
}
]
]
},
"Set Language": {
"main": [
[
{
"node": "Basic LLM Chain",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Merge Transcripts",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain": {
"main": [
[
{
"node": "Append or update row in sheet1",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain1": {
"main": [
[
{
"node": "Append or update row in sheet2",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain2": {
"main": [
[
{
"node": "Append or update row in sheet3",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain3": {
"main": [
[
{
"node": "Append or update row in sheet5",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain4": {
"main": [
[
{
"node": "Append or update row in sheet4",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Merge Transcripts": {
"main": [
[
{
"node": "Set Language",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet2": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Chat Model1": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Chat Model2": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Chat Model3": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain3",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Chat Model4": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain4",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Get row(s) in sheet2",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet1": {
"main": [
[
{
"node": "Basic LLM Chain1",
"type": "main",
"index": 0
},
{
"node": "Basic LLM Chain2",
"type": "main",
"index": 0
},
{
"node": "Basic LLM Chain3",
"type": "main",
"index": 0
},
{
"node": "Basic LLM Chain4",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet2": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet3": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet4": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet5": {
"main": [
[
{
"node": "Send a text message",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
YouTube评论情感和关键词提取器
使用Gemini AI分析YouTube评论情感和关键词并通过Telegram报告
Set
Code
Telegram
+10
20 节点Budi SJ
市场调研
基于 AI、社交媒体和 WhatsApp 链接的自动化本地商业线索生成器
使用 AI、社交媒体和 WhatsApp 链接自动生成本地商业线索
If
Code
Limit
+9
29 节点Budi SJ
潜在客户开发
使用Groq、Gemini和Slack审批系统自动化RSS到Medium发布
通过Groq、Gemini和Slack审批系统实现RSS到Medium发布的自动化流程
If
Set
Code
+16
41 节点ObisDev
内容创作
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+16
48 节点Daniel Lianes
内容创作
RSS发布到Facebook和Instagram
通过AI摘要和图像生成自动化RSS到社交媒体发布
If
Set
Code
+11
34 节点Karol
内容创作
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
工作流信息
难度等级
高级
节点数量37
分类2
节点类型13
作者
Budi SJ
@budisjI’m a Product Designer who also works as an Automation Developer. With a background in product design and systems thinking, I build user-centered workflows. My focus is on helping teams and businesses work more productively through impactful automation systems.
外部链接
在 n8n.io 查看 →
分享此工作流