🎫 Monitor low-rated WooCommerce reviews with Google Sheets, Slack and OpenAI
⚡ 12 views · 🎫 Ticket Management & Triage
Description
(Retail) Social Review Monitoring
This workflow automatically monitors WooCommerce product reviews, detects low-rated and approved reviews, checks whether the review already exists in Google Sheets, updates or inserts records accordingly, and sends a clear Slack alert generated using OpenAI for new low-rated reviews.
This workflow runs on a schedule, fetches WooCommerce product reviews, filters only approved reviews with low ratings (≤ 2 stars), checks if the review already exists in Google Sheets, and then:
- Updates the existing record if the review is already stored
- Generates a Slack alert using OpenAI and adds a new row if the review is new
You receive:
- Automated monitoring of customer reviews
- Centralized Google Sheets tracking for low-rated reviews
- Instant Slack alerts for new negative feedback
Ideal for support, product and operations teams who want fast visibility into unhappy customer feedback without manual checks.
What It Does
This workflow automates negative review detection and response:
- Runs automatically every 5 hours
- Fetches product reviews from WooCommerce
- Processes reviews one by one
- Filters only approved reviews
- Identifies low-rated reviews (≤ 2 stars)
- Checks if the review already exists in Google Sheets
- Updates existing records or inserts new ones
- Sends a professional Slack alert for new reviews
This ensures no duplicate alerts and keeps your review data up to date.
Who’s It For
This workflow is ideal for:
- E-commerce teams
- Customer support teams
- Product managers
- QA and operations teams
- Store owners monitoring customer satisfaction
Requirements to Use This Workflow
To run this workflow, you need:
- n8n instance (cloud or self-hosted)
- WooCommerce REST API credentials
- Google Sheets account with edit access
- Slack workspace with API permissions
- OpenAI API key
How It Works
- Scheduled Trigger – Workflow runs automatically every 5 hours
- Fetch Reviews – Pulls product reviews from WooCommerce
- Normalize Data – Extracts required fields
- Loop Reviews – Processes reviews one by one
- Approval Check – Allows only approved reviews
- Rating Check – Filters reviews rated 2 stars or lower
- Sheet Lookup – Checks if review ID already exists
- Decision Logic – Routes based on review existence
- AI Message Creation – Generates a Slack alert for new reviews
- Slack Notification – Sends alert to the configured channel
- Sheet Update – Updates or appends review data
Setup Steps
- Import the provided n8n workflow JSON file
- Configure WooCommerce HTTP Request node with your credentials
- Connect your Google Sheets account and select the correct sheet
- Connect your Slack account and choose a channel
- Add your OpenAI API key to the OpenAI node
- Verify column names match your Google Sheet
- Activate the workflow
How To Customize Nodes
Change Rating Threshold
Modify the Check Low Rating IF node:
- Adjust rating value (e.g., ≤ 3 stars)
- Add additional conditions if needed
Customize Slack Message
Edit the OpenAI prompt to:
- Change tone
- Add mentions
- Include product links
Customize Google Sheet
You can add extra columns such as:
- Response status
- Assigned team member
- Resolution notes
Add-Ons (Optional Enhancements)
You can extend this workflow to:
- Auto-create support tickets
- Send email alerts
- Detect repeated negative reviewers
- Add sentiment analysis
- Generate daily or weekly summary reports
Use Case Examples
1. Customer Support Alerts
Notify support teams instantly about negative feedback.
2. Product Quality Tracking
Identify recurring product issues early.
3. Review Auditing
Maintain a clean, duplicate-free review log.
Troubleshooting Guide
| Issue | Possible Cause | Solution |
|---|---|---|
| No Slack alert | Slack credentials missing | Reconnect Slack API |
| Duplicate rows | Review ID mismatch | Verify lookup column |
| Sheet update fails | Column name mismatch | Match sheet headers |
| Workflow not running | Trigger disabled | Enable Schedule Trigger |
Need Help?
If you need help customizing or extending this workflow with advanced features like adding ticketing, dashboards or analytics, then our n8n workflow developers at WeblineIndia will be happy to assist.
🔗 Nodes Used
Google Sheets, HTTP Request, Slack, Schedule Trigger, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File