This post shows you how to build a production-grade bad-review alert system with n8n. We’ll pull reviews from Google Business Profile / Lieferando / TripAdvisor, normalize and score them, log to Google Sheets, and fire WhatsApp alerts for critical cases. You’ll get a downloadable starter template (JSON), a WhatsApp message template, and a Sheets header CSV — so you can import and go.
The problem
Reviews arrive on different platforms, at different times, and with different payload shapes. When a 1★ bomb lands and sits unanswered, it hurts conversion and ranking. Manually refreshing dashboards or inboxes doesn’t scale.
Goal:
- Check multiple sources on a schedule
- Normalize review data into a common schema
- Flag and alert on bad reviews (≤3★ or strong negative keywords)
- Log everything (for SLAs, QA, coaching)
- Fail gracefully and notify when your automation breaks
Architecture (one glance)
This is the blueprint we’ll build:
- Trigger: Schedule (e.g., every 15 minutes)