TikTok转录文本
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 21 个节点。主要使用 If, Code, Wait, HttpRequest, GoogleSheets 等节点。 使用RapidAPI和Google Sheets自动化TikTok视频转录
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "OW8DfG2xXPS60mSj",
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752"
},
"name": "TikTok 转录文本",
"tags": [],
"nodes": [
{
"id": "c0de0228-f79b-4b18-9e5d-ee6218259078",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1380,
40
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.5
},
{
"id": "4b18deea-cfc2-4a8d-b2f3-8b31cac0d573",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
-560,
40
],
"parameters": {
"url": "https://tiktok-transcript-generator.p.rapidapi.com/tiktok/index.php",
"method": "POST",
"options": {
"response": {
"response": {}
}
},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json['Video Url'] }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "tiktok-transcript-generator.p.rapidapi.com"
},
{
"name": "x-rapidapi-key"
}
]
}
},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "baad7161-51f5-4f29-8af0-39244e10eb60",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
580,
-40
],
"parameters": {
"columns": {
"value": {
"Video Url": "={{ $('If').item.json['Video Url'] }}",
"Transcript": "={{ $json.cleanedSubtitles }}",
"Generated Date": "={{ new Date().toISOString().slice(0, 10) }}"
},
"schema": [
{
"id": "Video Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Video Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcript",
"type": "string",
"display": true,
"required": false,
"displayName": "Transcript",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Generated Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Generated Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Video Url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.5
},
{
"id": "ab5bcc9b-e2a0-4ec7-a4db-de512662549d",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1100,
40
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "d5d6e8a4-a2da-4cd5-80fc-3cf7c294697d",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
900,
140
],
"webhookId": "74ac1ccb-f843-41b8-97c4-b8d32892a5ea",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "6bea9362-5502-4c3c-acac-3f1a16bb0c64",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-820,
60
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e0b7b7c8-3a7a-466d-bae7-269282b49d34",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json['Video Url'] }}",
"rightValue": ""
},
{
"id": "64dde394-0e49-4306-a24a-de2bf448fc95",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Transcript }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "a9ca3926-efbd-42fa-9388-b24625690145",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-20,
-40
],
"parameters": {
"jsCode": "return items.map(item => {\n const raw = item.json.subtitles;\n\n // Remove \"WEBVTT\" header and timestamp lines\n const cleaned = raw\n .replace(/^WEBVTT\\s*/gm, '') // Remove \"WEBVTT\"\n .replace(/^\\d{2}:\\d{2}:\\d{2} --> \\d{2}:\\d{2}:\\d{2}/gm, '') // Remove timestamps\n .replace(/^\\s*\\n/gm, '') // Remove empty lines\n .trim();\n\n return {\n json: {\n cleanedSubtitles: cleaned\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "becf9d6b-26a1-4498-9683-18ad15bc82ea",
"name": "如果 1",
"type": "n8n-nodes-base.if",
"position": [
-260,
40
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "cd25e377-5c82-40b1-85ea-b372ee7765b7",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $json.error.status }}",
"rightValue": 404
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7c8d30f1-df83-4ee1-83ce-32f6d9b0a810",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
300,
140
],
"parameters": {
"columns": {
"value": {
"Video Url": "={{ $('If').item.json['Video Url'] }}",
"Transcript": "No transcription available",
"Generated Date": "={{ new Date().toISOString().slice(0, 10) }}"
},
"schema": [
{
"id": "Video Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Video Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcript",
"type": "string",
"display": true,
"required": false,
"displayName": "Transcript",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Generated Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Generated Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Video Url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.5
},
{
"id": "90a316f5-0f08-42f8-86a0-318bcc9814f9",
"name": "当点击“执行工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1580,
40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5d36dbf3-ebd6-4cd8-913b-ee1308d6847b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2500,
-480
],
"parameters": {
"width": 780,
"height": 980,
"content": "# 📝 TikTok 转录文本提取与记录工作流"
},
"typeVersion": 1
},
{
"id": "708c75c1-2ed7-48eb-b606-d6ff3eca7e30",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
-320
],
"parameters": {
"height": 580,
"content": "### 1. 点击“执行工作流”时"
},
"typeVersion": 1
},
{
"id": "b7c01b0d-726b-44e7-8099-93812eccce4b",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1400,
-320
],
"parameters": {
"height": 580,
"content": "### 2. Google Sheets2"
},
"typeVersion": 1
},
{
"id": "2d5229aa-2c40-41f6-8556-77690c3ed956",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1140,
-320
],
"parameters": {
"height": 580,
"content": "### 3. 循环项目"
},
"typeVersion": 1
},
{
"id": "89710512-98f5-4dc2-b8a5-234ae49d343f",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-320
],
"parameters": {
"height": 580,
"content": "### 4. If"
},
"typeVersion": 1
},
{
"id": "7514d668-1b6d-4786-8e7f-f07fbfeac194",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
-320
],
"parameters": {
"height": 580,
"content": "### 5. HTTP 请求"
},
"typeVersion": 1
},
{
"id": "2cfb2c0d-980c-4654-9486-45bc765372c6",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-320
],
"parameters": {
"height": 580,
"content": "### 6. If"
},
"typeVersion": 1
},
{
"id": "167cf773-1543-4778-ba99-d4adc87f3ec3",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-320
],
"parameters": {
"height": 580,
"content": "### 7. 代码"
},
"typeVersion": 1
},
{
"id": "ad776fb7-d066-4f10-917e-a1fbf476e961",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
-180
],
"parameters": {
"height": 480,
"content": "### 8. Google Sheets"
},
"typeVersion": 1
},
{
"id": "45271bfa-118b-46c7-8e73-e077119ce31f",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-380
],
"parameters": {
"height": 580,
"content": "### 9. Google Sheets1"
},
"typeVersion": 1
},
{
"id": "4bb59f93-a06c-4252-bec4-2809fa4d6067",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-220
],
"parameters": {
"height": 540,
"content": "### 10. 等待"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "957a8859-b78c-4fdc-b1c6-50de2acaa6a0",
"connections": {
"If": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
Flux AI 文生图副本
使用 Flux AI 集成 Google Sheets 和 Drive 的文生图生成器
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
潜在客户磁铁生成
使用RapidAPI AI从谷歌表格生成潜在客户磁铁创意
If
Wait
Http Request
+4
15 节点Evoort Solutions
内容创作
Shopify自动发送WhatsApp感谢消息和忠诚度优惠券（使用Rapiwa API）
使用Rapiwa从Shopify自动发送WhatsApp感谢消息和忠诚度优惠券
If
Code
Wait
+5
17 节点SpaGreen Creative
内容创作
Apollo 数据抓取与触达流程 1 ✅
使用 Apollo、AI 解析和定时邮件跟进自动生成潜在客户
If
Code
Wait
+13
39 节点Deniz
内容创作
FalAI_SeeDanceV1.0_英文模板
使用GPT-4o、Fal.AI Seedance和音频从文本提示生成电影级视频
If
Code
Wait
+12
38 节点Jaruphat J.
内容创作
