YT AI News Playlist Creator/AI News Form Updater
Configured with Filter, Google Sheets, HTTP Request, Schedule Trigger, and additional nodes. Review the connections and setup before adapting this template.
Node categories in this workflow
- Data store
- Web / API
- Transform
- Files / media
- Routing
- Messaging
- Trigger
Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.
Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.
How it works
The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.
| Node | Category | Type | Operation |
|---|---|---|---|
| Read Channel Names | Data store | Google Sheets | See node parameters |
| Get Videos | Web / API | HTTP Request | See node parameters |
| Split Out | Transform | Split Out | See node parameters |
| Create Playlist | Files / media | You Tube | playlist / create |
| Delete Old Playlist | Files / media | You Tube | playlist / delete |
| YouTube | Files / media | You Tube | playlistItem |
| Filter Out Upcoming | Routing | Filter | See node parameters |
| Save Playlist ID | Data store | Google Sheets | update |
| Google Sheets | Data store | Google Sheets | See node parameters |
| Telegram | Messaging | Telegram | See node parameters |
| 0715 Trigger | Trigger | Schedule Trigger | See node parameters |
| Get Channels | Web / API | HTTP Request | See node parameters |
| Update Google Sheet | Data store | Google Sheets | update |
| When clicking ‘Test workflow’ | Trigger | Manual Trigger | See node parameters |
| Read Channel Names1 | Data store | Google Sheets | See node parameters |
Setup
- Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
- Connect your own credentials through n8n’s credential store. Replace
REPLACE_WITH_*values with your resource identifiers. - Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
- Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.
Requirements
An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.
Credential types declared in the source
googleSheetsOAuth2ApitelegramApiyouTubeOAuth2Api
Workflow notes
Initiation
Initiation
This section starts the workflow sets the time.
Getting the Videos
Getting the Videos
This section grabs the videos.
Delete Yesterday's Playlist
Delete Yesterday's Playlist
This section deletes the playlist created yesterday. (do not include this on your first run; or, your workflow will stop)
Create New AI News Playlist
Create New AI News Playlist
This section creates today's playlist.
Add Videos to Playlist
Add Videos to Playlist
This section adds videos to the playlist created today.
Create your Channel List
Create your Channel List
This section needs to be put into it's own workflow: this workflow gathers information needed to gather videos for the playlist. This workflow only needs to be run when a new channel name is added to the Google Sheet.
Instructions
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 look for this 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; but for the first time, 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.
YT AI News Playlist Creator/AI News Form Updater
YT AI News Playlist Creator/AI News Form Updater
Purpose and structure
This folder contains the YT AI News Playlist Creator/AI News Form Updater workflow. Its executable nodes use filter, googleSheets, httpRequest, manualTrigger, scheduleTrigger, splitOut, telegram, youTube. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.
Setup
Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.
Entry points
0715 Trigger, When clicking ‘Test workflow’
Verification
Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.
Attribution
https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Telegram/0742_Telegram_Splitout_Create_Webhook.json MIT; preserve source notices.
Canvas section labels
These name areas of the original canvas; they do not include explanatory instructions.
- Notification of Completion (optional)