YouTube and Google Sheets integration

Are you a cord-cutter? Do you find yourself looking through the many titles of videos uploaded to Youtube, just to find the ones you want to watch? Even when you subscribe to the channels you like, do you find that you want to watch the news now and my tech/n8n videos later? Well, now you can have n8n grab the last 8 videos, posted in the last 24 hours, and put them in a playlist for the day; and, each day the old playlist is deleted. Are you tired of a channel filling your subscriptions with tons of videos a day; this workflow can be used for any channel, whether you are subscribed to the channel or not. It's a YouTube playlist automation. How it works: Create your list of prefered Youtube Channels in a Google Sheet and it will create you a daily playlist; and, it will delete the playlist created yesterday. Instructions To set this up, you need to create a Google Sheet with the following headings in line 1: Channel User Name Channel Name Channel Link Channel ID Copy the 'Create your Channel List' into it's own workflow and link the Sheets links to your new sheet. To get the 'Create your Channel List' to work, you need to visit each channel's page that you want included in your playlist; you need to get the "@" name of the channel and add it to the 'Channel User Name' column of your Google Sheet. For example: if you wanted to include this channel: Recruit Training Videos - Corporal Stock, you would search for the name, to add to the next available row of the 'Channel User Name' column: @CorporalStock Once you add all Channel User Names, run the 'Create your Channel list workflow, and it will fill in the remaining details. Now the 'YT Playlist Creator' can be run. Note: The first time the workflow us run, disconnect the 'Delete Yesterday's Playlist' leg, or the workflow will error and stop (because there is no 'Yesterday's Playlist'. Note: this was made to create a playlist every day, delete yesterday's playlist, and only get the last 8 videos posted within the last 24 hours. I choose to put the date (YYMMDD format) in front of the playlist, to ensure that it doesn't conflict with another playlist. Also, I have it notifying me in Telegram, so I know that the new playlist is posted.

