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: 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 Prepare Your Google Sheet Make sure your sheet is named Sheet1 with the following structure: | Review | Sentiment | |---------------------------------------|-----------| | Absolutely love it! | | | Not worth the price. | | Set Up Credentials Google Sheets: OAuth2 credentials OpenAI: API Key added via OpenAI API credential in n8n 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.
By WeblineIndiaAudit interview feedback & report via Slack with GPT-4o-mini and Google Sheets
Description This workflow automates the evaluation of interviewer feedback using AI. It retrieves raw notes from Google Sheets, processes them through GPT-4o-mini for structured scoring, validates outputs, and calculates weighted quality scores. The system provides real-time Slack feedback to interviewers, logs AI errors for transparency, and recommends training if the feedback quality is low. What This Template Does (Step-by-Step) โก Manual Trigger โ Runs the workflow manually to start evaluation. ๐ Fetch Raw Feedback Data (Google Sheets) โ Reads all feedback entries (Role, Stage, Interviewer Email, Feedback Text, row_number). ๐ง AI Quality Evaluator (Azure GPT-4o-mini) โ Processes feedback into structured JSON across 5 dimensions. ๐ Analyze Feedback Quality (LLM Chain) โ Applies scoring rules (Specificity, STAR, Bias-Free, Actionability, Depth) and outputs structured JSON. โ Validate AI Response โ Ensures AI output isnโt undefined or malformed. ๐จ Log AI Errors (Google Sheets) โ Records invalid AI responses for debugging and auditing. ๐ Parse AI JSON Output (Code Node) โ Converts AI JSON text into structured n8n objects with error handling. ๐งฎ Calculate Weighted Quality Score (Code Node) โ Computes final weighted score (0โ100), generates flags, formats vague phrases, and preserves context. ๐พ Save Scores to Spreadsheet (Google Sheets) โ Updates the original feedback row with Score, Flags, and AI JSON. ๐ฌ Send Feedback Summary to Interviewer (Slack) โ Sends interviewers a structured Slack report (score, flags, vague phrases, STAR improvement tips). ๐ฏ Check if Training Needed โ Applies threshold logic: if score < 50, route to training recommendations. ๐ Send Training Recommendations (Slack) โ Delivers STAR method guides and bias-free interviewing resources to low scorers. Prerequisites Google Sheets (Raw_Feedback + Error Log Sheet) Azure OpenAI API credentials (for GPT-4o-mini) Slack API credentials (for sending feedback & training notifications) n8n instance (cloud or self-hosted) Key Benefits โ Automated interview feedback quality scoring โ Bias detection and vague feedback flagging โ Real-time Slack feedback to interviewers โ Error logging for AI reliability tracking โ Training recommendations for low scorers โ Audit trail maintained in Google Sheets Perfect For HR & Recruitment teams ensuring structured interviewer feedback Organizations enforcing STAR method & bias-free hiring Teams seeking continuous interviewer coaching Companies needing audit-ready records of interview quality
By Rahul Joshi