Analyze Youtube Comments Sentiment With Gemini Ai And Google Sheets 6086 – n8n Workflows – Free Template

What This Workflow Does

This n8n workflow automates the extraction and analysis of YouTube video comments to provide deep insights into your audience sentiment and engagement. Instead of manually reading through hundreds or thousands of comments, this intelligent system processes them automatically using AI-powered sentiment analysis and natural language processing to identify trends, concerns, and positive feedback from your viewers.

How It Works

The workflow begins with a manual trigger that initiates the process. It fetches comments from a specified YouTube video using an HTTP request to access the YouTube API. The comments are then split into manageable batches for efficient processing. Each batch is analyzed using multiple AI models including OpenAI’s advanced language model and Google’s Gemini for sentiment detection. The sentiment analysis node evaluates the emotional tone of each comment, while conditional logic filters and organizes results. Finally, all processed data is compiled and stored in Google Sheets for easy review and further analysis.

Use Cases

• YouTube creators wanting to understand viewer sentiment and identify common themes in audience feedback to improve content strategy
• Social media managers monitoring brand mentions and engagement quality across video campaigns to optimize future content
• Marketing teams tracking audience reaction to product launches or announcements to measure campaign success and identify concerns
• Community managers identifying toxic or spam comments that need moderation and positive feedback worth highlighting
• Content analysts researching viewer demographics and preferences by analyzing comment language patterns and sentiment across multiple videos

Nodes Used

• Manual Trigger – Initiates the workflow on demand
• HTTP Request – Fetches YouTube comments via API
• Split Out – Distributes comments for parallel processing
• Split In Batches – Groups comments into manageable chunks
• OpenAI Chat LM – Processes comments with advanced language understanding
• Google Gemini LM – Provides alternative AI analysis perspective
• Sentiment Analysis – Evaluates emotional tone of each comment
• If – Applies conditional logic to filter and route data
• Google Sheets – Stores analyzed results for reporting
• Sticky Note – Provides workflow documentation and notes

Prerequisites

• Active n8n account with workflow creation access
• YouTube Data API credentials and API key from Google Cloud Console
• OpenAI API key for GPT model access
• Google Gemini API credentials for alternative AI processing
• Google Sheets account with API enabled and a prepared spreadsheet for data storage
• YouTube video URL or video ID from the content you want to analyze

Difficulty Level

Intermediate. This workflow requires knowledge of API authentication, n8n node configuration, and basic understanding of batch processing. Users should be comfortable setting up multiple API credentials and mapping data between nodes, but the workflow structure itself is well-organized and clearly labeled for easy customization.

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