StacksGPT
Research & Analysis

Trustpilot Review Scraping and Sentiment Analysis

Scrape a company's Trustpilot reviews, extract each review with AI, score its sentiment and save new ones to Google Sheets.

The Problem

Reading reviews across many pages to spot patterns is slow, so reviews about you or a competitor go unanalyzed.

How This Template Solves It

A product marketer enters a company name registered on Trustpilot and how many pages to scrape. The workflow pulls the review pages, extracts review details, skips reviews already saved, rates sentiment and adds rows to a Google Sheet for analysis.

How It Works

  1. 1You set the Trustpilot company name and the maximum number of pages to scrape.
  2. 2Fetches the review pages over HTTP.
  3. 3An information extractor powered by DeepSeek pulls out each review.
  4. 4Checks the sheet for reviews that are already saved.
  5. 5Runs sentiment analysis with OpenAI and adds the results to Google Sheets.

What You Need

  • A DeepSeek API key, configured as an OpenAI-compatible model
  • An OpenAI API key
  • A Google Sheet

What Stays Under Your Control

  • You interpret the trends and decide what to do about them.

Watch Out For

  • Check Trustpilot's terms before scraping.
  • Change the base URL for DeepSeek as the template notes explain.

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Research & Analysis Templates

Research & Analysis

Weekly Google Analytics Report by Email and Telegram

Each week, compare the last seven days of Google Analytics data with the same days last year and send an AI-written report by email and Telegram.

Starts on: Schedule

Email (SMTP)Google AnalyticsOpenAI+1 more