AI E-commerce Review Alerts to Slack

Who it's for

E-commerce brands, Shopify stores, and customer support teams who receive product review notifications by email and need fast triage — without manually reading every review.

What it does

This workflow watches Gmail for review notification emails, extracts the customer, product, star rating, and review text, skips duplicates using a Google Sheets audit log, uses OpenAI to classify sentiment and urgency, routes alerts to different Slack channels, and logs structured results for reporting.

Urgent 1–2 star negative reviews go to an escalation channel. Other negative reviews go to your reviews channel. Positive reviews can be routed to a wins channel. Neutral reviews are logged without sending Slack noise.

How it works

1. Gmail Review Trigger polls Gmail for new unread emails with the Reviews label
2. Configure Review Alert Settings sets sheet ID, Slack channels, and urgency thresholds
3. Extract Review From Email parses star rating, product, customer, and review body from common notification formats
4. Read Review Audit Log loads existing processed reviews from Google Sheets
5. Check for Duplicate Review compares Gmail message IDs to prevent repeat alerts
6. Is New Review continues only for new reviews with usable text
7. Classify Review with OpenAI returns sentiment, urgency, themes, summary, and suggested action
8. Parse AI Classification Results determines the routing path (urgent, negative, positive, neutral)
9. Route by Sentiment Priority branches to the correct notification path
10. Format Slack Alert Message and Send Slack Alert post channel-specific alerts when needed
11. Log Review to Sheets appends a full audit row for every processed review

Setup steps

1. Import the workflow JSON into n8n
2. In Gmail, create a Reviews label and filter review notification emails into it (Shopify, Judge.me, Amazon, etc.)
3. Create a Google Sheet tab named Reviews with columns: Received At, Message ID, Customer, Product, Star Rating, Review Text, Sentiment, Urgency, Score, Themes, Summary, Suggested Action, Route, Slack Sent
4. Open Configure Review Alert Settings and set GOOGLE_SHEET_ID, SHEET_NAME, and your three Slack channel names
5. Connect Gmail OAuth2 on Gmail Review Trigger
6. Connect Google Sheets OAuth2 on Read Review Audit Log and Log Review to Sheets
7. Connect OpenAI API credentials on Classify Review with OpenAI
8. Connect Slack OAuth2 on Send Slack Alert
9. Forward or trigger a test review email, then activate the workflow

Requirements (optional form fields — add one line each)

n8n Cloud or self-hosted n8n instance Gmail account with OAuth2 credentials configured in n8n Google Sheets account with OAuth2 credentials configured in n8n OpenAI API key configured in n8n Slack workspace with OAuth2 credentials configured in n8n A Google Sheet with the recommended column headers

Customization (optional form fields — add one line each)

Change the Gmail label filter on Gmail Review Trigger Edit Slack channel names and URGENT_STAR_THRESHOLD in Configure Review Alert Settings Tune email parsing patterns in Extract Review From Email for your review platform Adjust routing rules in Parse AI Classification Results Modify the AI prompt or model in Classify Review with OpenAI

Additional info (optional — paste as one block)

This template is based on the "E-commerce Review Sentiment Alert" use case: revenue-linked feedback triage with AI classification, duplicate protection, and multi-channel routing. Unlike a basic form-to-Slack notifier, it adds audit logging, escalation logic, and actionable AI summaries so support teams can respond faster to damaging reviews while celebrating positive ones.

Ideas to extend

• Auto-draft a customer reply in Gmail for urgent negative reviews
• Post weekly sentiment rollups to Slack with a Schedule trigger
• Sync high-priority reviews into a CRM or helpdesk ticket
• Add a second AI pass to detect fake or spam reviews