{"product_id":"youtube-channel-analytics-bot-telegram-sheets-gemini-report-n8n","title":"YouTube Channel Analytics Bot: Telegram + Sheets + Gemini Report (n8n)","description":"\u003ch3\u003eYouTube Channel Analytics Bot for n8n: Telegram reports + Google Sheets snapshots + Gemini insights\u003c\/h3\u003e\n\u003cp\u003eSend 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 \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and returns a structured analytics report generated by \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e back in Telegram.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram trigger \u0026amp; input parsing:\u003c\/strong\u003e When a new Telegram message arrives, the workflow extracts a YouTube channel ID or \u003ccode\u003e@handle\u003c\/code\u003e from the text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidation \u0026amp; friendly help:\u003c\/strong\u003e If no channel identifier is found, it replies in Telegram with usage instructions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eYouTube Data API enrichment:\u003c\/strong\u003e It resolves channel details, then fetches the channel’s uploads playlist and retrieves the latest \u003cstrong\u003e20 uploads\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBatch stats retrieval:\u003c\/strong\u003e It batches YouTube Data API requests to collect video stats and metadata for each upload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVelocity + metrics computation:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBaseline logic + logging:\u003c\/strong\u003e 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 \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGemini report generation:\u003c\/strong\u003e It sends computed metrics to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce a \u003cstrong\u003efive-section\u003c\/strong\u003e analysis, then posts the final channel report to Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack YouTube channel velocity and benchmark trends for SaaS content performance.\u003c\/li\u003e\n  \u003cli\u003eAutomate creator\/channel research: compare cadence, format mix, and title pattern shifts.\u003c\/li\u003e\n  \u003cli\u003eOperational reporting for marketing teams: get a ready-to-share Telegram summary with Sheets logging for history.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Telegram, if, set, sort, split out, aggregate\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAPIs\/Services:\u003c\/strong\u003e YouTube Data API, Google Sheets, Google Gemini\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup:\u003c\/strong\u003e Create a Telegram bot, add your Telegram credentials in n8n, and enable the Telegram Trigger.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876873953459,"sku":"N8N-18507","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/S0c6vZE4Tx0xnJOX6vIw5_zugv5feL.png?v=1787303538","url":"https:\/\/buyflowscripts.com\/products\/youtube-channel-analytics-bot-telegram-sheets-gemini-report-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}