YouTube comment sentiment analysis with Google Gemini AI and Google Sheets

by Davide Boizza ✓ · 708 views · created 2025-05-08 · Market Research, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Gemini Chat Model and QuickChart.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Get comments (Google Sheets): uses Google Sheets
2. ID Video (Edit Fields (Set)): sets or maps fields
3. Loop Over Comments (Loop Over Items (Split in Batches)): loops over the items in batches
4. Get API Comments (HTTP Request): calls an HTTP API
5. Sentiment Analysis: scores sentiment with AI, with model: Google Gemini
6. Multipage? (If): checks a condition and branches into true / false
7. Comments (Code): runs custom JavaScript code
8. Update sentiment (Google Sheets): uses Google Sheets
9. nextPageToken (Edit Fields (Set)): sets or maps fields
10. Split comments (Split Out): splits a list into separate items

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Gemini Chat ModelQuickChart

Before you upgrade to n8n 3.0

Nodes used (11)

• Manual Triggern8n-nodes-base.manualTrigger
• Sentiment Analysis@n8n/n8n-nodes-langchain.sentimentAnalysis
• Coden8n-nodes-base.code
• Split Outn8n-nodes-base.splitOut
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• QuickChartn8n-nodes-base.quickChart

From the author

This workflow automatically collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model (e.g., GPT, Claude or Gemini). The sentiment (Positive, Neutral, or Negative), its strength, and confidence score are…

View the original on n8n.io → Check your own copy