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 Ge

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 videourls 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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.