Fetch YouTube videos and send updates to Telegram from Google Sheets
Workflow Description
Automation that reads channel names from Google Sheets, retrieves video data from YouTube, filters results based on criteria, and sends selected video information to Telegram channels on a scheduled basis.
How it works
- 1.Trigger the workflow on a defined schedule using the scheduler
- 2.Extract channel names and search parameters from Google Sheets rows
- 3.Call YouTube API to fetch video and channel metadata for specified topics
- 4.Apply filters to identify and select relevant videos
- 5.Format video data and send messages to Telegram channels
- 6.Log sent videos back to Google Sheets for tracking
Use cases
- Monitor multiple YouTube channels and notify development teams of new releases
- Aggregate topic-specific videos and distribute them to Telegram work groups
- Track educational or technical content from selected channels and archive in shared sheets
Requirements
- Google account with read/write access to Google Sheets
- YouTube Data API key configured and enabled
- Telegram account with access to channels or groups for sending messages
- Google Sheet containing channel names or search keywords
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (23)
Read Channel Names
Google Sheets
Get Videos
HTTP Request
Split Out
Split Out
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Create Playlist
You Tube
Delete Old Playlist
You Tube
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
YouTube
You Tube
Sticky Note4
Sticky Note
Filter Out Upcoming
Filter
Save Playlist ID
Google Sheets
Google Sheets
Google Sheets
Telegram
Set
Sticky Note5
Sticky Note
0715 Trigger
Schedule Trigger
Get Channels
HTTP Request
Update Google Sheet
Google Sheets
When clicking ‘Test workflow’
Manual Trigger
Read Channel Names1
Google Sheets
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note