Sentiment analytics visualizer
n8n10 modulesv1.0Sentiment 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 to your sheet. 4. Builds a doughnut chart summarising the totals. 5. Emails the chart to your chosen recipient so the whole team stays in the loop. Perfect for support teams, product managers or anyone who wants a zero-code mood ring for their u
At a glance
Sentiment analytics visualizer is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Google Sheets, Discord. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Slack, Google Sheets, Discord, OpenAI
- Modules
- 10
- Price
- Free
- Version
- v1.0
About this workflow
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 to your sheet. 4. Builds a doughnut chart summarising the totals. 5. Emails the chart to your chosen recipient so the whole team stays in the loop. Perfect for support teams, product managers or anyone who wants a zero-code mood ring for their users’ feedback. --- 🗺️ Node-by-node tour | 🔩 Node | 💡 Purpose | | ------------------------------------------------------- | ---------------------------------------------------------- | | Manual Trigger | Lets you test the workflow on demand. | | Select Google Sheet | Points to the spreadsheet that holds your reviews. | | Loop Over Items | Feeds each row through the analysis routine. | | Sentiment Analysis (LangChain) | Calls GPT-4o-mini and returns only the sentiment category. | | Update Google Sheet | Writes the new Sentiment value into column C. | | Read Data from Google Sheet | Pulls the full sheet again to create a summary. | | Extract Number of Answers per Sentiment (Code node) | Tallies up how many reviews fall into each category. | | Generate QuickChart | Creates a doughnut (or pie) chart as a PNG. | | Send Gmail with Sentiment Chart | Fires the chart off to your inbox. | | (Sticky Notes) | Friendly setup tips scattered around the canvas. | --- 🛠️ Setup checklist | ✅ Step | Where | | ------------------------------------------------------------------------------------- | -------------------------------- | | Connect Google Sheets → paste your Spreadsheet ID & choose the correct sheet. | All Google Sheets nodes | | Add OpenAI credentials (sk-… key). | Sentiment Analysis node | | Configure Gmail OAuth2 + recipient address. | Gmail node | | Match your sheet columns → “Review title”, “Review text”, empty “Sentiment”. | Google Sheet itself | | (Optional) Switch to gpt-4o for maximum accuracy. | Sentiment Analysis “Model” param | --- 🏃♂️ How to run 1. Drop a few sample reviews into the sheet. 2. Click “Test workflow” on the Manual Trigger. 3. Watch each row march through → sentiment appears in column C. 4. After all rows finish, check your inbox for a fresh chart. ✔️ --- ✨ Ideas for next level Schedule the trigger (Cron) to auto-process new reviews daily. Feed the counts to Slack or Discord instead of email. Add a second GPT call to generate a short summary for each review. --- Happy automating! 🎉
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Post Slack messages for new Callingly calls
Send a message about a new presentation in Google Slides to Slack
Add a new row in Google Sheets for a new idea in ProdPad
Import Persons from Google Sheet to Attio
Multilingual WhatsApp translator with OpenAI Whisper & GPT-4 and HubSpot integration
Tesla 1hour indicators tool (mid-term technical analysis AI)
Automatically store Shopify orders in Google Sheets with Telegram notifications
Automated replies to X threads with Airtop browser automation
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you