Scrape Trustpilot reviews with DeepSeek analyze sentiment with
Workflow Overview This workflow automates the process of scraping Trustpilot reviews, extracting key details, analyzing sentiment, and saving the results to ...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
**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 (`https://it.trustpilot.com/review/{{company_id}}`). - Paginates through pages (up to `max_page` 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: ```json { "category": "Positive", "confidence": 0.95 } ```
#### **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 `company_id` to the Trustpilot company name - Set `max_page` 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 workflow into n8n:
- Click the Direct Download JSON button above to save
Scrape_Trustpilot_reviews_with_DeepSeek_analyze_sentiment_with.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....