Automated YouTube Bedtime Story Video Generator (No Code) n8n Workflow Free Support: Setting up and getting the workflow tailord to your needs. One small free adjustment included. Transform your creative ideas into enchanting bedtime story videos with this fully automated n8n workflow. Designed for content creators, digital marketers, and storytellers, this tool streamlines the process of turning audio recordings into professional, engaging YouTube videos. Samautomation.work You will have the best and cheapest video rendering service online. Check the website for more information. You can customize every video and change all these settings: Change the aspact ratio to 16:9 for long form content. Check the API docs for more information. "settings": { "aspect_ratio": "9:16", "background_volume": 0.15, "voice_volume": 1.0, "font": "bangers", "font_size": 40, "text_color": "blue", "stroke_color": "white", "stroke_width": 10, "disable_captions": "true" More information on: Samautomation.work support Contact our whatsapp support if you have any questions, we are ready to assist with customizing the template if needed. Key Features Seamless Audio-to-Text Conversion:** Utilize OpenAI Whisper to convert audio recordings into accurate transcripts, ensuring every word of your story is captured. AI-Powered Image Generation:** Automatically generate beautiful, thematic visuals using advanced AI image tools that create captivating 16:9 backgrounds tailored for bedtime stories. Dynamic Video Compilation:** Merge images, voiceovers, and background music into a polished video with a few clicks. Customize video length, style, and audio levels to match your vision. Automated YouTube Integration:** Upload your videos directly to YouTube complete with autogenerated titles, descriptions, and metadata. Manage your content easily with real-time updates. Efficient Workflow Management:** Track your projects via Google Sheets and receive instant notifications through Telegram, keeping you always in the loop. Cost Efficiency:** Each video costs only 25 cents to produce, making this solution incredibly affordable for large-scale content creation. How It Works Capture & Transcribe: Record your bedtime story and let OpenAI Whisper transcribe the audio into text. Generate Stunning Visuals: Use integrated AI image generation to create dreamy visuals that complement your narrative. Compile Your Video: Combine the visuals, transcripts, and background music into a complete video ready for distribution. Publish & Manage: Automatically upload your video to YouTube, with all details saved and tracked in Google Sheets for seamless management. Who Is It For? This workflow is perfect for: Content Creators** looking to effortlessly produce engaging bedtime story videos. Digital Marketers** aiming to boost video content output without heavy manual intervention. Storytellers & Educators** who want to bring their narratives to life with a professional finish. Small Businesses & Startups** seeking scalable video production solutions. Setup Requirements API keys for OpenAI, Google Cloud Storage, and YouTube. Basic familiarity with n8n and API integration. A passion for storytelling and creative video production. Video Rendering with samautomation.work Start automating your video creation process today and captivate your audience with enchanting bedtime stories. With this workflow, you can save time, enhance productivity, and focus on what you do best—telling magical stories, all while keeping your production cost at just 25 cents per video! Ready to transform your content game? Get your Automated YouTube Bedtime Story Video Generator now and start creating charming videos in minutes! Demo video Check out the link to the demo video of the end result.

Automated YouTube Shorts Creator from Google News Trends 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. Key Features Trend Analysis: Automatically fetch Google News articles and entertainment trends every 24 hours. AI-Powered Video Creation: Generate accurate transcripts from articles using Deepseek AI. Create visually appealing backgrounds with AI image generation tools. Add voiceovers with ElevenLabs TTS or similar services. Dynamic Video Compilation: Combine images, audio, and background music to craft short, dynamic videos. Fully customizable video length and music selection. YouTube Integration: Upload videos directly to YouTube, complete with autogenerated titles and descriptions. Organized Management: Titles and descriptions are saved to a Google Sheet for easy tracking and editing. How It Works Fetch trending topics from Google News using Deepseek. Convert the article's content into a readable transcript. Automatically create a voiceover, generate visuals, and combine them into a complete video. Upload the video to YouTube with a dynamic caption and description. Who Is It For? Content creators looking to expand their reach on YouTube Shorts. News agencies aiming to deliver content faster. Digital marketers needing quick, engaging videos. Setup Requirements API keys for Google News, ElevenLabs, OpenAI, and Deepseek. Basic knowledge of API integration and video content creation. Start creating trending, eye-catching YouTube Shorts in minutes. Automate your workflow and stay ahead in the content game!

YouTube to X Post Overview This n8n workflow automates the process of promoting your latest YouTube videos on X (formerly Twitter). It ensures that posts are engaging, concise, and follow platform-specific requirements. Additionally, the workflow logs social posts into a Google Sheet for record-keeping. Features Fetch Latest YouTube Videos:** Pulls recently uploaded videos from a specified channel. Generate Engaging X Posts:** Uses OpenAI's GPT-4 to create tailored, witty posts about your videos. Character Limit Validation:** Ensures posts comply with X's character limit by rewriting if necessary. Post Scheduling:** Automates post publishing to X. Google Sheets Integration:** Logs posts and their status for tracking and management. Optional Notifications:** Sends updates via Discord, Slack, or Gmail (disabled by default). How It Works Trigger: Manually trigger the workflow or set a scheduled check for new videos (disabled by default). Fetch YouTube Videos: Retrieves the latest videos from your YouTube channel, filtering duplicates. Content Creation: OpenAI generates a witty and humanized post under 220 characters, using video title and description. If the post exceeds the character limit, it is rewritten automatically. Google Sheets Logging: Logs the generated post to a Google Sheet with details like time, date, and post status. Post to X: Publishes the generated post on X. Updates the Google Sheet with the post URL. Optional Notifications: Sends notifications about the published post via Discord, Slack, or Gmail. Setup Instructions Credentials: Add credentials for: YouTube API OpenAI API Google Sheets API X (formerly Twitter) API Use the accounts associated with "AlexK1919." YouTube Node: Specify your YouTube Channel ID in the Fetch Latest Videos node. Find your Channel ID here. Google Sheets Node: Configure the node with your Google Sheet for logging posts. Use the linked sheet: AlexK1919 Social Posts. OpenAI Node: Set up your OpenAI API key for generating posts. X Post Node: Connect your X account to the Post to X node. Optional Notifications: Configure Discord, Slack, or Gmail nodes for custom notifications. Customization Schedule:** Enable and modify the Check Every 2 Hours node to automatically check for new videos. Post Format:** Edit the OpenAI prompt in the Generate X Post node to tweak the tone or style of the generated posts. Additional Platforms:** Expand this workflow to post on other social platforms by adding respective nodes (e.g., Facebook, LinkedIn). Notes Posts are validated for character limits but are restricted to 220 characters to ensure compliance with X's guidelines and leave space for links. Posts are logged in the Google Sheet with details, including post status and timestamps. Current integrations are focused on promoting YouTube content; additional types can be supported with minor adjustments. Contact For support or inquiries: Alex Kim** About Me