AutomationMart
Home/Browse/Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI
n8n

Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI

n8nn8n16 modulesv1.0
Google SheetsOpenAI

Workflow Overview This workflow automates the process of scraping Trustpilot reviews, extracting key details, analyzing sentiment, and saving the results to Google Sheets. It uses OpenAI for sentiment analysis and HTML parsing for review extraction. --- How It Works 1. Scrape Trustpilot Reviews - HTTP Request: - Fetches review pages from Trustpilot ( - Paginates through pages (up to maxpage limit). - HTML Parsing: - Extracts review URLs using CSS selectors - Splits the URLs into indiv

At a glance

Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, OpenAI
Modules
16
Price
Free
Version
v1.0
Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI workflow diagram

About this workflow

Workflow Overview This workflow automates the process of scraping Trustpilot reviews, extracting key details, analyzing sentiment, and saving the results to Google Sheets. It uses OpenAI for sentiment analysis and HTML parsing for review extraction. --- How It Works 1. Scrape Trustpilot Reviews - HTTP Request: - Fetches review pages from Trustpilot ( - Paginates through pages (up to maxpage limit). - HTML Parsing: - Extracts review URLs using CSS selectors - Splits the URLs into individual review links. 2. Extract Review Details - Information Extractor: - Uses DeepSeek to extract structured data from the review: - Author: Name of the reviewer. - Rating: Numeric rating (1-5). - Date: Review date in YYYY-MM-DD format. - Title: Review title. - Text: Full review text. - Total Reviews: Number of reviews by the user. - Country: Reviewer’s country (2-letter code). 3. Sentiment Analysis - Sentiment Analysis Node: - Uses OpenAI to classify the review text as Positive, Neutral, or Negative. - Example output: 4. Save to Google Sheets - Google Sheets Node: - Appends or updates the extracted data to a Google Sheet --- Set Up Steps 1. Configure Trustpilot Scraping - Edit Fields1 Node: - Set companyid to the Trustpilot company name - Set maxpage to limit the number of pages scraped. 2. Configure Google Sheets - Google Sheets Node: - Update the documentId with your Google Sheet ID - Ensure the sheet has the required columns (Id, Data, Nome, etc.). 3. Configure OpenAI - OpenAI Chat Model Node: - Add your OpenAI API key. - Sentiment Analysis Node: - Ensure the categories match your desired sentiment labels (Positive, Neutral, Negative). --- Key Components - Nodes: - HTTP Request/HTML: Scrape and parse Trustpilot reviews. - Information Extractor: Extract structured review data using DeepSeek. - Sentiment Analysis: Classify review sentiment. - Google Sheets: Save and update review data. - Credentials: - OpenAI API key. - DeepSeek API key. - Google Sheets OAuth2.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create Timing time entries from Google Sheets spreadsheet rows

Make will watch for new rows in a specified Google Sheets spreadsheet at regular intervals and create a time entry in Timing using information received. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1qgLbjEfROsnledj6q-TdmOdAdl1idzU6s7c008wKhws/edit?usp=sharing).

Free

Import Google Sheets data into Invoice Ninja

This template helps you import a list of customers automatically from Google Sheets to Invoice Ninja. The scenario can be scheduled to run at regular intervals: every minute, hour, day or at the specified date. The template uses [this example from Google Sheets](https://docs.google.com/spreadsheets/d/17AutCAMLzuIPogSMdKRy2ClAZqABKwjhzFqCXbxuZVQ/edit?usp=sharing).

Free

Curate Hackernews, Make a brief audio news and Delivery to Telegram

This template automates a full “news curation → AI briefing → audio generation → Telegram delivery” workflow. It begins by requesting the Hacker News top-stories list and slicing the first 30 IDs. Each ID is iterated to fetch detailed items such as title and URL. The aggregator then collects all fetched stories into a single array, forming the dataset used in the AI prompt. An OpenAI Chat Completion module receives the full list of stories and a predefined set of user interests. It produces a J

Free

Add a new row to a Google Sheets spreadsheet from a Google Ads Lead Forms submission

Please disable your ad blockers when working with our Google Ads apps. The ad blockers may cause unexpected behavior. Every time a new Google Ads Lead form is submitted, Make will automatically add a new row to a Google Sheets spreadsheet. The template expects your lead form to collect at least these fields: 1) Full Name 2) User Email 3) User Phone The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1_FJW6u9VNsp8NcTmiMKUyr80ox2WEUm73qh2IUktWxo/edit?usp=sharin

Free

Send data to Google Sheets from a custom webhook

Automatically send data from a custom webhook to Google Sheets. Capture and log information in two separate rows for organized data management.

Free

Add new rows with data about Outbound messages in Hootsuite to Google Sheets spreadsheet

List Outbound messages in Hootsuite for specified 4 weeks period and store the data in Google Sheets spreadsheet.

Free

Review n8n workflows from Slack with Claude Opus and GitHub skills

Quick overview A Slack bot that reviews any n8n workflow on demand. Mention it or DM it a workflow URL and it replies in-thread with a graded review, plain-English overview, and findings tiered as Must Fix, Should Fix, and Nice to Have. How it works 1. Triggers when the bot is @mentioned in Slack or receives a direct message. 2. Adds an :eyes: reaction, extracts a /workflow/<id from the message text, and validates that a workflow ID is present. 3. Uses the n8n API to fetch the top-leve

Free

📍 Daily nearby garage sales alerts via Telegram

Get a personalized list of garage sales happening today, based on your current location, directly in Telegram each morning! This n8n workflow integrates Home Assistant and Brocabrac.frto: - Automatically detect your location every day - Scrape and parse garage sale listings from Brocabrac - Filter for high-quality and nearby events - Send a neatly formatted message to your Telegram account Perfect for treasure hunters and second-hand enthusiasts who want to stay in the loop with zero effort!

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free