YouTube Channel Analytics Bot: Telegram + Sheets + Gemini Report (n8n)

YouTube Channel Analytics Bot for n8n: Telegram reports + Google Sheets snapshots + Gemini insights

Send a YouTube channel link to a Telegram bot, and this n8n workflow automatically pulls the channel’s latest performance, calculates velocity and baseline benchmarks, logs a snapshot to Google Sheets, and returns a structured analytics report generated by Google Gemini back in Telegram.

What this workflow does

• Telegram trigger & input parsing: When a new Telegram message arrives, the workflow extracts a YouTube channel ID or @handle from the text.
• Validation & friendly help: If no channel identifier is found, it replies in Telegram with usage instructions.
• YouTube Data API enrichment: It resolves channel details, then fetches the channel’s uploads playlist and retrieves the latest 20 uploads.
• Batch stats retrieval: It batches YouTube Data API requests to collect video stats and metadata for each upload.
• Velocity + metrics computation: The workflow calculates per-video metrics (e.g., views per hour, age, duration, chapters, engagement per 1,000 views), ranks videos by velocity, and computes baseline/fingerprint benchmarks such as cadence, format splits, title patterns, and trends.
• Baseline logic + logging: If fewer than five videos older than 48 hours exist, it sends a “no baseline” message in Telegram; otherwise, it appends a snapshot row to Google Sheets.
• Gemini report generation: It sends computed metrics to Google Gemini to produce a five-section analysis, then posts the final channel report to Telegram.

Use cases

• Track YouTube channel velocity and benchmark trends for SaaS content performance.
• Automate creator/channel research: compare cadence, format mix, and title pattern shifts.
• Operational reporting for marketing teams: get a ready-to-share Telegram summary with Sheets logging for history.

Technical details

• n8n nodes: Telegram, if, set, sort, split out, aggregate
• APIs/Services: YouTube Data API, Google Sheets, Google Gemini

Setup: Create a Telegram bot, add your Telegram credentials in n8n, and enable the Telegram Trigger.