Sentiment analysis of product reviews using Google Sheets & OpenAI
🧠 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:
ReviewandSentiment - 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 Analysisnode - Passes review text into GPT-4o-mini via the
OpenAI Chat Modelnode
- Uses LangChain’s
- Sheet Update: The sentiment result (Positive, Negative, or Neutral) is written into the
Sentimentcolumn 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 APIcredential 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.
Sentiment Analysis of Product Reviews Using Google Sheets and OpenAI
This n8n workflow automates the process of analyzing product review sentiment using OpenAI's language models and storing the results back into Google Sheets. It's designed to help businesses quickly gauge customer feedback and identify trends.
What it does
This workflow simplifies the process of sentiment analysis for product reviews by:
- Triggering on New Reviews: It listens for new rows added to a specified Google Sheet, treating each new row as a product review to be analyzed.
- Analyzing Sentiment with OpenAI: For each new review, it sends the review text to an OpenAI Chat Model.
- Performing Sentiment Analysis: It then uses a dedicated Sentiment Analysis node to determine the sentiment (e.g., positive, negative, neutral) of the review based on the OpenAI model's output.
- Updating Google Sheet with Results: Finally, it updates the original Google Sheet with the sentiment analysis results for each review.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running instance of n8n.
- Google Account: A Google account with access to Google Sheets.
- OpenAI API Key: An API key for OpenAI with access to their chat models.
- Google Sheets Credential: An n8n credential configured for your Google Sheets account.
- OpenAI Credential: An n8n credential configured for your OpenAI API key.
Setup/Usage
- Import the Workflow:
- Download the provided JSON file for this workflow.
- In your n8n instance, go to "Workflows" and click "New".
- Click the "Import from JSON" button and paste the workflow JSON or upload the file.
- Configure Google Sheets Trigger:
- Open the "Google Sheets Trigger" node.
- Select your Google Sheets credential.
- Specify the Spreadsheet ID and the Sheet Name where your product reviews are located.
- Ensure the trigger is set to "New Row".
- Configure OpenAI Chat Model:
- Open the "OpenAI Chat Model" node.
- Select your OpenAI credential.
- Configure the model and prompt as needed to process the review text. You will likely reference the incoming data from the Google Sheets Trigger (e.g.,
{{ $json.review_column_name }}).
- Configure Sentiment Analysis:
- Open the "Sentiment Analysis" node.
- Ensure it is correctly configured to receive the output from the OpenAI Chat Model as the text to be analyzed.
- Configure Google Sheets (Update):
- Open the "Google Sheets" node (the one after Sentiment Analysis).
- Select your Google Sheets credential.
- Specify the same Spreadsheet ID and Sheet Name as the trigger.
- Set the operation to "Update Row".
- Map the sentiment analysis result (e.g.,
{{ $json.sentiment }}) to a new column in your Google Sheet (e.g., "Sentiment"). You'll also need to map a unique identifier from the original row (like a row number or ID) to ensure the correct row is updated.
- Activate the Workflow:
- Click the "Activate" toggle in the top right corner of the n8n editor to set the workflow live.
Now, whenever a new row (product review) is added to your specified Google Sheet, this workflow will automatically analyze its sentiment and update the sheet with the result.
Related Templates
Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution
AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.
By MANISH KUMARTrack daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail
Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. ⚙️ How It Works Webhook – Mood → Collects new entries (🙂, 😐, or 😩) plus an optional note. Set Mood Data → Adds date, hour, and note fields automatically. Insert Mood Row → Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) → Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) → Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis → Generates insights, patterns, and 3 actionable recommendations. Gmail → Sends the full report (chart + AI text) to your inbox. 📊 Example Auto-Email Weekly Mood Summary (last 7 days) 🙂 5 ██████████ 😐 2 ████ 😩 0 Average: 1.7 (Positive 🙂) AI Insights: You’re trending upward this week — notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries 🔧 Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "🙂", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the “Insert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. 🔒 Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. 💡 Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects 🗒️ Sticky Notes Guide 🟡 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the “Insert Mood Row” node before running. 🟢 Weekly Summary Runs every Sunday 20:00 → aggregates last 7 days → generates AI insights + emails report. 🔵 Monthly Summary Runs on Day 1 at 08:00 → aggregates last 30 days → creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.
By Jose CastilloCreate, update, and get a person from Copper
This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.
By Harshil Agrawal