Sentiment analytics visualizer
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 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets, QuickChart and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Select Google Sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Read Data from Google Sheet (Google Sheets): uses Google Sheets
- Sentiment Analysis: scores sentiment with AI, with model: OpenAI Chat Model
- Extract Number of Answers per Sentiment (Code): runs custom JavaScript code
- Update Google Sheet (Google Sheets): update
- Generate QuickChart (QuickChart): uses QuickChart
- Send Gmail with Sentiment Chart (Gmail): uses Gmail
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 (8)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Sentiment Analysis
@n8n/n8n-nodes-langchain.sentimentAnalysis - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - QuickChart
n8n-nodes-base.quickChart - Gmail
n8n-nodes-base.gmail
From the author
🧠 Sentiment Analyzer Google Sheets → OpenAI GPT-4o → QuickChart → Gmail --- 🚀 What this workflow does 1. Fetches customer reviews from a Google Sheet. 2. Classifies each review as Positive, Neutral or Negative with GPT-4o-mini. 3. Writes the sentiment back…