Daily AI News YouTube Automation

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.

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.

1. 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.