{"product_id":"n8n-workflow-track-trustpilot-reviews-to-google-sheets-slack","title":"n8n Workflow: Track Trustpilot Reviews to Google Sheets \u0026 Slack","description":"\u003ch3\u003eTrack Trustpilot reviews automatically—log them to Google Sheets and get Slack alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks Trustpilot reviews every day, records only new reviews in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts targeted alerts to \u003cstrong\u003eSlack\u003c\/strong\u003e based on star ratings. Once a week, it also sends a digest summarizing the last 7 days of review activity.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDaily scheduled run:\u003c\/strong\u003e loads the list of business domains to monitor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates reviews:\u003c\/strong\u003e reads the existing review log from Google Sheets and compares it per domain.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches latest reviews with Scrapio:\u003c\/strong\u003e uses \u003cstrong\u003eScrapio\u003c\/strong\u003e to retrieve Trustpilot reviews and keeps only reviews not already logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new review data to Google Sheets:\u003c\/strong\u003e records rating, title, text, reviewer details, and timestamps (e.g., published_date and logged_at).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStar-rating routing to Slack:\u003c\/strong\u003e posts alerts to the appropriate channel for low ratings, great reviews, or neutral updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly summary digest:\u003c\/strong\u003e on a separate schedule, calculates a 7-day summary from the Sheets log (total reviews, average rating, high\/low counts, and worst review) and posts it to Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e who need fast visibility into Trustpilot sentiment changes without manual checking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReputation \u0026amp; support teams\u003c\/strong\u003e using Slack alerts to respond quickly to low-star reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e standardizing review tracking workflows with Google Sheets reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMulti-location brands\u003c\/strong\u003e monitoring several domains and summarizing performance weekly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eScrapio\u003c\/strong\u003e (Trustpilot review retrieval), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read + append), \u003cstrong\u003eSlack\u003c\/strong\u003e (channel alerts + digest).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e set, code, merge, slack, filter, switch.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e provide a Scrapio API credential with Trustpilot review scraping enabled; configure Google Sheets spreadsheet\/sheet and ensure expected header columns (e.g., domain, review_id, rating, title, text, consumer_name, is_verified, published_date, logged_at); connect Slack and set channel IDs.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114682798259,"sku":"N8N-20016","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/5jXqiGk25lE_xYUZv17zO_Me9PFvWB.png?v=1790586622","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-trustpilot-reviews-to-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}