YouTube comment sentiment analyzer with Google Sheets OpenA
🚀 YouTube Comment Sentiment Analyzer with Google Sheets & OpenAI --- Who Should Use This? Influencers, marketers, and data teams who need instant insights i...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
🚀 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 1. **Dynamic Input** Read a list of YouTube URLs from your Google Sheet. 2. **Full Comment Harvest** Pull **all** top-level comments (handles pagination 100/page). 3. **Deep Sentiment Scan** Classify each comment as **Positive**, **Neutral**, or **Negative** using OpenAI. 4. **Smart Formatting** Capture metadata (author, likes, timestamp) alongside sentiment. 5. **Seamless Storage** Append or update rows in your Google Sheet—ready for reporting.
---
Easy Setup 1. **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. 2. **Enable YouTube API** - Activate Data API v3 in Google Cloud, grab an API key, and save as an HTTP credential in n8n. 3. **Configure OpenAI** - Enter your API key under the “OpenAI Chat” credential in n8n. 4. **Import the Workflow** - Paste the provided JSON into n8n. 5. **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``
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
_YouTube_comment_sentiment_analyzer_with_Google_Sheets_OpenA.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Social Media & Content Workflows
View All in Social Media & Content →AI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Auto-Tagging for WordPress Posts
Production-ready n8n automation template for AI Auto-Tagging for WordPress Posts built by AhiXLight. Seamlessly connects Lm Chat Open Ai, Output Parser Autofixing, Output Parser Structured with 32 configured nodes.
AI Image Caption Generator Overlay
Production-ready n8n automation template for AI Image Caption Generator Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.
AI Image Caption Generator with Overlay
Production-ready n8n automation template for AI Image Caption Generator with Overlay built by AhiXLight. Seamlessly connects Lm Chat Google Gemini, Output Parser Structured, Edit Image with 16 configured nodes.