🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI

Description

🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI

Who Should Use This?
Influencers, marketers, and data teams who need instant insights into audience sentiment—without manual exports or scattered tools.

The Challenge
Manual exports** from YouTube Studio
Time-consuming** sentiment tagging
Data scattered** across multiple platforms

Our workflow automates everything: from fetching comments to logging analysis—so you can focus on insights, not spreadsheets.

What You’ll Get
Dynamic Input
Read a list of YouTube URLs from your Google Sheet.
Full Comment Harvest
Pull all top-level comments (handles pagination 100/page).
Deep Sentiment Scan
Classify each comment as Positive, Neutral, or Negative using OpenAI.
Smart Formatting
Capture metadata (author, likes, timestamp) alongside sentiment.
Seamless Storage
Append or update rows in your Google Sheet—ready for reporting.

Easy Setup
Prepare Google Sheet
Create a sheet with a video_urls column (full YouTube links).
Add and authorize a Google Sheets Oauth or service-account credential in n8n.
Enable YouTube API
Activate Data API v3 in Google Cloud, grab an API key, and save as an HTTP credential in n8n.
Configure OpenAI
Enter your API key under the “OpenAI Chat” credential in n8n.
Import the Workflow
Paste the provided JSON into n8n.
Run Manually
Use the Manual Trigger node to start fetching and analyzing comments on demand.

Customize to Your Needs
Filter Comments**: Add an IF node to process only comments with specific keywords or minimum likes.
Automate Schedule**: Swap the Manual Trigger for a Cron node if you later want periodic runs.
Extended Analysis**: Swap sentiment classification for topic extraction, summarization, or translation by tweaking the LLM prompt.
Alternate Destinations**: Replace Google Sheets with Airtable, Notion, or any database node.

Tags
`YouTube Google Sheets OpenAI Sentiment Analysis n8n Manual Trigger`