Analyze YouTube comments sentiment with Gemini AI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Gemini Chat Model and Google Sheets. It also calls googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Video URLs (Google Sheets): uses Google Sheets
- Check If Video URL is Not Empty (If): checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- HTTP Request: calls googleapis.com
- Check If - Success Response (If): checks a condition and branches into true / false
- Split Out: splits a list into separate items
- Check If - Comment Exists (If): checks a condition and branches into true / false
- AI Agent - Analyze Sentiment Of Every Comment (Sentiment Analysis): scores sentiment with AI, with model: Google Gemini Chat Model
- Update Video Status (Google Sheets): update
- Insert Comment Data & Analysis (Google Sheets): append or update
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
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 - Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Sentiment Analysis
@n8n/n8n-nodes-langchain.sentimentAnalysis
From the author
This n8n workflow demonstrates how to use this AI Agent to extract, process, and analyze YouTube video comments to understand your audience beyond the view count. Use cases are many: Whether you're a YouTube creator exploring feedback, a social media manager…