Home >Marketplace
On this page

Overview

Scraping and analyzing Trustpilot reviews manually is slow and error-prone. This workflow automates fetching reviews, extracting structured data, running sentiment analysis, and appending results to Google Sheets. It removes manual overhead and ensures your teams get timely, actionable insights without data duplication headaches.

The Impact

  • Automate data extraction. Pull reviews directly from Trustpilot without manual scraping.
  • Flag sentiment instantly. Classify reviews as Positive, Neutral, or Negative for quick triage.
  • Prevent duplicates. Cross-check existing sheet entries before appending new reviews.
  • Centralize insights. Store organized review data in Google Sheets for easy access and reporting.

Who This Is For

  • Customer Service Teams monitoring and responding to negative reviews promptly.
  • Product Managers aggregating user feedback to detect feature issues.
  • Operations and Marketing tracking brand reputation and competitor reviews across regions.
  • Data Analysts compiling structured review data for trend analysis.

How It Works

1
  1. Scrape Review Links
  2. Fetch the company review page on Trustpilot and extract individual review URLs.
2
  1. Deduplicate Existing Data
  2. Retrieve existing Google Sheet rows, convert to JSON, and check if each review already exists to avoid duplicates.
3
  1. Extract Review Details
  2. For each new review URL, fetch its page, extract HTML article content, and use AI to parse structured attributes like Date, Name, Text, Rating.
4
  1. Analyze Sentiment
  2. Classify each review’s text as Positive, Neutral, or Negative using AI-powered sentiment analysis.
5
  1. Update Google Sheets
  2. Append or update rows in the specified Google Sheet tab with the structured review data and sentiment results.

What You'll Need

Before using this template, make sure you have:

  • A Google Spreadsheet with a worksheet tab containing headers: Id, Date, Name, Title, Text, Location, NumberofReviews, URL, Rating, Sentiment.
  • Google Sheets OAuth credentials authorized to read and write to the target spreadsheet.
  • The Trustpilot company domain segment (CompanyDomain) and Trustpilot domain host (e.g., it.trustpilot.com).
  • Spreadsheet ID and exact worksheet (tab) name to write the data.

How to Use

  1. Step 1. Prepare Your Google Sheet

    2. Ensure your spreadsheet has the required headers in order and that you have the Spreadsheet ID and SheetName handy.

  2. Step 2. Configure Credentials

    3. Set up Google Sheets OAuth credentials to enable the workflow to access and modify your sheet.

  3. Step 3. Set Parameters

    4. Input the CompanyDomain, maximum number of Comments to scrape, SpreadsheetId, SheetName, and TrustpilotDomain.

  4. Step 4. Run the Workflow

    5. Start the automation to scrape reviews, perform sentiment analysis, and append data to your sheet.

  5. Step 5. Verify Results

    6. Check your Google Sheet to confirm reviews and sentiment data have been accurately appended or updated.

FAQs

How does the workflow avoid duplicate reviews in the Google Sheet?
It fetches existing rows from the sheet, converts them to JSON, and checks if a review's unique ID already exists before appending new data.
What sentiment categories are used in the analysis?
Reviews are classified into Positive, Neutral, and Negative categories for straightforward sentiment tagging.
Can I control how many reviews are scraped?
Yes, the Comments parameter lets you specify the maximum number of reviews to extract, defaulting to 10 but adjustable as needed.
What format should my Google Sheet have for this to work?
Your sheet must have columns in this exact order: Id, Date, Name, Title, Text, Location, NumberofReviews, URL, Rating, Sentiment.
Can this workflow be used for Trustpilot domains other than it.trustpilot.com?
Yes, you can specify the TrustpilotDomain parameter to target different regional Trustpilot sites.
Updated on: Sep 11, 2026
Was This Page Helpful?
Prev Scrape Xiaohongshu Posts and Write to Google Sheets
Next Score Real Estate Buyer Leads and Notify Agents

More Workflows for Inspiration

🔍
Fetch and Send Product Hunt Latest Products to Slack
Automatically fetch latest Product Hunt entries and push summaries directly to Slack channels.
Learn more >
📧
Fetch Latest Emails and Send to Slack
Automatically retrieve recent emails and broadcast their content in Slack channels for faster team response.
Learn more >
💬
Multi-model Intelligent Customer Service Assistant
Automate polite, solution-driven customer replies with layered model fallback for quality and cost control.
Learn more >