YouTube Comment Sentiment Analyzer
detail.loadingPreview
Automate the analysis of YouTube video comments to understand audience sentiment. This workflow leverages AI to process comments from a Google Sheet, categorizing them as Positive, Neutral, or Negative.
About This Workflow
Uncover the true feelings of your YouTube audience with the YouTube Comment Sentiment Analyzer workflow. This powerful automation solution connects to your Google Sheet containing video URLs, extracts comments using the YouTube API, and then employs advanced AI models (like GPT-4o-mini) to meticulously analyze the sentiment of each comment. The workflow categorizes sentiment into Positive, Neutral, and Negative, providing you with actionable insights into viewer perception. It's designed for ease of use, allowing you to quickly gain a deeper understanding of what your viewers are saying without manual effort. Drive engagement and refine your content strategy based on genuine audience feedback.
Key Features
- Automated Comment Extraction: Fetches comments directly from YouTube videos linked in your Google Sheet.
- AI-Powered Sentiment Analysis: Utilizes cutting-edge AI to accurately classify comment sentiment.
- Configurable Sentiment Categories: Define your desired sentiment labels (e.g., Positive, Neutral, Negative).
- Google Sheets Integration: Seamlessly reads video URLs and can be configured to write results back.
- Efficient Data Processing: Handles pagination for retrieving all comments from a video.
How To Use
- Google Sheets Setup: Create a Google Sheet with a column dedicated to YouTube video URLs. Ensure this sheet is shared and accessible.
- n8n Workflow Configuration:
- Get Video Urls from Google Sheet: Input your Google Sheet's Document ID and the specific Sheet Name containing your video URLs.
- Get Comments for video urls: Ensure the YouTube API key is correctly configured in the 'Query Auth account 4' credential.
- OpenAI Chat Model: Connect your OpenAI API key to the 'OpenAi account' credential.
- Analyze sentiment of every comment: Configure the system prompt to guide the AI on sentiment analysis categories and output format.
- Format fields as required to save in google sheet: Map the desired output fields (commentId, video_url, comment, authorName, likes, sentiment) from the previous nodes.
- Execute the Workflow: Run the workflow to begin fetching video URLs, extracting comments, analyzing sentiment, and processing the data.
Apps Used
Workflow JSON
{
"id": "88b55efb-b437-48dc-a4af-83b278b50fbc",
"name": "YouTube Comment Sentiment Analyzer",
"nodes": 27,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 88b55efb-b437...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.