Automatisation YouTube avec n8n : génération de clips vidéo
Ce workflow n8n permet d'automatiser la création et l'upload de clips vidéo sur YouTube, en intégrant des éléments tels que des musiques et des citations. Idéal pour les créateurs de contenu, ce processus simplifie la gestion des vidéos en récupérant des données depuis Google Sheets et Google Drive. Le workflow débute par un déclencheur manuel, suivi de la récupération des données de fond vidéo et de musique depuis Google Sheets. Ensuite, il liste les fichiers de fond vidéo et musical sur Google Drive. Une fois les fichiers sélectionnés, le workflow fusionne les données et choisit aléatoirement une vidéo, une musique et une citation. Après avoir téléchargé les fichiers sélectionnés, il génère le clip vidéo final en ajoutant du texte superposé. Le clip est ensuite téléchargé sur YouTube via une requête HTTP, et l'état de la citation est mis à jour dans Google Sheets. Grâce à cette automatisation n8n, les utilisateurs peuvent gagner un temps précieux tout en assurant une publication régulière de contenu sur leur chaîne YouTube, augmentant ainsi leur visibilité et leur engagement.
Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : vue d'ensemble
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : détail des nœuds
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"id": "gI3QGKTf52zwyh6O",
"meta": {
"instanceId": "e2034325698638870d6b764285427bad9d79bf1e08a458be597c06e61ad7e545",
"templateCredsSetupCompleted": true
},
"name": "AutoClip – Automatically Generate Video Clips and Upload to YouTube",
"tags": [],
"nodes": [
{
"id": "99e8f5d2-247a-44c7-85db-4bdd63c2a4f6",
"name": "Start AutoClip Workflow",
"type": "n8n-nodes-base.manualTrigger",
"position": [
40,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "221b0fa1-7e71-43e1-88a6-7070c6c10ed8",
"name": "Retrieve Video Background Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
500,
180
],
"parameters": {
"columns": {
"value": {
"BackgroundURL": "={{ $json.webViewLink }}"
},
"schema": [
{
"id": "BackgroundURL",
"type": "string",
"display": true,
"required": false,
"displayName": "BackgroundURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BackgroudStatus",
"type": "string",
"display": true,
"required": false,
"displayName": "BackgroudStatus",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 90817124,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit#gid=90817124",
"cachedResultName": "video_backgroud_list"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "120db4aa-5a1a-4685-9d1d-6d7814b20458",
"name": "Retrieve Quote Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
500,
0
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "CreateStatus"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit#gid=0",
"cachedResultName": "Quotes_status"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "17e6585a-0e48-40e7-86ec-4fb53f45bd07",
"name": "List Video Background Files",
"type": "n8n-nodes-base.googleDrive",
"position": [
260,
180
],
"parameters": {
"filter": {
"folderId": {
"__rl": true,
"mode": "id",
"value": "1mLOqFJZvUm563mJ7LvTsIcKrAoakX-h2"
}
},
"options": {
"fields": [
"webViewLink",
"id",
"name"
]
},
"resource": "fileFolder"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "nd1GyFEAYkpaT3xt",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "34d51d42-2562-4437-8cbc-e0158badb134",
"name": "Configure Music Background Folder ID",
"type": "n8n-nodes-base.set",
"position": [
40,
360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "19727718-f70d-4333-93dd-1ade2b1a66bf",
"name": "MusicBackgroundFolderID",
"type": "string",
"value": "12T6ABEuR7WlZ2i88GqcB3U4DmuKVM4iR"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0d819b1f-923d-4500-858a-166d65864872",
"name": "List Music Background Files",
"type": "n8n-nodes-base.googleDrive",
"position": [
260,
360
],
"parameters": {
"filter": {
"folderId": {
"__rl": true,
"mode": "id",
"value": "=12T6ABEuR7WlZ2i88GqcB3U4DmuKVM4iR"
}
},
"options": {
"fields": [
"webViewLink",
"name",
"id"
]
},
"resource": "fileFolder"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "OEWvSsY5xiUhqOnx",
"name": "Google Drive account - PeakWave"
}
},
"typeVersion": 3
},
{
"id": "3041385c-52d9-4d95-a454-de2064164717",
"name": "Retrieve Music Background Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
500,
360
],
"parameters": {
"columns": {
"value": {
"MusicURL": "={{ $json.webViewLink }}"
},
"schema": [
{
"id": "MusicURL",
"type": "string",
"display": true,
"required": false,
"displayName": "MusicURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "MusicStatus",
"type": "string",
"display": true,
"required": false,
"displayName": "MusicStatus",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1264732774,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit#gid=1264732774",
"cachedResultName": "music_backgroud_list"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ab86cac3-e44e-4e87-a467-a1c26e1f9752",
"name": "Merge File Selection Data",
"type": "n8n-nodes-base.merge",
"position": [
740,
200
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3
},
{
"id": "28c79ad7-cb34-424a-97ed-fcec5471e179",
"name": "Select Random Video, Music & Quote",
"type": "n8n-nodes-base.code",
"position": [
940,
200
],
"parameters": {
"jsCode": "function getRandomItem(arr) {\n return arr[Math.floor(Math.random() * arr.length)];\n}\n\n// Filter items based on unique keys from the merged inputs\nconst videoItems = items.filter(item => item.json.BackgroundURL !== undefined);\nconst musicItems = items.filter(item => item.json.MusicURL !== undefined);\nconst quoteItems = items.filter(item => item.json.Qoute !== undefined);\n\n// Debug logs to check counts in the execution log\nconsole.log(\"Video Items count: \" + videoItems.length);\nconsole.log(\"Music Items count: \" + musicItems.length);\nconsole.log(\"Quote Items count: \" + quoteItems.length);\n\nif (videoItems.length === 0 || musicItems.length === 0 || quoteItems.length === 0) {\n throw new Error(\"One or more input arrays are empty. Check your previous nodes.\");\n}\n\nconst selectedVideo = getRandomItem(videoItems);\nconst selectedMusic = getRandomItem(musicItems);\nconst selectedQuote = getRandomItem(quoteItems);\n\n// Return the combined selected items\nreturn [{\n video: selectedVideo.json,\n music: selectedMusic.json,\n quote: selectedQuote.json\n}];\n"
},
"typeVersion": 2
},
{
"id": "bd3fa420-555d-46a2-b48c-15a916f62b44",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-120
],
"parameters": {
"width": 1100,
"height": 660,
"content": "## Data Preparation & File Selection\nRetrieve and merge source data for quotes, video backgrounds, and music from Google Sheets and Google Drive; then randomly select one quote, one background video, and one music file."
},
"typeVersion": 1
},
{
"id": "7da639cb-6576-4ab5-891a-308ce35aecaf",
"name": "Download Selected Video Background",
"type": "n8n-nodes-base.googleDrive",
"position": [
1180,
0
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.video.BackgroundURL }}"
},
"options": {
"binaryPropertyName": "data"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "OEWvSsY5xiUhqOnx",
"name": "Google Drive account - PeakWave"
}
},
"typeVersion": 3
},
{
"id": "5ee8befc-979d-4a47-8eba-b31d6de8ea1f",
"name": "Download Selected Music Background",
"type": "n8n-nodes-base.googleDrive",
"position": [
1180,
340
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.music.MusicURL }}"
},
"options": {
"binaryPropertyName": "data"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "OEWvSsY5xiUhqOnx",
"name": "Google Drive account - PeakWave"
}
},
"typeVersion": 3
},
{
"id": "fd8fd1f8-64a6-4bf0-8586-8f5be506c8a1",
"name": "Save Video Background Locally",
"type": "n8n-nodes-base.readWriteFile",
"position": [
1420,
0
],
"parameters": {
"options": {},
"fileName": "video1.mp4",
"operation": "write"
},
"typeVersion": 1
},
{
"id": "9a8e1891-16c2-490c-ae91-4773f90e67d3",
"name": "Save Music Background Locally",
"type": "n8n-nodes-base.readWriteFile",
"position": [
1420,
340
],
"parameters": {
"options": {
"append": false
},
"fileName": "music1.mp3",
"operation": "write"
},
"typeVersion": 1
},
{
"id": "9fdca64e-79d7-4a58-91dc-4aa9f9b3c4cc",
"name": "Prepare Overlay Text (Quote & Author)",
"type": "n8n-nodes-base.code",
"position": [
1620,
20
],
"parameters": {
"jsCode": "// Define separate configuration for the quote and the author\nconst quoteFont = \"Kanit-Italic.ttf\"; // Font for the quote\nconst quoteFontSize = 70;\nconst authorFont = \"Kanit-Italic.ttf\"; // Font for the author (ensure this supports Thai)\nconst authorFontSize = 50;\nconst fontColor = \"white\";\nconst lineHeightMultiplier = 1.1;\nconst videoWidth = 1080;\nconst margin = 40; // Gap from left and right edges\n\n// Effective width for the quote text (accounting for left/right margins)\nconst effectiveVideoWidth = videoWidth - 2 * margin;\n\n// Estimate average character width based on quoteFontSize (this is a rough estimate)\nconst avgCharWidth = quoteFontSize * 0.6;\nconst maxCharsPerLine = Math.floor(effectiveVideoWidth / avgCharWidth);\n\n// Retrieve the quote transcript and author from the \"Merge\" node\nconst transcript = $node[\"Merge File Selection Data\"].json[\"Qoute\"];\nif (!transcript) {\n throw new Error(\"Quote not found\");\n}\nconst author = $node[\"Merge File Selection Data\"].json[\"Author\"];\nif (!author) {\n throw new Error(\"Author not found\");\n}\n\n// Split the transcript into words and group them into lines based on maxCharsPerLine\nconst words = transcript.split(' ');\nconst lines = [];\nlet currentLine = \"\";\nlet currentCharCount = 0;\n\nwords.forEach(word => {\n const wordLength = word.length;\n const additionalSpace = currentLine ? 1 : 0;\n const potentialLength = currentCharCount + additionalSpace + wordLength;\n if (potentialLength <= maxCharsPerLine) {\n currentLine += (currentLine ? \" \" : \"\") + word;\n currentCharCount = potentialLength;\n } else {\n lines.push(currentLine);\n currentLine = word;\n currentCharCount = wordLength;\n }\n});\nif (currentLine) {\n lines.push(currentLine);\n}\n\n// Calculate layout for the quote block\nconst lineHeight = quoteFontSize * lineHeightMultiplier;\nconst totalHeight = lines.length * lineHeight;\n\n// Build drawtext commands for each quote line (centered horizontally)\n// Each line is positioned so that the entire quote block is vertically centered.\nconst quoteCommands = lines.map((line, index) => {\n // Escape any single quotes in the line\n const escapedLine = line.replace(/'/g, \"\\\\'\");\n return `drawtext=fontfile=${quoteFont}:text='${escapedLine}':fontsize=${quoteFontSize}:fontcolor=${fontColor}:x=(w-text_w)/2:y=((h-${totalHeight})/2)+(${index}*${lineHeight})`;\n});\n\n// Build the drawtext command for the author\n// Place the author text below the quote block with a small gap (e.g. 20 pixels)\n// Align it to the right by setting x = w - text_w - margin.\nconst authorY = `((h-${totalHeight})/2)+(${lines.length}*${lineHeight})+20`;\nconst escapedAuthor = author.replace(/'/g, \"\\\\'\");\nconst authorCommand = `drawtext=fontfile=${authorFont}:text='${escapedAuthor}':fontsize=${authorFontSize}:fontcolor=${fontColor}:x=w-text_w-${margin}:y=${authorY}`;\n\n// Combine all commands (separated by commas) into one drawtext filter string.\nconst fullDrawTextFilter = quoteCommands.concat(authorCommand).join(\", \");\n\n// Return the prepared filter string for insertion into your FFmpeg command.\nreturn {\n json: {\n drawText: fullDrawTextFilter\n }\n};\n"
},
"typeVersion": 2
},
{
"id": "082cf794-89a9-42cc-b9ee-96792a17893f",
"name": "Generate Final Video Clip",
"type": "n8n-nodes-base.executeCommand",
"position": [
1640,
340
],
"parameters": {
"command": "=ffmpeg -i {{ $('Save Video Background Locally').item.json.fileName }} -i {{ $('Save Music Background Locally').item.json.fileName }} -filter_complex \"[0:v]scale=1080:1920:force_original_aspect_ratio=increase,crop=1080:1920[vid]; color=black@0.3:size=1080x1920:d=10[bg]; [vid][bg]overlay=shortest=1[bgvid]; [bgvid]{{ $json.drawText }}[outv]; [1:a]volume=0.8[aout]\" -map \"[outv]\" -map \"[aout]\" -aspect 9:16 -c:v libx264 -c:a aac -shortest output.mp4 -y"
},
"typeVersion": 1
},
{
"id": "460d3ddc-b24b-4714-8e00-023294da8375",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-120
],
"parameters": {
"color": 3,
"width": 700,
"height": 660,
"content": "## File Download & Video Processing\nDownload the selected files, write them to disk, prepare overlay text (quote and author), and generate the final video clip using FFmpeg."
},
"typeVersion": 1
},
{
"id": "b148528f-7d45-4a59-9b29-52c7229f05e8",
"name": "Initiate YouTube Resumable Upload",
"type": "n8n-nodes-base.httpRequest",
"position": [
1860,
20
],
"parameters": {
"url": "=https://www.googleapis.com/upload/youtube/v3/videos?part=snippet,status&uploadType=resumable",
"body": "={\n \"snippet\": {\n \"title\": \"{{ $('Save Music Background Locally').item.json.quote.Qoute }}\",\n \"description\": \"{{ $('Save Music Background Locally').item.json.quote.Qoute }}\\n{{ $('Save Music Background Locally').item.json.quote.Author }}\",\n \"defaultLanguage\": \"en\",\n \"defaultAudioLanguage\": \"en\"\n },\n \"status\": {\n \"privacyStatus\": \"public\",\n \"license\": \"youtube\",\n \"embeddable\": true,\n \"publicStatsViewable\": true,\n \"madeForKids\": false\n }\n}",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"sendBody": true,
"contentType": "raw",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"rawContentType": "RAW/JSON",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
},
{
"name": "X-Upload-Content-Type",
"value": "video/webm"
}
]
},
"nodeCredentialType": "youTubeOAuth2Api"
},
"credentials": {
"youTubeOAuth2Api": {
"id": "f9uNp5YNQMnXrNw2",
"name": "YouTube account"
}
},
"typeVersion": 4.2
},
{
"id": "e8a97b56-be01-497b-bc91-ec84bc59d039",
"name": "Read output file",
"type": "n8n-nodes-base.readWriteFile",
"position": [
2060,
20
],
"parameters": {
"options": {},
"fileSelector": "=output.mp4"
},
"typeVersion": 1
},
{
"id": "7965943e-e5c9-4c97-afca-18b3fc5881cd",
"name": "Upload Video to YouTube",
"type": "n8n-nodes-base.httpRequest",
"position": [
2260,
20
],
"parameters": {
"url": "={{ $('Initiate YouTube Resumable Upload').item.json.headers.location }}",
"method": "PUT",
"options": {},
"sendBody": true,
"contentType": "binaryData",
"sendHeaders": true,
"authentication": "predefinedCredentialType",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "video/webm"
}
]
},
"inputDataFieldName": "data",
"nodeCredentialType": "youTubeOAuth2Api"
},
"credentials": {
"youTubeOAuth2Api": {
"id": "f9uNp5YNQMnXrNw2",
"name": "YouTube account"
}
},
"typeVersion": 4.2
},
{
"id": "040f9064-9d7f-4106-9f1c-55222d6bf4d4",
"name": "Update Quote Upload Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
1860,
340
],
"parameters": {
"columns": {
"value": {
"Index": "={{ $('Save Music Background Locally').item.json.quote.Index }}",
"YoutubeURL": "=https://www.youtube.com/watch?v={{ $json.id }}",
"CreateStatus": "DONE"
},
"schema": [
{
"id": "Index",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Index",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Qoute",
"type": "string",
"display": true,
"required": false,
"displayName": "Qoute",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Author",
"type": "string",
"display": true,
"required": false,
"displayName": "Author",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CreateStatus",
"type": "string",
"display": true,
"required": false,
"displayName": "CreateStatus",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "YoutubeURL",
"type": "string",
"display": true,
"required": false,
"displayName": "YoutubeURL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Index"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit#gid=0",
"cachedResultName": "Quotes_status"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "526ffabc-3f12-4619-abe3-01d729f96db6",
"name": "Mark Background as Used",
"type": "n8n-nodes-base.googleSheets",
"position": [
2240,
340
],
"parameters": {
"columns": {
"value": {
"BackgroundURL": "{{ $('Read/Write Files from Disk1').item.json.video.BackgroundURL }}",
"BackgroudStatus": "DONE"
},
"schema": [
{
"id": "BackgroundURL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "BackgroundURL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "BackgroudStatus",
"type": "string",
"display": true,
"required": false,
"displayName": "BackgroudStatus",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"BackgroundURL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 90817124,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit#gid=90817124",
"cachedResultName": "video_backgroud_list"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/184-zcrfWSzQpDa-t57Oo_8DLyAF-2B_6yvGrybrcd5I/edit?gid=0#gid=0"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Ra2f1dlqOJ13jTtb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "5c833f0d-5c4b-489a-a53b-234b38433a2a",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
-120
],
"parameters": {
"width": 620,
"height": 660,
"content": "## Video Upload & Post-Processing\nUpload the final video to YouTube using the YouTube API and update your Google Sheets with upload statuses and YouTube links."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "49ffd0ae-2689-483f-9821-b99b9083ac8b",
"connections": {
"Read output file": {
"main": [
[
{
"node": "Upload Video to YouTube",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Quote Data": {
"main": [
[
{
"node": "Merge File Selection Data",
"type": "main",
"index": 0
}
]
]
},
"Start AutoClip Workflow": {
"main": [
[
{
"node": "Retrieve Quote Data",
"type": "main",
"index": 0
},
{
"node": "List Video Background Files",
"type": "main",
"index": 0
},
{
"node": "Configure Music Background Folder ID",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to YouTube": {
"main": [
[
{
"node": "Update Quote Upload Status",
"type": "main",
"index": 0
}
]
]
},
"Generate Final Video Clip": {
"main": [
[
{
"node": "Initiate YouTube Resumable Upload",
"type": "main",
"index": 0
}
]
]
},
"Merge File Selection Data": {
"main": [
[
{
"node": "Select Random Video, Music & Quote",
"type": "main",
"index": 0
}
]
]
},
"Update Quote Upload Status": {
"main": [
[
{
"node": "Mark Background as Used",
"type": "main",
"index": 0
}
]
]
},
"List Music Background Files": {
"main": [
[
{
"node": "Retrieve Music Background Data",
"type": "main",
"index": 0
}
]
]
},
"List Video Background Files": {
"main": [
[
{
"node": "Retrieve Video Background Data",
"type": "main",
"index": 0
}
]
]
},
"Save Music Background Locally": {
"main": [
[
{
"node": "Prepare Overlay Text (Quote & Author)",
"type": "main",
"index": 0
}
]
]
},
"Save Video Background Locally": {
"main": [
[
{
"node": "Download Selected Music Background",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Music Background Data": {
"main": [
[
{
"node": "Merge File Selection Data",
"type": "main",
"index": 2
}
]
]
},
"Retrieve Video Background Data": {
"main": [
[
{
"node": "Merge File Selection Data",
"type": "main",
"index": 1
}
]
]
},
"Initiate YouTube Resumable Upload": {
"main": [
[
{
"node": "Read output file",
"type": "main",
"index": 0
}
]
]
},
"Download Selected Music Background": {
"main": [
[
{
"node": "Save Music Background Locally",
"type": "main",
"index": 0
}
]
]
},
"Download Selected Video Background": {
"main": [
[
{
"node": "Save Video Background Locally",
"type": "main",
"index": 0
}
]
]
},
"Select Random Video, Music & Quote": {
"main": [
[
{
"node": "Download Selected Video Background",
"type": "main",
"index": 0
}
]
]
},
"Configure Music Background Folder ID": {
"main": [
[
{
"node": "List Music Background Files",
"type": "main",
"index": 0
}
]
]
},
"Prepare Overlay Text (Quote & Author)": {
"main": [
[
{
"node": "Generate Final Video Clip",
"type": "main",
"index": 0
}
]
]
}
}
}Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : pour qui est ce workflow ?
Ce workflow s'adresse aux créateurs de contenu, aux marketeurs et aux entreprises souhaitant automatiser la génération de vidéos pour YouTube. Il est conçu pour des utilisateurs ayant un niveau technique intermédiaire et peut être utilisé par des équipes de toutes tailles cherchant à optimiser leur production vidéo.
Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : problème résolu
Ce workflow résout le problème de la création manuelle de clips vidéo, qui peut être chronophage et sujet à des erreurs. En automatisant ce processus, il permet de réduire le temps de production, d'éviter les oublis lors de l'upload et d'assurer une cohérence dans le contenu publié. Les utilisateurs bénéficient d'une gestion simplifiée de leur chaîne YouTube, ce qui leur permet de se concentrer sur la création de contenu de qualité.
Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : étapes du workflow
Étape 1 : Le workflow commence par un déclencheur manuel pour initier le processus.
- Étape 1 : Il récupère les données de fond vidéo depuis Google Sheets.
- Étape 2 : Ensuite, il récupère les données de citation, également depuis Google Sheets.
- Étape 3 : Le workflow liste les fichiers de fond vidéo et musical sur Google Drive.
- Étape 4 : Il configure l'ID du dossier de musique de fond.
- Étape 5 : Les fichiers de musique de fond sont également listés.
- Étape 6 : Les données de musique de fond sont récupérées.
- Étape 7 : Les données de sélection de fichiers sont fusionnées.
- Étape 8 : Une vidéo, une musique et une citation sont sélectionnées aléatoirement.
- Étape 9 : Les fichiers vidéo et musical sélectionnés sont téléchargés.
- Étape 10 : Les fichiers sont sauvegardés localement.
- Étape 11 : Le texte de superposition est préparé.
- Étape 12 : Le clip vidéo final est généré.
- Étape 13 : Une requête HTTP initie l'upload sur YouTube.
- Étape 14 : Le fichier de sortie est lu.
- Étape 15 : Le clip est uploadé sur YouTube.
- Étape 16 : L'état de la citation uploadée est mis à jour dans Google Sheets.
- Étape 17 : Le fond utilisé est marqué dans Google Sheets.
Workflow n8n YouTube, Google Sheets, Google Drive, vidéo : guide de personnalisation
Pour personnaliser ce workflow, commencez par modifier les paramètres du déclencheur manuel pour l'adapter à vos besoins. Vous pouvez changer l'ID du document Google Sheets pour pointer vers vos propres données. Assurez-vous que les noms des feuilles correspondent à ceux de votre document. Pour les fichiers de Google Drive, ajustez les filtres pour sélectionner les fichiers souhaités. Vous pouvez également personnaliser le texte superposé en modifiant le code JavaScript dans le nœud correspondant. Enfin, vérifiez les paramètres d'authentification pour l'upload sur YouTube afin de garantir un accès correct à votre compte.