无水印TikTok视频下载至Google Drive并自动记录到表格
高级
这是一个Content Creation, Miscellaneous, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 If, Wait, FormTrigger, GoogleDrive, HttpRequest 等节点。 将无水印TikTok视频下载到Google Drive，并自动在表格中记录日志
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752"
},
"nodes": [
{
"id": "a1b4a7ad-efec-4a7c-a7d0-057b01cae303",
"name": "表单提交时",
"type": "n8n-nodes-base.formTrigger",
"position": [
840,
580
],
"webhookId": "99c989d4-d7e6-42d9-9f05-5235e2624149",
"parameters": {
"options": {},
"formTitle": "TikTok to MP4",
"formFields": {
"values": [
{
"fieldLabel": "URL",
"placeholder": "https://tiktok.com/",
"requiredField": true
}
]
},
"formDescription": "TikTok to MP4 Converter"
},
"typeVersion": 2.2
},
{
"id": "da8b91e6-99c7-4d84-abfb-9358f4b1b87e",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2520,
380
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $('On form submission').item.json.URL }}",
"Drive_URL": "={{ $('Upload To Google Drive').item.json.webViewLink }}"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Drive_URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Drive_URL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "url",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "d069c2dc-7576-478f-8510-4beb55871bff",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
1360,
600
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bcc58e3d-9609-4ec3-adb9-bc6098205818",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "success"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "05a6f22b-b42c-4bf8-8ad6-5e671cf33c3e",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1700,
840
],
"webhookId": "410a255f-0e20-4697-9584-b59829a5bfb8",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5e5256dd-e767-484d-8b4f-c0dc62b71f9d",
"name": "Google Drive 设置权限",
"type": "n8n-nodes-base.googleDrive",
"position": [
2180,
300
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"resource": "file",
"operation": "share",
"permissionsUi": {},
"authentication": "oAuth2"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "qEkQ8MFn0uSHgAqY",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "ddde32c8-f9dc-40cf-8180-b232bb40d6a8",
"name": "Upload To Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1880,
300
],
"parameters": {
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "qEkQ8MFn0uSHgAqY",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "a4554ac9-23bb-490f-b6fa-8ed9b923214b",
"name": "Google Sheets 追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
2180,
840
],
"parameters": {
"columns": {
"value": {
"URL": "{{ $('On form submission').item.json.URL }}",
"Drive_URL": "N/A"
},
"schema": [
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Drive_URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Drive_URL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "url",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 4.6
},
{
"id": "92be8d5e-d47f-40a3-b376-0266b0dfb736",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
300
],
"parameters": {
"height": 500,
"content": "## 🟢 **1. 表单提交时**"
},
"typeVersion": 1
},
{
"id": "d4c2cf21-bd6a-4976-acc0-9646ab3a9715",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1020,
300
],
"parameters": {
"height": 500,
"content": "## 🌐 **2. Tiktok RapidAPI 请求**"
},
"typeVersion": 1
},
{
"id": "c02f3615-b35d-4caf-a7e7-c326f53c9465",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
300
],
"parameters": {
"height": 500,
"content": "## 🔍 **3. 条件判断**"
},
"typeVersion": 1
},
{
"id": "fe2137e0-14ad-4a31-8104-e451fd5510b0",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1560,
60
],
"parameters": {
"height": 440,
"content": "## ⬇️ **4. MP4 下载器**"
},
"typeVersion": 1
},
{
"id": "59292dcb-737c-4efb-9b22-8fb1e9a25274",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
60
],
"parameters": {
"height": 400,
"content": "## ☁️ **5. 上传到 Google Drive**"
},
"typeVersion": 1
},
{
"id": "6b72288e-a3f4-45cd-bade-54630124121e",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
2100,
60
],
"parameters": {
"height": 380,
"content": "## 🔑 **6. Google Drive 设置权限**"
},
"typeVersion": 1
},
{
"id": "48c35706-eb6e-4d20-8e2e-dd1b4de27b1a",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
2440,
80
],
"parameters": {
"height": 460,
"content": "## 📄 **7. Google Sheets**"
},
"typeVersion": 1
},
{
"id": "9d828c99-d634-4bd7-9478-66960a243aca",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1640,
600
],
"parameters": {
"height": 360,
"content": "## ⏱️ **8. 等待**"
},
"typeVersion": 1
},
{
"id": "fc3a67e7-1822-4f0e-ae4d-bab35bf3b94d",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2100,
480
],
"parameters": {
"height": 480,
"content": "## 📑 **9. Google Sheets 追加行**"
},
"typeVersion": 1
},
{
"id": "01d9dd0c-4370-4ecf-8df3-55de50bb09b7",
"name": "MP4 下载器",
"type": "n8n-nodes-base.httpRequest",
"position": [
1620,
320
],
"parameters": {
"url": "={{ $json.data[\"DOWNLOAD (WITHOUT WATERMARK)\"] }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "6510719b-49cf-4264-985b-1ed5b98b1a9f",
"name": "TikTok RapidAPI 请求",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
1060,
580
],
"parameters": {
"url": "https://tiktok-download-audio-video.p.rapidapi.com/mp3-4.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $json.URL }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "tiktok-download-audio-video.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "4c89daff-9491-45b4-9d53-6231da674776",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
340
],
"parameters": {
"width": 720,
"height": 560,
"content": "# 📥 TikTok 转 MP4 转换器自动化"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "MP4 Downloader",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Google Sheets Append Row",
"type": "main",
"index": 0
}
]
]
},
"MP4 Downloader": {
"main": [
[
{
"node": "Upload To Google Drive",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "TikTok RapidAPI Request",
"type": "main",
"index": 0
}
]
]
},
"Upload To Google Drive": {
"main": [
[
{
"node": "Google Drive Set Permission",
"type": "main",
"index": 0
}
]
]
},
"TikTok RapidAPI Request": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Set Permission": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 杂项, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
表单触发的Instagram视频下载到Google Drive并记录到表格
表单触发的Instagram视频下载到Google Drive并记录到表格
If
Wait
Form Trigger
+4
19 节点Evoort Solutions
杂项
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
使用背景移除AI处理图像并在Google表格中跟踪结果
使用背景移除AI处理图像并在Google表格中跟踪结果
If
Wait
Form Trigger
+4
17 节点Evoort Solutions
内容创作
使用RapidAPI和Google Sheets进行SEO竞争对手分析
使用RapidAPI和Google Sheets进行SEO竞争对手分析
If
Set
Wait
+4
15 节点Evoort Solutions
市场调研
使用RapidAPI和Google Sheets的SERP关键词排名检查器
使用RapidAPI和Google Sheets的SERP关键词排名检查器
If
Set
Wait
+4
17 节点Evoort Solutions
市场调研
Flux AI 文生图副本
使用 Flux AI 集成 Google Sheets 和 Drive 的文生图生成器
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
