Перейти к содержимому

Lets build a YouTube Video Information Database together using an n8n workflow

Steve Plavetzky

0:00 / 0:00

Lets build a YouTube Video Information Database together using an n8n workflow

46 просмотров · 9 месяцев назад
Steve Plavetzky
116 подписчиков
46 просмотров · 9 месяцев назад
Learn step-by-step how to create a powerful YouTube video database workflow using YouTube API, Google Sheets, Rapid API, and ChatGPT. In this detailed tutorial, I'll walk you through setting up a seamless process to pull in your video details like titles, thumbnails, descriptions, tags, transcripts, key topics, and sponsor info directly into Google Sheets. Organize your content, identify missing tags, and optimize your YouTube channel workflow efficiently. Perfect for creators wanting to enhance video management and SEO. Watch now and start transforming your YouTube video data workflow today! Don't forget to like, subscribe, and comment your questions below! 🔗 LINKS - Some of the links above are affiliate links, meaning I may earn a small commission at no extra cost to you. Thank you for supporting the channel! n8n - https://n8n.partnerlinks.io/nnfxr18ys6ro ⚙️ Workflow YouTube Info Generator - https://drive.google.com/file/d/1PI0W... YouTube Video Information Database - End Result - https://drive.google.com/file/d/1kFwY... ⏰ Timestamps: 00:00 Intro 00:24 Credentials Needed 01:05 Workflow Questions 02:18 General Workflow Idea 03:27 Google Sheet Setup 05:47 YouTube Get Many Videos 07:42 Filter based on PublishedAt 08:56 Append or Add videoID to sheet 11:31 Get rows based on videoID 12:25 Check if Transcripts is filled in 13:52 Get YouTube Video Information 14:53 Get Transcription with RapidAPI 16:21 OpenAI / Chat GPT 17:13 Use Chat GPT to create the prompt 19:28 Consolidating Tags 21:36 Placing the Consolidate Tags Code Node 22:18 Append info to Google Sheet 25:00 Thumbnail Pictures using Google Sheets 26:25 Setup hyperlink Formula in n8n 28:16 Sponsor Demo with Manual modifying the transcript 29:13 YouTube API Error 30:14 Workflow Completed for 1 video 30:30 Convert to Sub Workflow 31:58 SAVE!!! 34:10 Running with multiple videos 34:47 Find in Database 35:36 Cell Wrap Explanation 36:48 Adding New Header - Date Uploaded 37:38 Converting sub work flow back to normal workflow 38:32 Correcting Google Sheets node for new column names 39:31 Formatted Date Code Node 42:49 Adding If NOT Private check 43:59 Adding private videos to google sheet 45:44 PublishAt for Scheduled Videos 46:50 Correcting for Published and Publish for public videos 49:21 Switching back to sub workflow 49:53 Sub workflows don't show running 50:29 Sorting on Google Sheets #YouTubeSEO #GoogleSheets #YouTubeAPI #ChatGPT #VideoMarketing #YouTubeWorkflow #ContentCreation #VideoTags #Transcripts #youtubetips #n8n #n8nworkflow #n8nautomation #n8ntutorial