YouTube Audience Comment Analyzer
detail.loadingPreview
Analyzes YouTube comments to extract sentiment and structured metadata.
About This Workflow
This n8n workflow is designed to extract, process, and analyze YouTube video comments to provide structured insights into audience feedback. It leverages the YouTube API to fetch comments and an AI model (Google Gemini or OpenAI) to determine the sentiment (Positive, Neutral, Negative) of each comment. The results are then stored in a Google Sheet, offering a comprehensive view of audience sentiment for creators, marketers, and social media managers.
Key Features
- Automated Comment Fetching: Retrieves comments from specified YouTube videos using the YouTube API.
- Sentiment Analysis: Utilizes AI models (Google Gemini or OpenAI) to classify comment sentiment.
- Structured Metadata Generation: Organizes comment data, sentiment, and video information into a structured format.
- Google Sheets Integration: Reads video URLs from and writes analysis results to Google Sheets.
- Error Handling: Includes checks for empty URLs, API response success, and the existence of comments.
- Status Tracking: Updates the status of processed video URLs in Google Sheets to prevent reprocessing.
How To Use
- Import Workflow: Download and import the workflow JSON into your n8n instance.
- Set up Google Sheets: Create a Google Sheet with two tabs: 'Video URLs' and 'Results'. In the 'Video URLs' tab, add a 'status' column (initially 'Ready') and a 'video_url' column. In the 'Results' tab, define columns for 'video_url', 'comment_id', 'comment', 'author_name', 'likes', 'reply', 'sentiment', and 'published_at'.
- Configure Credentials: Set up and connect your Google Sheets API, YouTube Data API (OAuth2), and an AI model API (e.g., Google Gemini or OpenAI) within n8n.
- Populate Video URLs: Enter YouTube video URLs in the 'video_url' column of the 'Video URLs' tab and set their 'status' to 'Ready'.
- Execute Workflow: Manually trigger the workflow via n8n's 'Test workflow' or 'Execute workflow' button.
- View Results: Check the 'Results' tab in your Google Sheet to see the analyzed comments and their sentiments.
Apps Used
Workflow JSON
{
"id": "e66ff883-000a-492f-819e-60aa4e8bdd30",
"name": "YouTube Audience Comment Analyzer",
"nodes": 28,
"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: e66ff883-000a...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
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.
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.