This workflow corresponds to n8n.io template #2856 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "TBvZA2Ty8lzc1DVN",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Youtube Automation - Animal Category",
"tags": [],
"nodes": [
{
"id": "e9d5a722-bcf8-488f-9460-9ce104974a28",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-880,
-1220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e3f83ab1-f2cc-4d92-8170-42fb24665235",
"name": "Video Category",
"type": "n8n-nodes-base.set",
"position": [
-660,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c698ca90-9883-428e-ad9c-2d64e04c4a97",
"name": "Fetch Elevenlabs",
"type": "n8n-nodes-base.httpRequest",
"position": [
-220,
-1220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3f76f3c3-ac8e-419c-93af-5f5d409ac98e",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
0,
-1220
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "f4ab68b6-a045-4b69-aeb2-309b29d574bd",
"name": "Download Audio",
"type": "n8n-nodes-base.httpRequest",
"position": [
600,
-1220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "0c12f1f9-a88c-4182-af8c-1cf1de9217a5",
"name": "Open AI Whisper",
"type": "n8n-nodes-base.httpRequest",
"position": [
820,
-1220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f3755b43-eafd-4d7e-8654-bcda4718dc0c",
"name": "Create a list of Image Text",
"type": "n8n-nodes-base.code",
"position": [
-880,
-980
],
"parameters": {},
"typeVersion": 2
},
{
"id": "17efd934-48ae-4d85-ba07-24b40d108aec",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
-660,
-980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6965e4d7-0f3e-4dc1-9ed5-8d58af6ea12e",
"name": "Convert to Flux Prompt",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
-980
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7c2e16e2-3d2f-4382-af53-2aba2c70d377",
"name": "Split Out - Image prompts",
"type": "n8n-nodes-base.splitOut",
"position": [
-220,
-980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "88e3a923-e618-440f-911c-938021111ea6",
"name": "Get image Base 64",
"type": "n8n-nodes-base.httpRequest",
"position": [
0,
-980
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "55497aaf-9a33-430d-8896-860095b4e675",
"name": "Convert to File",
"type": "n8n-nodes-base.convertToFile",
"position": [
220,
-980
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "615fd2e5-b7eb-4ecd-9445-2c1351c35002",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"position": [
440,
-980
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "2d56f99e-890f-4fdc-92dd-478de65f0c8e",
"name": "Save images to GC",
"type": "n8n-nodes-base.googleCloudStorage",
"position": [
660,
-980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d654afd3-1def-413c-82d7-5cdeb25c7a20",
"name": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
800,
-980
],
"parameters": {},
"typeVersion": 1
},
{
"id": "eb8a9381-432c-48f2-80db-8ce5ab078719",
"name": "Image Link",
"type": "n8n-nodes-base.set",
"position": [
940,
-980
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "954d0706-8d37-4fcd-9bf4-7e086affd02f",
"name": "Combine Transcript",
"type": "n8n-nodes-base.code",
"position": [
-900,
-760
],
"parameters": {},
"typeVersion": 2
},
{
"id": "767acffe-bda9-43ac-9cb2-77b0b27776b7",
"name": "Map Music",
"type": "n8n-nodes-base.set",
"position": [
-680,
-760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c03a5492-0a26-4003-86e4-ede87f71d41d",
"name": "Map Public Link",
"type": "n8n-nodes-base.set",
"position": [
400,
-1220
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "39e5224b-e632-4bbc-8901-d07357993dc0",
"name": "Save Audio",
"type": "n8n-nodes-base.googleCloudStorage",
"position": [
220,
-1220
],
"parameters": {},
"notesInFlow": false,
"retryOnFail": true,
"typeVersion": 1
},
{
"id": "46b746b3-2826-4c97-80a1-79ee2fdc17d3",
"name": "Create Video",
"type": "n8n-nodes-base.httpRequest",
"position": [
-240,
-760
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c1427c57-6021-4aff-aec8-26a2e6f5ce66",
"name": "Wait2",
"type": "n8n-nodes-base.wait",
"position": [
-20,
-760
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "af79a124-99be-4d4a-8a65-ea36f847b914",
"name": "Get Video Progress",
"type": "n8n-nodes-base.httpRequest",
"position": [
160,
-760
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "0eeb4ec7-f2f5-48d2-9fdd-5b157f02b109",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
-460,
-760
],
"parameters": {},
"typeVersion": 2
},
{
"id": "57a84470-97eb-4b21-a3ff-9cef19b71c44",
"name": "Get Caption By Deepseek",
"type": "n8n-nodes-base.httpRequest",
"position": [
600,
-760
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "93187361-9b42-42bd-966b-3bfcb229bf58",
"name": "Get Title By Deepseek",
"type": "n8n-nodes-base.httpRequest",
"position": [
760,
-760
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "d5ad62bc-4746-4de8-adfe-d1f34ccfef95",
"name": "Get Transcript By Deepseek",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
-1220
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "6e96abb4-8a8b-4606-9894-d28083588dfe",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
900,
-760
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "d5b2a02a-e148-4720-8b11-88a467e62a7f",
"name": "Grab Video",
"type": "n8n-nodes-base.googleSheets",
"position": [
-720,
-480
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "f16e5136-8689-438a-aedc-2593b190d734",
"name": "Set Correct Video Url",
"type": "n8n-nodes-base.set",
"position": [
380,
-760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b670d872-1034-4478-9892-4c31155e78ef",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-940,
-480
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "87697347-0430-4f78-b396-3def05aa281b",
"name": "Download Video",
"type": "n8n-nodes-base.httpRequest",
"position": [
-540,
-480
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "be327cfb-e798-4b82-a184-b0bae5d60c72",
"name": "YouTube",
"type": "n8n-nodes-base.youTube",
"position": [
-320,
-480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5c67a54e-f322-4fa3-9158-dbb5f71a6ca6",
"name": "Update Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-100,
-480
],
"parameters": {},
"typeVersion": 4.5
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "30961a31-47fd-4e25-9650-576b06a304bc",
"connections": {
"Wait": {
"main": [
[
{
"node": "Save Audio",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Create Video",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Image Link",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Save images to GC",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Get Video Progress",
"type": "main",
"index": 0
}
]
]
},
"YouTube": {
"main": [
[
{
"node": "Update Sheet",
"type": "main",
"index": 0
}
]
]
},
"Map Music": {
"main": [
[
{
"node": "Code1",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Convert to Flux Prompt",
"type": "main",
"index": 0
}
]
]
},
"Grab Video": {
"main": [
[
{
"node": "Download Video",
"type": "main",
"index": 0
}
]
]
},
"Image Link": {
"main": [
[
{
"node": "Combine Transcript",
"type": "main",
"index": 0
}
]
]
},
"Save Audio": {
"main": [
[
{
"node": "Map Public Link",
"type": "main",
"index": 0
}
]
]
},
"Create Video": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[]
]
},
"Download Audio": {
"main": [
[
{
"node": "Open AI Whisper",
"type": "main",
"index": 0
}
]
]
},
"Download Video": {
"main": [
[
{
"node": "YouTube",
"type": "main",
"index": 0
}
]
]
},
"Video Category": {
"main": [
[
{
"node": "Get Transcript By Deepseek",
"type": "main",
"index": 0
}
]
]
},
"Convert to File": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Map Public Link": {
"main": [
[
{
"node": "Download Audio",
"type": "main",
"index": 0
}
]
]
},
"Open AI Whisper": {
"main": [
[
{
"node": "Create a list of Image Text",
"type": "main",
"index": 0
}
]
]
},
"Fetch Elevenlabs": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Grab Video",
"type": "main",
"index": 0
}
]
]
},
"Get image Base 64": {
"main": [
[
{
"node": "Convert to File",
"type": "main",
"index": 0
}
]
]
},
"Save images to GC": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Combine Transcript": {
"main": [
[
{
"node": "Map Music",
"type": "main",
"index": 0
}
]
]
},
"Get Video Progress": {
"main": [
[
{
"node": "Set Correct Video Url",
"type": "main",
"index": 0
}
]
]
},
"Get Title By Deepseek": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Set Correct Video Url": {
"main": [
[
{
"node": "Get Caption By Deepseek",
"type": "main",
"index": 0
}
]
]
},
"Convert to Flux Prompt": {
"main": [
[
{
"node": "Split Out - Image prompts",
"type": "main",
"index": 0
}
]
]
},
"Get Caption By Deepseek": {
"main": [
[
{
"node": "Get Title By Deepseek",
"type": "main",
"index": 0
}
]
]
},
"Split Out - Image prompts": {
"main": [
[
{
"node": "Get image Base 64",
"type": "main",
"index": 0
}
]
]
},
"Get Transcript By Deepseek": {
"main": [
[
{
"node": "Fetch Elevenlabs",
"type": "main",
"index": 0
}
]
]
},
"Create a list of Image Text": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Video Category",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Transform trending Google News articles into engaging YouTube Shorts with this fully automated workflow. Save time and effort while creating dynamic, eye-catching videos that are perfect for content creators, journalists, and digital marketers.
Source: https://n8n.io/workflows/2856/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Free Support: Setting up and getting the workflow tailord to your needs. One small free adjustment included.
This workflow is designed for individuals and businesses looking to streamline the creation of engaging promotional videos. Whether you're marketing a product or developing a personal brand, this AI-d
The Problem That it Solves
Scrape ads – Pulls Facebook Ad Library data for "ai automation" keywords using Apify Filter & sort – Filters ads by page likes (>1,000) and separates into videos, images, and text ads Analyze creat
This n8n workflow automatically generates presentation-style "screen recording" videos with AI-generated slides and a talking head avatar overlay. You provide a topic and intention, and the workflow h