YouTube Comment Sentiment Analyzer with Sheets & OpenAI
Automates pulling YouTube comments via API, analyzes sentiment using OpenAI (Positive/Neutral/Negative), and logs results with metadata to Google Sheets for quick insights.
This workflow streamlines YouTube comment analysis by reading video URLs from a Google Sheet, fetching all top-level comments (handling pagination at 100/page via YouTube Data API v3), and using OpenAI to classify each as Positive, Neutral, or Negative. It captures key metadata like author, likes, and timestamp, then appends or updates formatted results back to your Google Sheet, ready for charts, reports, or further automation.
Benefits include eliminating manual exports and tagging, saving ho
Platform
n8n
Category
Sales
Price
$22.99
Creator
Matt Buds
YouTube
Sentiment Analysis
OpenAI
Google Sheets
AI Analytics
Marketing Automation
Comment Analysis
Sales Insights
Video Feedback
Pagination
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.