Scrape Trustpilot Reviews to Google Sheets & HelpfulCrowd CSV

This n8n workflow scrapes Trustpilot reviews for a specified business profile (e.g., n8n.io from https://www.trustpilot.com/review/n8n.io), handling pagination to collect comprehensive review data. It outputs to a pre-configured Google Sheets template with two sheets: 'trustpilot' for raw reviews and 'helpfulcrowd' formatted per HelpfulCrowd's import guide, including a custom review_id for upsert support. After running, simply export the helpfulcrowd sheet as CSV and upload to HelpfulCrowd for seamless review integration.

Key benefits include time-saving automation of manual review collection, enabling businesses to aggregate social proof without coding. It supports on-demand or scheduled runs, making it perfect for ongoing review monitoring. Requirements are minimal: update the business name and pagination in the Global node, and set up Google Sheets API credentials.

Use cases span e-commerce, SaaS, and service businesses needing landing page testimonials. Import reviews to HelpfulCrowd for product displays, boosting credibility and conversions. Customize sheets for additional analytics or integrations, scaling effortlessly with n8n's no-code power.