🚀 YouTube comment sentiment analyzer with Google Sheets & OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Video Urls from Google Sheet (Google Sheets): uses Google Sheets
- check next fetch time is available or not (If): checks a condition and branches into true / false
- Get Comments for video urls (HTTP Request): calls an HTTP API
- check next fetch time is before the current time (If): checks a condition and branches into true / false
- Check Success Response (If): checks a condition and branches into true / false
- Split Out: splits a list into separate items
- Analyze sentiment of every comment (Sentiment Analysis): scores sentiment with AI, with model: OpenAI Chat Model
- Format fields as required to save in google sheet (Edit Fields (Set)): sets or maps fields
- Insert and update comment in google sheet (Google Sheets): uses Google Sheets
- Update last fetched time and next_fetch_time (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Split Out
n8n-nodes-base.splitOut - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Sentiment Analysis
@n8n/n8n-nodes-langchain.sentimentAnalysis - Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
🚀 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…