📊 Analyze WooCommerce product reviews with GPT-4, Airtable & Slack summaries

⚡ 5 views · 📊 Market Research & Insights

Description

WooCommerce Product Reviews: Sentiment Analysis with Slack Summary

This workflow automatically fetches product reviews from your WooCommerce store, analyzes the sentiment of each review using AI, stores the results in Airtable and sends a summary of positive, neutral and negative reviews to Slack. It helps teams quickly understand overall customer feedback, track product sentiment and stay updated without manually reading all reviews.

Quick Start – Implementation Steps

1. Import the workflow JSON file into n8n.
2. Configure credentials:
   • WooCommerce HTTP Basic Auth (for fetching reviews)
   • OpenAI API (for sentiment analysis)
   • Airtable Personal Access Token (for storing reviews)
   • Slack API (for sending summary messages)
3. Adjust the Cron/Schedule Trigger node to your preferred interval (e.g., every 10 minutes).
4. Test the workflow with a few reviews to ensure AI and Slack integrations work correctly.
5. Activate the workflow after confirming functionality.

What It Does

This workflow automates sentiment analysis and team notification:

• Schedule Trigger – Runs the workflow automatically at defined intervals.
• Set WooCommerce Domain – Defines the WooCommerce store to fetch reviews from.
• Fetch Reviews – Retrieves all recent product reviews using WooCommerce API credentials.
• Loop Over Items – Processes reviews in smaller batches for efficiency.
• Message a Model – Sends each review to OpenAI to detect sentiment (positive, neutral, negative) and generate a short summary.
• Merge & Code Nodes – Combines original review data with AI results and ensures proper data alignment.
• If Node – Checks sentiment for further processing.
• Create a Record (Airtable) – Stores each review and its sentiment in Airtable.
• Code Summary Node – Counts positive, neutral, and negative reviews to create a summary.
• Send a Message (Slack) – Posts the sentiment summary to the team’s Slack channel for visibility.

Who’s It For

This workflow is ideal for:

• E-commerce managers tracking WooCommerce product feedback
• Customer support teams monitoring review sentiment
• Marketing and product teams seeking automated insights
• Teams using Airtable and Slack for data tracking and collaboration

Requirements to Use This Workflow

• An n8n instance (cloud or self-hosted)
• WooCommerce store with API access
• OpenAI API key for sentiment analysis
• Airtable account with base/table configured
• Slack workspace with API access for messaging
• Basic familiarity with APIs and workflow automation

How It Works

1. Schedule Trigger – Executes the workflow at the defined interval.
2. Set WooCommerce Domain – Configures which store to fetch reviews from.
3. Fetch Reviews – Retrieves all recent product reviews from WooCommerce.
4. Loop Over Items – Splits reviews into manageable batches.
5. Message a Model – Sends reviews to AI for sentiment analysis and short summary.
6. Merge & Code Nodes – Combines AI results with original review data and prepares it for storage and summary.
7. If Node – Checks review sentiment for saving or further processing.
8. Create a Record (Airtable) – Saves each review with sentiment and AI summary.
9. Code Summary Node – Counts the number of positive, neutral, and negative reviews.
10. Send a Message (Slack) – Sends a concise summary of review sentiment to the Slack channel.

Setup Steps

1. Import the workflow JSON into n8n.
2. Add credentials:
   • WooCommerce HTTP Basic Auth
   • OpenAI API
   • Airtable Personal Access Token
   • Slack API
3. Configure the WooCommerce domain in the Set WooCommerce Domain node.
4. Test the workflow with sample reviews to ensure AI outputs correctly.
5. Adjust the Schedule Trigger interval as needed.
6. Activate the workflow after confirming that data flows correctly from WooCommerce → AI → Airtable → Slack.

How To Customize Nodes

Schedule Trigger

• Adjust interval (minutes, hours, days) as needed.

Set WooCommerce Domain

• Replace with your store domain URL.

Fetch Reviews

• Update endpoint or filters if needed.
• Ensure WooCommerce credentials are correct.

Message a Model

• Change AI model or prompts to adjust sentiment analysis or summary style.

Create a Record (Airtable)

• Map additional fields if needed.
• Ensure the table has the necessary columns for sentiment, summary, rating, and product info.

Send a Message (Slack)

• Customize Slack message format.
• Change the channel ID to send summaries to the right team.

Optional Enhancements

• Include historical review trends.
• Automatically trigger notifications only for negative reviews.
• Send summaries to email or other messaging apps.
• Visualize sentiment trends in Airtable or external dashboards.

Use Case Examples

1. Automated Sentiment Tracking – Understand customer feedback without manual reading.
2. Team Alerts – Notify product and support teams about negative reviews quickly.
3. Data Storage & Reporting – Keep historical sentiment in Airtable for trend analysis.
4. Efficient Batch Processing – Process large number of reviews without overloading the system.

Troubleshooting Guide

Need Help?

If you need assistance setting up the workflow, customizing AI sentiment analysis or integrating Slack summaries, feel free to contact our n8n development team at WeblineIndia. We provide workflow automation, AI integration and reporting solutions for WooCommerce stores.

🔗 Nodes Used

Airtable, HTTP Request, Slack, Schedule Trigger, OpenAI

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup