Analyze Youtube Comments Sentiment & Keywords With Gemini Ai And Telegram Reporting 7434 – n8n Workflows – Free Template

What This Workflow Does

The YouTube Comment Sentiment & Keyword Extractor is an automated workflow that analyzes YouTube video comments for sentiment and extracts key topics. It retrieves comment data from a Google Sheets spreadsheet, processes them using AI-powered language models, and delivers actionable insights through a Telegram report.

How It Works

The workflow follows this sequence:

• A scheduled trigger runs the workflow at regular intervals
• Comments are fetched from Google Sheets containing YouTube video links or comment data
• Comments are split into batches for efficient processing
• Each batch is sent to an HTTP request node to retrieve additional data if needed
• The LLM chain analyzes sentiment (positive, negative, neutral) and extracts key topics and keywords
• Results are parsed into a structured format for consistency
• All processed comments are aggregated into a summary report
• The final report is sent to Telegram for team notification

Use Cases

• Brand Monitoring: Track customer sentiment across YouTube video comments to gauge brand perception and identify areas for improvement
• Content Strategy: Extract trending keywords and topics from viewer comments to inform future content creation and SEO optimization
• Customer Feedback Analysis: Automatically categorize customer opinions and pain points mentioned in video comments for product development teams
• Competitive Intelligence: Monitor competitor video comments to understand audience sentiment and common feature requests
• Community Management: Identify sentiment shifts and emerging issues in your video audience to enable faster community response

Nodes Used

• Schedule Trigger: Sets the automation schedule for regular workflow execution
• Google Sheets: Reads YouTube video links or comment data from a spreadsheet
• Split in Batches: Divides comments into manageable groups for processing
• HTTP Request: Fetches additional data or integrates with external APIs
• Set: Configures variables and data for processing steps
• Code: Custom JavaScript logic for data transformation or filtering
• Chain LLM: Connects multiple LLM operations in sequence for analysis
• Output Parser Structured: Converts LLM responses into consistent JSON format
• LM Chat OpenRouter: Accesses language models for sentiment analysis and keyword extraction
• Aggregate: Combines individual results into a unified summary report
• Telegram: Sends the final report to a Telegram channel or chat
• No Op: Placeholder node for workflow organization
• Sticky Note: Documentation within the workflow canvas

Prerequisites

• Active n8n instance (self-hosted or cloud)
• Google Sheets account with comment data prepared and shareable
• OpenRouter API key for LLM access (or alternative LLM provider credentials)
• Telegram bot token and chat ID for report delivery
• YouTube video URLs or comment data structured in Google Sheets
• Basic understanding of n8n workflows and node configuration

Difficulty Level

Intermediate. This workflow requires familiarity with Google Sheets integration, LLM setup, and Telegram bot configuration. The logic chain is straightforward, but users should understand how to obtain and secure API credentials.

This workflow template is shared under the n8n fair-code license. Free to use and modify.