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 (https://it.trustpilot.com/review/{{companyid}}). - 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: json { "category": "Positive", "confidence": 0.95 }

4. Save to Google Sheets - Google Sheets Node: - Appends or updates the extracted data to a Google Sheet

---