Connect Google Sheets with YouTube andTelegram
Workflow Description
An automation template that retrieves YouTube video data and stores it in a Google Sheets spreadsheet, then sends automatic notifications via Telegram when new content is detected or updates occur, enabling centralized channel monitoring for your team.
How it works
- 1.Activate the scheduled trigger to run automation at defined time intervals
- 2.Query YouTube video data using HTTP requests or the native YouTube connector
- 3.Filter results according to specific criteria and split data for processing
- 4.Store processed data in a Google Sheets spreadsheet
- 5.Send Telegram notifications to your channel or group with updates
Use cases
- Monitor a YouTube channel and document new videos in a centralized spreadsheet
- Send instant alerts to your team via Telegram when new content is published
- Track video statistics and store data for performance analysis
Requirements
- Google Cloud account with YouTube Data API enabled
- Google Sheets workspace with editing permissions
- Telegram bot with a valid channel link or group ID
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