🧠 Sentiment Analysis of Product Reviews using Google Sheets & OpenAI
🚀 Quick Implementation Steps
Automated customer feedback analyzer:
- Trigger: Google Sheets triggers on new product review rows.
- Sentiment Analysis: Review text sent to OpenAI.
- Writeback: Resulting sentiment (Positive, Neutral, Negative) is written back to the sheet.
Just connect your credentials and sheet — you're ready to go!
🔍 What It Does
This workflow automatically analyzes user-submitted product reviews and classifies them by sentiment using OpenAI’s powerful language models. It eliminates the need to manually sift through feedback by tagging each review with a sentiment score.
The sentiment result is then written back to the Google Sheet next to the original review, enabling you to get a fast, clear snapshot of overall customer perception, satisfaction and pain points. Whether you're monitoring 10 or 10,000 reviews, this process scales effortlessly and updates every minute.
👤 Who’s It For
This workflow is designed for:
- E-commerce teams collecting user reviews.
- Product teams monitoring customer feedback.
- Marketing teams identifying promotable reviews.
- Support teams watching for negative experiences.
- SaaS platforms, apps, and survey tools managing structured text feedback.
✅ Requirements
You’ll need:
- A Google Sheet with two columns:
Review
and Sentiment
- Google Sheets OAuth2 credentials in n8n
- OpenAI API Key (for GPT-4o-mini or GPT-3.5)
- n8n instance with LangChain and OpenAI nodes enabled
⚙️ How It Works
- Google Sheets Trigger: Watches for new rows every minute
- OpenAI Integration:
- Uses LangChain’s
Sentiment Analysis
node
- Passes review text into GPT-4o-mini via the
OpenAI Chat Model
node
- Sheet Update: The sentiment result (Positive, Negative, or Neutral) is written into the
Sentiment
column in the same row.
Sticky Notes included for better visual understanding inside the workflow editor.
🛠️ Steps to Configure and Use
1. Prepare Your Google Sheet
Make sure your sheet is named Sheet1
with the following structure:
Review |
Sentiment |
Absolutely love it! |
|
Not worth the price. |
|
2. Set Up Credentials
- Google Sheets: OAuth2 credentials
- OpenAI: API Key added via
OpenAI API
credential in n8n
3. Import & Activate Workflow
- Import the workflow JSON into your n8n instance.
- Assign the proper credentials to the trigger and OpenAI nodes.
- Activate the workflow.
🧩 How To Customize
- 🛎️ Alerting: Add Slack/Email nodes for negative sentiment alerts
- 🔄 Triggering: Change the polling interval to real-time triggers (e.g., webhook)
- 📊 Extended Sentiment: Modify sentiment categories (e.g., "Mixed", "Sarcastic")
- 🧾 Summary Report: Add Cron + Aggregation nodes for daily/weekly summaries
- 🧠 Prompt Tuning: Adjust system prompt for deeper or context-based sentiment evaluation
🧱 Add‑ons (Optional Features)
- Email Digest of Negative Reviews
- Google Drive Logging
- Team Notification via Slack
- Summary to Notion, Airtable, or Google Docs
📌 Use Case Examples
- Online Stores: Auto-tag reviews for reputation monitoring
- Product Teams: See which feature releases generate positive or negative buzz
- CX Dashboards: Feed real-time sentiment to internal BI tools
- Marketing: Extract glowing reviews for social proof
- Support: Triage issues by flagging critical comments instantly
...and many more applications wherever text feedback is collected.
🧰 Troubleshooting Guide
Issue |
Possible Cause |
Suggested Fix |
Sentiment not updating |
Sheet credentials missing or misconfigured |
Reconnect Google Sheets OAuth2 |
Blank sentiment |
Review column empty or misaligned |
Ensure proper column header & value present |
OpenAI errors |
Invalid or expired API key |
Regenerate API Key from OpenAI and re-auth |
Workflow doesn’t run |
Polling settings incorrect |
Confirm interval & document ID in trigger node |
🤝 Need Help?
If you need assistance for
- ✅ Help setting up this workflow
- ⚙️ Customizing prompts or output
- 🚀 Automating your full review pipeline
👉 Contact us today at WeblineIndia. We will be happy to assist.