Analyze YouTube channel performance with Telegram, Google Sheets, and Gemini
Ready for 3.0What this workflow does
This AI workflow has 25 nodes and runs on Telegram events (message). Along the way it connects Telegram, Google Sheets and Google Gemini Chat Model. It also calls googleapis.com over HTTP.
How it runs
Trigger: On Telegram events (message).
- Set Channel Lookup Details (Edit Fields (Set)): sets 3 fields: chat_id, lookup_type, lookup_value
- If: checks a condition and branches into true / false
- Fetch YouTube Channel Info (HTTP Request): calls googleapis.com
- Notify Bad Channel Link (Telegram): uses Telegram
- If: checks a condition and branches into true / false
- Handle Telegram API Error (Telegram): uses Telegram
- Prepare Channel Data (Edit Fields (Set)): sets 5 fields: channel_id, channel_title, subs…
- Notify Channel Not Found (Telegram): uses Telegram
- Fetch Last 20 Uploads (HTTP Request): calls googleapis.com
- Split Uploads (Split Out): splits a list into separate items
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Telegram
n8n-nodes-base.telegram - Telegram Trigger
n8n-nodes-base.telegramTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Sort
n8n-nodes-base.sort - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview Youtube Video: https://youtu.be/0YnI8VsRe8?si=OLPAo4YOFSyfwCv9 This workflow listens for YouTube channel link sent to a Telegram bot, pulls channel and latest upload metrics from the YouTube Data API, computes velocity and baseline benchmarks,…