Agoda Negative Review Alerts to Slack & Google Sheets (n8n)

Agoda complaint alerts, automated to Slack and tracked in Google Sheets

This n8n workflow monitors new Agoda hotel reviews every morning, filters out only the new complaints (score ≤ 6/10, written), logs them to Google Sheets, and posts each one to Slack the same day—so reputation teams can react fast without manual checking.

What this workflow does

• Runs daily at 08:00 using an n8n Schedule Trigger.
• Fetches Agoda reviews via Apify: sends an HTTP POST to the Agoda Reviews Scraper run-sync endpoint (50 most recent reviews per hotel).
• Keeps only new “complaint” reviews: a Code node retains rows where type = review, includes only reviews with rating ≤ 6/10 and written text, and de-duplicates using stored review_ids (up to 5,000 IDs via static workflow data).
• Trims review text to the first 300 characters for clean alerts.
• Appends to Google Sheets one row per new flagged review.
• Posts to Slack one message per new complaint review.
• If no new complaints are found, it stops in a NoOp.

Use cases

• Hotel GM reputation management: catch low-scoring Agoda feedback early and respond before it escalates.
• Revenue & reputation monitoring: track recurring issues across multiple properties.
• Agencies managing a portfolio: get instant Slack alerts plus a running Google Sheets log per review.

Technical details

• n8n nodes: if, code, no op, slack, and sticky note (for node hints/documentation).
• Apify integration: calls the Agoda Reviews Scraper actor using n8n HTTP Request with Header Auth (Authorization: Bearer <your Apify token>).
• Data storage: de-duplication via workflow static data (review_id history capped at 5,000).

Setup tip: update your hotelIds (or use hotelNames) and connect your Slack account and Google Sheets credentials in the respective nodes.