Monitor low-rated WooCommerce reviews with Google Sheets, Slack and OpenAI

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.