Route ecommerce review alerts from Gmail to Slack with OpenAI and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 14 nodes and runs on Gmail events. Along the way it connects Gmail, Google Sheets and Slack.
How it runs
Trigger: On Gmail events.
- Setup Alert Configuration (Code): runs custom JavaScript code
- Extract Review Content (Code): runs custom JavaScript code
- Read Review Log in Sheets (Google Sheets): read (sheet)
- Verify Duplicate Review (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- OpenAI: message (text)
- Parse AI Classification (Code): runs custom JavaScript code
- Route by Sentiment (Switch): routes items into 4 branches
- Prepare Slack Message (Code): runs custom JavaScript code
- Build Neutral Log Entry (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in OpenAI Review Classifier: replace with OpenAI node (AI section).
- Also check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) OpenAI Review Classifier | OpenAI node (AI section) |
Nodes used (7)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - OpenAI
n8n-nodes-base.openAi - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow polls Gmail for unread ecommerce review notification emails, extracts key review details, checks Google Sheets to prevent duplicate processing, uses OpenAI to classify sentiment and urgency, posts routed alerts to Slack, and logs…