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

(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.