Apify + n8n: Sync Low-Rated TripAdvisor Hotel Reviews to Google Sheets

Weeklyly sync low-rated TripAdvisor hotel reviews into Google Sheets (with a built-in “Needs a reply” queue)

This n8n workflow uses the Apify Tripadvisor API actor to pull the latest hotel reviews every Monday, automatically flags reviews at or below your “bad review” rating threshold, and records everything in Google Sheets—so your team always knows which TripAdvisor reviews need attention.

What this workflow does

• Runs every Monday morning on a schedule.
• Reads your configuration: the Tripadvisor hotel place IDs to monitor, how many recent reviews to pull per hotel, and the rating threshold for “bad reviews.” (Use the number after d in the TripAdvisor hotel URL, e.g., d143336.)
• Calls the Apify actor johnvc~tripadvisor-api for each hotel to retrieve the latest reviews.
• Filters to real review items (keeps rows that represent actual review content).
• Formats review rows with a “Week of” run date, key review fields, and a Needs a reply flag when the rating is at or below your threshold.
• Appends to two Google Sheets tabs:
  • Flagged reviews go to a reply queue tab for follow-up.
  • All reviews (flagged and unflagged) go to a running history tab.

Use cases

• Hoteliers and property managers who want a reliable weekly review triage without manual searching.
• SaaS operators running multiple properties who need a central Google Sheets feed for reporting and internal workflows.
• Automation engineers who want a clean pattern for Apify + n8n + Google Sheets data pipelines.

Technical details

• Apify account (the free tier works) + Apify API token in n8n.
• Google Sheets OAuth credential, selecting the target spreadsheet and the two sheet tabs (reply queue + running history).
• n8n nodes used: if, set, code, gmail, slack, filter.