Monitor negative customer reviews with an HTTP API, Google Sheets and Slack
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs on a schedule (every 6 hours) (plus 1 other trigger). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: On a schedule (every 6 hours) (plus 1 other trigger).
- Fetch Latest Reviews (HTTP Request): calls an HTTP API
- Get Processed Review IDs (Google Sheets): uses Google Sheets
- Alert Team on Monitor Failure (Slack): uses Slack
- Normalize Review Data (Edit Fields (Set)): sets 5 fields: review_id, rating, author…
- Combine Reviews and Log (Merge): merges the data from its input branches
- Filter Negative Reviews (Code): runs custom JavaScript code
- Filter Out Already Processed (Code): runs custom JavaScript code
- Any New Negative Reviews (If): checks a condition and branches into true / false
- Classify Severity (If): checks a condition and branches into true / false
- Alert Manager Urgent (Slack): uses Slack
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick Overview This workflow polls your review API every 6 hours, filters for reviews rated 3 stars or lower, and posts an alert to a Slack channel for each negative review. How it works 1. Runs every 6 hours on a schedule. 2. Fetches the latest reviews from…