YT AI News Playlist Creator/AI News Form Updater

YouTube automation that creates a daily playlist of the latest AI news videos, deletes the previous day's playlist, and updates Google Sheets with channel information. This workflow saves time and ensures you stay updated with the most recent content, while also notifying you via Telegram when updates are made.

7/8/2025
23 nodes
Complex
schedulecomplexgooglesheetssplitoutsticky noteyoutubefiltertelegramschedule triggerautomationadvancedapiintegrationcommunicationbotcron
Categories:
Data Processing & AnalysisCreative Content & Video AutomationCommunication & MessagingSchedule TriggeredComplex Workflow
Integrations:
GoogleSheetsSplitOutSticky NoteYouTubeFilterTelegramSchedule Trigger

Target Audience

This workflow is ideal for content creators, social media managers, and digital marketers who want to automate the process of curating and sharing AI news from YouTube channels. Users who regularly update their audience with the latest news and insights can benefit significantly from this automation, particularly those who manage multiple channels and seek to streamline their operations.

Problem Solved

This workflow addresses the challenge of manually tracking and compiling the latest videos from various AI news channels on YouTube. It automates the process of creating a daily playlist, ensuring that users can efficiently gather and share relevant content without the need for constant manual intervention. By doing so, it saves time and reduces the risk of missing important updates.

Workflow Steps

  • Schedule Trigger: The workflow initiates at 7:15 AM daily to ensure timely updates.
    2. Read Channel Names: It retrieves a list of AI news channels from a Google Sheet, ensuring that users have a dynamic source of channels.
    3. Get Videos: For each channel, the workflow fetches the latest 5 videos published within the last 24 hours.
    4. Filter Out Upcoming: It filters out any videos that are marked as 'upcoming', ensuring only live content is included.
    5. Create Playlist: A new YouTube playlist is created with the title formatted as today's date in YYMMDD format, making it unique.
    6. Delete Old Playlist: The workflow deletes the playlist created the previous day to keep the content fresh and relevant.
    7. Add Videos to Playlist: The fetched videos are added to the newly created playlist, ensuring that the audience has access to the most recent content.
    8. Save Playlist ID: The ID of the new playlist is saved back into Google Sheets for future reference.
    9. Send Notification: Finally, a notification is sent via Telegram to inform the user that the playlist has been successfully updated.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Schedule: Change the trigger time to fit their needs, allowing for updates at different times of the day.
    - Updating Channel List: Add or remove channels from the Google Sheet to tailor the content sources.
    - Adjusting Video Limits: Change the number of videos fetched per channel by modifying the 'maxResults' parameter in the Get Videos node.
    - Changing Notification Settings: Users can customize the Telegram message to include specific details about the playlist or videos added.
    - Altering Playlist Naming: Modify the naming convention of the playlist to include different formats or additional information as needed.