Build a fresh YouTube playlist every morning from selected channels and get a Telegram alert when it is done. This is ideal for marketing teams and content publishers who share daily roundups or news. It saves time and keeps your feed current.

The flow runs on a daily schedule, creates a new playlist with the date in the title, and removes yesterday’s list to keep your channel tidy. It reads your channel list from Google Sheets, pulls the latest uploads from each channel in the last 24 hours, filters out upcoming streams, and adds the videos to the new playlist. A helper path updates your sheet by turning channel handles into channel IDs. You can test everything with a manual trigger before going live.

Setup is simple. Prepare a Google Sheet with the required columns, connect Google Sheets, YouTube, and Telegram in n8n, run the helper once to populate IDs, and leave the delete step off for the first run. Expect to cut daily curation from about an hour to a few minutes while avoiding copy and paste errors.

• Daily schedule at 07:15 that runs the playlist build automatically.
• Manual test path to build and refresh the channel list before going live.
• Google Sheets read and update for channel handles and playlist IDs.
• HTTP requests to the YouTube Data API to pull recent uploads per channel.
• Split and filter steps that remove upcoming or scheduled streams.
• Automatic playlist creation with the date in the title for easy tracking.
• Safe deletion of the prior playlist using the stored ID from Sheets.
• Telegram message when the new playlist is ready.

• Reduce manual curation from 60 minutes to 5 minutes per day.
• Automate over 90 percent of daily playlist publishing steps.
• Cut copy and paste mistakes by 95 percent by reading from Sheets.
• Show only fresh videos from the last 24 hours to keep content relevant.
• Scale to dozens of channels without extra effort.
• Connect Google Sheets, YouTube, and Telegram in one flow.

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, YouTube and Telegram. See the Tools Required section above for links to create accounts with these services.
3. Open the n8n credentials manager. For each service, double click the relevant node, then on the 'Credential to connect with' dropdown, click 'Create new credential', then follow the on screen instructions to integrate that service.
4. Google Sheets credentials: choose your Google account and grant access. Name the credential clearly, for example Sheets Prod. Attach this credential to all Google Sheets nodes.
5. YouTube credentials: create a YouTube OAuth2 credential and sign in to the channel that will own the playlists. Name it clearly and attach it to all YouTube nodes.
6. Telegram credentials: create a bot with BotFather to get a bot token. In n8n, create a Telegram credential with that token and attach it to the Telegram node.
7. Create a Google Sheet with these column headers in row 1: Channel User Name, Channel Name, Channel Link, Channel ID. Add channel handles in the Channel User Name column, for example @ExampleChannel.
8. Open the Google Sheets nodes and select your spreadsheet and the correct sheet tab. Confirm the sheet fields map to the correct columns.
9. Run the channel list helper: use the manual trigger path to execute Read Channel Names1, Get Channels, and Update Google Sheet. This fills Channel Name, Channel Link, and Channel ID for each handle.
10. Open the Create Playlist node and adjust the title format if needed. Keep the delete step disconnected for the first full run, since there is no prior playlist to remove.
11. Click Execute to test the main path. Confirm a new playlist is created, recent videos are added, and a Telegram message is received. If no videos appear, add more channels or widen the time window.
12. Reconnect the delete step once you have one successful day. Turn on the schedule trigger and set your time zone so it runs daily at 07:15.