Téléchargement en masse de vidéos TikTok sans filigrane vers Google Drive et suivi
Ceci est unFile Managementworkflow d'automatisation du domainecontenant 21 nœuds.Utilise principalement des nœuds comme Wait, GoogleDrive, HttpRequest, GoogleSheets, ManualTrigger. Téléchargement de masse de vidéos TikTok sans filigrane vers Google Drive avec suivi
- •Informations d'identification Google Drive API
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (21)
Catégorie
{
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "d8e13620-5f29-402d-a816-5df35fd547f8",
"name": "Attendre",
"type": "n8n-nodes-base.wait",
"position": [
760,
-100
],
"webhookId": "2e47d208-0316-420c-ba13-413830692e5c",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f073c57a-a84e-4ccd-8659-26c5c93d4b71",
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-280,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4af76036-000e-4810-8f9c-9e2140e17e91",
"name": "Boucler sur les éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
240,
-120
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e3b8f1ff-2d24-4da8-87e5-488f00a29540",
"name": "Obtenir les données de Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
-120
],
"parameters": {
"options": {},
"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": "0720d3ae-e6ca-408b-a1dc-8e8849689362",
"name": "Mettre à jour la ligne dans Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1840,
240
],
"parameters": {
"columns": {
"value": {
"url": "={{ $('Loop Over Items').item.json.url }}",
"driveurl": "={{ $('Upload File In Google Drive').item.json.webViewLink }}"
},
"schema": [
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "driveurl",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "driveurl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"url"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"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": "8ccbdb10-a104-4222-899b-3c933c3caa09",
"name": "Définir les permissions publiques Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1600,
-100
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "{{ $json.id }}"
},
"options": {},
"operation": "share",
"permissionsUi": {
"permissionsValues": {
"role": "writer",
"type": "anyone"
}
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 3
},
{
"id": "2b0243db-ef2f-4dcc-b3ea-bd47a33b648c",
"name": "Téléverser le fichier dans Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1300,
-100
],
"parameters": {
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "Rt0RWApx8PL9t0RF",
"name": "Google Docs account"
}
},
"typeVersion": 3
},
{
"id": "a144ebf4-7c58-460e-98fc-c4096af53a76",
"name": "Télécharger le fichier",
"type": "n8n-nodes-base.httpRequest",
"position": [
1000,
-100
],
"parameters": {
"url": "={{ $json.medias[1].url }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "173c8163-89bb-4bee-bf2f-ada26ac54686",
"name": "Appeler TikTok Downloader",
"type": "n8n-nodes-base.httpRequest",
"position": [
500,
-100
],
"parameters": {
"url": "https://tiktok-video-downloader23.p.rapidapi.com/index.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-video-downloader23.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "your key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "f8802a61-f2bc-4253-aacb-b505305c366b",
"name": "Pause",
"type": "n8n-nodes-base.wait",
"position": [
100,
180
],
"webhookId": "45167751-8beb-42e3-8295-bcc5d9aa8379",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c4525392-469c-48e4-aa1d-f8e48f8f5b1f",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-400
],
"parameters": {
"width": 560,
"height": 1280,
"content": "# 📥 Bulk TikTok Video Downloader & Google Drive Uploader\n\n## 🔄 What This Flow Does\n> **Automatically downloads TikTok videos from a list of URLs in a Google Sheet, uploads them to Google Drive, makes the videos publicly accessible, and updates the Google Sheet with the new Google Drive links.**\n\n---\n\n## ✅ Benefits of This Flow\n\n- 🚀 **Fully automated**: No manual downloads, uploads, or updates.\n- 🧾 **Centralized tracking**: Keeps original TikTok URLs and uploaded Google Drive links in the same Google Sheet.\n- 🔁 **Batch processing**: Processes multiple videos with loop handling and delays.\n- 🔓 **Public access**: Files are automatically set to public in Google Drive.\n- ⏱️ **Time-saving**: Reduces hours of manual work to a few minutes.\n- 👥 **Team-friendly**: Any team member can add a link to the sheet and get a Drive URL back.\n\n---\n\n## 🛠️ Challenges Solved by This Workflow\n\n| ❌ Problem | ✅ Solution Provided by Flow |\n|----------------------------------------|------------------------------------------------------|\n| Manual TikTok video downloads | Automated via external API |\n| Tedious Google Drive uploads | Automated upload with public permission |\n| No easy sharing of video files | Google Drive shareable link generated and updated |\n| Lack of tracking processed items | Google Sheet updated with each Drive URL |\n| High risk of human error | Fully systemized with minimal manual touchpoints |\n\n---\n\n## 🧩 Core Components \n\n- **Manual Trigger** – Starts the workflow manually.\n- **Get Data From Google Sheets** – Fetches TikTok URLs from a sheet.\n- **Loop Over Items** – Iterates over each URL one at a time.\n- **Call TikTok Downloader** – Uses an API to get the downloadable video link.\n- **Wait** – Adds delay before downloading to avoid rate limits.\n- **Download File** – Downloads the TikTok video file.\n- **Upload File In Google Drive** – Uploads the video to your Google Drive.\n- **Set Public Permission Google Drive** – Makes the uploaded file publicly accessible.\n- **Update Row In Google Sheet** – Updates the original sheet with the new Drive link.\n- **Sleep** – Adds delay between batches for reliability.\n\n---\n\n\n"
},
"typeVersion": 1
},
{
"id": "c16eae53-3bf3-4bb3-b597-48529db0eb66",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-260
],
"parameters": {
"height": 300,
"content": "## 🟢 When clicking ‘Execute workflow’\nManually triggers the workflow for testing or running on-demand."
},
"typeVersion": 1
},
{
"id": "74b004c2-cb7b-44ad-8f37-4b81035b0aef",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-260
],
"parameters": {
"height": 300,
"content": "## 📄 Get Data From Google Sheets\nReads all rows from a specific Google Sheet containing TikTok video URLs."
},
"typeVersion": 1
},
{
"id": "2f07afba-7af0-4886-996a-3229220e97ac",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-260
],
"parameters": {
"height": 300,
"content": "## 🔁 Loop Over Items\nProcesses each row from the sheet one-by-one (batch looping).\n"
},
"typeVersion": 1
},
{
"id": "6a2f0708-f5ea-4899-beaf-e9b1cb2eee2d",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-260
],
"parameters": {
"height": 300,
"content": "## 🌐 Call TikTok Downloader\nSends each TikTok URL to the RapidAPI TikTok downloader to get a direct video download link."
},
"typeVersion": 1
},
{
"id": "225452d1-8be6-4822-ba27-2f179c36a509",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-260
],
"parameters": {
"height": 300,
"content": "## ⏳ Wait\nAdds a short pause before downloading the file (helps prevent rate-limiting)."
},
"typeVersion": 1
},
{
"id": "f7da773d-d280-4bc9-b9cd-a3359ec0853d",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-260
],
"parameters": {
"height": 300,
"content": "## ⬇️ Download File\nDownloads the video from the `medias[1].url` provided by the TikTok downloader API."
},
"typeVersion": 1
},
{
"id": "d10bb3cd-edc4-4362-b053-ba3aa227ffda",
"name": "Note adhésive7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1220,
-260
],
"parameters": {
"height": 300,
"content": "## ☁️ Upload File In Google Drive\nUploads the downloaded video to Google Drive in the root folder."
},
"typeVersion": 1
},
{
"id": "769120e2-9a9e-46a1-a259-936c8825d6fb",
"name": "Note adhésive8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
-260
],
"parameters": {
"height": 300,
"content": "## 🔓 Set Public Permission Google Drive\nMakes the uploaded video file publicly accessible by setting sharing permissions.\n"
},
"typeVersion": 1
},
{
"id": "bccf0a40-54df-4a80-9f55-3383d78e4d58",
"name": "Note adhésive9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
80
],
"parameters": {
"height": 300,
"content": "## ✏️ Update Row In Google Sheet\nUpdates the same row in the sheet by matching `url`, adding the new Drive `webViewLink` in the `driveurl` column.\n\n"
},
"typeVersion": 1
},
{
"id": "f9278864-e0bf-4d6d-8841-3ce87c2e1546",
"name": "Note adhésive10",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
80
],
"parameters": {
"height": 260,
"content": "## 💤 Sleep\nPauses briefly and loops back to process the next TikTok URL in the list."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"d8e13620-5f29-402d-a816-5df35fd547f8": {
"main": [
[
{
"node": "a144ebf4-7c58-460e-98fc-c4096af53a76",
"type": "main",
"index": 0
}
]
]
},
"f8802a61-f2bc-4253-aacb-b505305c366b": {
"main": [
[
{
"node": "4af76036-000e-4810-8f9c-9e2140e17e91",
"type": "main",
"index": 0
}
]
]
},
"a144ebf4-7c58-460e-98fc-c4096af53a76": {
"main": [
[
{
"node": "2b0243db-ef2f-4dcc-b3ea-bd47a33b648c",
"type": "main",
"index": 0
}
]
]
},
"4af76036-000e-4810-8f9c-9e2140e17e91": {
"main": [
[],
[
{
"node": "173c8163-89bb-4bee-bf2f-ada26ac54686",
"type": "main",
"index": 0
}
]
]
},
"173c8163-89bb-4bee-bf2f-ada26ac54686": {
"main": [
[
{
"node": "d8e13620-5f29-402d-a816-5df35fd547f8",
"type": "main",
"index": 0
}
]
]
},
"0720d3ae-e6ca-408b-a1dc-8e8849689362": {
"main": [
[
{
"node": "f8802a61-f2bc-4253-aacb-b505305c366b",
"type": "main",
"index": 0
}
]
]
},
"e3b8f1ff-2d24-4da8-87e5-488f00a29540": {
"main": [
[
{
"node": "4af76036-000e-4810-8f9c-9e2140e17e91",
"type": "main",
"index": 0
}
]
]
},
"2b0243db-ef2f-4dcc-b3ea-bd47a33b648c": {
"main": [
[
{
"node": "8ccbdb10-a104-4222-899b-3c933c3caa09",
"type": "main",
"index": 0
}
]
]
},
"8ccbdb10-a104-4222-899b-3c933c3caa09": {
"main": [
[
{
"node": "0720d3ae-e6ca-408b-a1dc-8e8849689362",
"type": "main",
"index": 0
}
]
]
},
"f073c57a-a84e-4ccd-8659-26c5c93d4b71": {
"main": [
[
{
"node": "e3b8f1ff-2d24-4da8-87e5-488f00a29540",
"type": "main",
"index": 0
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Gestion de fichiers
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Sk developer
@skdeveloperPartager ce workflow