Track Trustpilot reviews with Scrapio, Google Sheets and Slack alerts
UnknownWhat this workflow does
This workflow has 19 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Scrapio (community).
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Set Businesses to Track (Edit Fields (Set)): sets or maps fields
- Read Review History (Google Sheets): read
- Read Review Log (Google Sheets): read
- Combine Businesses with History (Merge): merges the data from its input branches
- Aggregate: combines items into one
- Filter: keeps only the items that match a condition
- Split Out: splits a list into separate items
- Aggregate: combines items into one
- Fetch Trustpilot Reviews (Scrapio): reviews (trustpilot)
- Build Weekly Summary (Edit Fields (Set)): sets 5 fields: total, averageRating, lowCount…
…plus 7 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapio is verified or supports 3.0 (used in Fetch Trustpilot Reviews).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Split Out
n8n-nodes-base.splitOut - Scrapio
n8n-nodes-scrapio.scrapio - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Slack
n8n-nodes-base.slack - Filter
n8n-nodes-base.filter
From the author
Quick Overview This workflow checks Trustpilot reviews daily via Scrapio, logs new reviews to Google Sheets, and posts Slack alerts based on star ratings, then sends a weekly Slack digest summarizing the last 7 days of review activity. How it works 1. Runs…