Scrape Trustpilot Reviews to Google Sheets

For Trustpilot, this automated workflow scrapes reviews and compiles them into Google Sheets, allowing users to efficiently manage customer feedback. It runs on a schedule, ensuring up-to-date data collection without manual effort. With a maximum of 100 pages scraped, it enhances data accessibility and analysis, streamlining the review management process.

7/8/2025
13 nodes
Medium
schedulemediumsticky notesplitoutgooglesheetsschedule triggerautomationadvancedapiintegrationcron
Categories:
Schedule TriggeredData Processing & AnalysisMedium Workflow
Integrations:
Sticky NoteSplitOutGoogleSheetsSchedule Trigger

Target Audience

This workflow is ideal for:
- Business Owners: Who want to gather customer feedback from Trustpilot to improve their products and services.
- Marketing Teams: Looking to analyze customer sentiment and enhance brand reputation through reviews.
- Data Analysts: Who need to compile and visualize review data for insights and reporting.
- Developers: Interested in automating the process of data collection from Trustpilot to Google Sheets for further analysis.

Problem Solved

This workflow addresses the challenge of manually collecting and organizing customer reviews from Trustpilot. It automates the process, ensuring that businesses can efficiently gather insights from customer feedback without the need for tedious manual entry. By integrating with Google Sheets, it allows for easy data manipulation and analysis, saving time and reducing errors.

Workflow Steps

  • Trigger the Workflow: The process begins with either a manual trigger or a scheduled trigger, allowing users to start the workflow at their convenience.
    2. Set Global Variables: Define the company ID and the maximum number of pages to scrape from Trustpilot for reviews.
    3. Fetch Reviews: An HTTP request is made to Trustpilot to retrieve reviews based on the defined parameters, including pagination to handle multiple pages of reviews.
    4. Parse the Reviews: The response is processed to extract relevant review data using Cheerio, a web scraping library.
    5. Split Reviews: The workflow splits the parsed reviews into individual entries for further processing.
    6. Edit Review Data: Users can modify the data format and assign specific fields such as date, author, body, heading, rating, and location.
    7. Store in Google Sheets: Finally, the structured review data is appended or updated in Google Sheets, making it readily available for analysis and reporting.

    • Customization Guide

    To customize this workflow:
    - Change Company ID: Update the company_id in the Global node to scrape reviews for a different company.
    - Adjust Maximum Pages: Modify the max_page parameter to control how many pages of reviews you want to scrape.
    - Edit Parsing Logic: If the structure of the Trustpilot page changes, you may need to adjust the parsing logic in the Parse reviews node to ensure correct data extraction.
    - Modify Google Sheets Settings: Change the Google Sheets document ID and sheet name in the General sheet and HelpfulCrowd Sheets nodes to specify where the data should be stored.
    - Schedule Frequency: Adjust the schedule trigger settings to define how often the workflow should run automatically.