Automate YouTube Comment Sentiment Analysis with AI
detail.loadingPreview
Effortlessly gauge audience sentiment on your YouTube videos. This n8n workflow automatically pulls comments from your videos via Google Sheets, analyzes their sentiment using advanced AI, and organizes the results for deeper insights.
About This Workflow
Unlock valuable audience feedback with the YouTube Comment Sentiment Analyzer. This powerful n8n workflow streamlines the process of understanding what your viewers truly think. It begins by fetching video URLs from a designated Google Sheet, then systematically retrieves comments for each video using the YouTube API. Leveraging the cutting-edge capabilities of OpenAI's GPT-4o-mini model, each comment is analyzed for its sentiment – classifying it as Positive, Neutral, or Negative. The workflow then meticulously formats the extracted data, including comment ID, video URL, original comment text, author, and like count, preparing it for seamless storage back into a Google Sheet. Gain actionable insights into viewer perception and drive content strategy with this intelligent automation.
Key Features
- Automated Data Ingestion: Seamlessly pull YouTube video URLs from your Google Sheets.
- AI-Powered Sentiment Analysis: Utilize advanced AI models (GPT-4o-mini) to classify comment sentiment (Positive, Neutral, Negative).
- Comprehensive Data Extraction: Gathers video URL, comment text, author, likes, and sentiment.
- Scalable Processing: Handles pagination to ensure all comments are analyzed.
- Organized Output: Formats data for easy import back into Google Sheets.
How To Use
- Connect Your Accounts: Set up credentials for Google Sheets and OpenAI within n8n.
- Configure Google Sheets Node: Specify your Google Sheet document and the sheet containing your YouTube video URLs.
- Configure YouTube API Node: Ensure your Google API credentials are set up to access the YouTube Data API.
- Set Up OpenAI Node: Select the GPT-4o-mini model and configure any specific parameters for sentiment analysis.
- Define Output Format: Use the 'Set' node to map the desired fields (commentId, video_url, comment, authorName, likes, sentiment) for your output.
- Save to Google Sheets (Optional): Add a Google Sheets 'Append' node to store the analyzed results back into your spreadsheet.
Apps Used
Workflow JSON
{
"id": "296289a7-96fe-4ffe-8ddc-03a5fe5e174d",
"name": "Automate YouTube Comment Sentiment Analysis with AI",
"nodes": 24,
"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: 296289a7-96fe...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
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.