Scrape Trustpilot Reviews to Google Sheets

Name: Scrape Trustpilot Reviews to Google Sheets
Rating: 3.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

17 views

0 downloads

Web Scrapingautomationcustomer feedbackgoogle sheetsreviewsscrapingtrustpilot

Scrapes reviews from Trustpilot for a specified company and saves them to a Google Sheet.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of collecting customer reviews from Trustpilot for a given company. It fetches reviews, parses the relevant data, and then allows for the enrichment of this data before potentially sending it to a Google Sheet or another destination.

Key Features

Fetches reviews from Trustpilot using the company ID.
Handles pagination to scrape multiple pages of reviews.
Parses raw HTML content to extract structured review data.
Allows for setting custom company IDs and the maximum number of pages to scrape.
Provides fields for general review data (Date, Author, Body, Heading, Rating, Location, Review ID).
Offers specific fields for "HelpfulCrowd edits" which include product ID, feedback, customer name, status, review date, verification status, and media placeholders.

How To Use

Set Company and Page Limits: Update the Sticky Note node with the target company's name on Trustpilot and the maximum number of pages to scrape. The Global set node also defines company_id and max_page.
Configure HTTP Request: Ensure the Get reviews node's BASE_URL environment variable is correctly set to the Trustpilot base URL.
Adjust Parsing Logic: The Parse reviews code node uses cheerio to extract data. Review the jsCode if Trustpilot's website structure changes.
Map Output Fields: In the General edits and HelpfulCrowd edits set nodes, map the extracted review fields to your desired output format. Note that some fields like customer_email, comment, and media are left intentionally blank or require further logic.
Integrate with Google Sheets: Connect the General sheet node to your Google Sheets account and configure it to write the processed review data.

Apps Used

automation

customer feedback

google sheets

reviews

scraping

trustpilot

Workflow JSON

{
  "id": "3364fa68-72df-4922-a336-8199817601ab",
  "name": "Scrape Trustpilot Reviews to Google Sheets",
  "nodes": 0,
  "category": "Web Scraping",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.