{"product_id":"apify-n8n-sync-low-rated-tripadvisor-hotel-reviews-to-google-sheets","title":"Apify + n8n: Sync Low-Rated TripAdvisor Hotel Reviews to Google Sheets","description":"\u003ch3\u003eWeeklyly sync low-rated TripAdvisor hotel reviews into Google Sheets (with a built-in “Needs a reply” queue)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses the Apify \u003cstrong\u003eTripadvisor API\u003c\/strong\u003e actor to pull the latest hotel reviews every Monday, automatically flags reviews at or below your “bad review” rating threshold, and records \u003cstrong\u003eeverything\u003c\/strong\u003e in Google Sheets—so your team always knows which TripAdvisor reviews need attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday morning\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your configuration\u003c\/strong\u003e: the Tripadvisor hotel \u003cstrong\u003eplace IDs\u003c\/strong\u003e to monitor, how many recent reviews to pull per hotel, and the rating threshold for “bad reviews.” (Use the number after \u003cem\u003ed\u003c\/em\u003e in the TripAdvisor hotel URL, e.g., \u003ccode\u003ed143336\u003c\/code\u003e.)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the Apify actor\u003c\/strong\u003e \u003ccode\u003ejohnvc~tripadvisor-api\u003c\/code\u003e for each hotel to retrieve the latest reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to real review items\u003c\/strong\u003e (keeps rows that represent actual review content).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats review rows\u003c\/strong\u003e with a “Week of” run date, key review fields, and a \u003cstrong\u003eNeeds a reply\u003c\/strong\u003e flag when the rating is at or below your threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to two Google Sheets tabs\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eFlagged reviews go to a \u003cstrong\u003ereply queue\u003c\/strong\u003e tab for follow-up.\u003c\/li\u003e\n      \u003cli\u003eAll reviews (flagged and unflagged) go to a \u003cstrong\u003erunning history\u003c\/strong\u003e tab.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHoteliers and property managers who want a \u003cstrong\u003ereliable weekly review triage\u003c\/strong\u003e without manual searching.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running multiple properties who need a \u003cstrong\u003ecentral Google Sheets feed\u003c\/strong\u003e for reporting and internal workflows.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who want a clean pattern for \u003cstrong\u003eApify + n8n + Google Sheets\u003c\/strong\u003e data pipelines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify account\u003c\/strong\u003e (the free tier works) + Apify API token in n8n.\u003c\/li\u003e\n  \u003cli\u003eGoogle Sheets OAuth credential, selecting the target spreadsheet and the two sheet tabs (reply queue + running history).\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862254477491,"sku":"N8N-18045","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/I4N3ad-1PMDHmjWVylWqu_hDnfEkYb.png?v=1786958480","url":"https:\/\/buyflowscripts.com\/products\/apify-n8n-sync-low-rated-tripadvisor-hotel-reviews-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}