Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI
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

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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 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
Import Google Sheets data into Invoice Ninja
Curate Hackernews, Make a brief audio news and Delivery to Telegram
Add a new row to a Google Sheets spreadsheet from a Google Ads Lead Forms submission
Send data to Google Sheets from a custom webhook
Add new rows with data about Outbound messages in Hootsuite to Google Sheets spreadsheet
Review n8n workflows from Slack with Claude Opus and GitHub skills
📍 Daily nearby garage sales alerts via Telegram
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.
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.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you