Trustpilot Reviews Scraper and Analyzer with DeepSeek and OpenAI
detail.loadingPreview
Scrapes Trustpilot reviews, extracts detailed information using DeepSeek, analyzes sentiment with OpenAI, and stores results in Google Sheets.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of scraping reviews from Trustpilot. It first fetches reviews using an HTTP request, then extracts specific review details using an Information Extractor node powered by DeepSeek. The extracted data is then checked against existing records in Google Sheets to avoid duplicates. Finally, it analyzes the sentiment of each review using OpenAI and stores all processed information back into a Google Sheet.
Key Features
- Scrapes Trustpilot reviews with configurable pagination.
- Extracts detailed review attributes (author, rating, date, text, etc.) using an AI Information Extractor.
- Deduplicates reviews by checking against a Google Sheet.
- Analyzes review sentiment using an AI model (implicitly OpenAI based on notes).
- Stores scraped and analyzed data into Google Sheets.
How To Use
- Configure environment variables for
BASE_URLand API keys for DeepSeek and OpenAI. - Set up Google Sheets credentials and ensure the target sheet has columns for
Id,Data,Nome,Titolo,Testo,Valutazione,N_Recensioni,Nazione. - Update the
Set Parametersnode with the correctcompany_id(Trustpilot company identifier) andmax_pagefor scraping. - Replace
YOUR_CREDENTIAL_HEREin theExtractnode if specific HTML extraction is needed beyond the Information Extractor. - Ensure the
Information Extractornode'sbase_urlis correctly set to your DeepSeek API endpoint. - Trigger the workflow via the
manualTriggeror by other means.
Apps Used
Workflow JSON
{
"id": "99c64c8f-bd9c-4d22-b7ef-09cb7032fe66",
"name": "Trustpilot Reviews Scraper and Analyzer with DeepSeek and OpenAI",
"nodes": 0,
"category": "Data Extraction",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 99c64c8f-bd9c...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 workflows)
- Gmail + Schedule Trigger(270 workflows)
- Google Sheets + Slack(268 workflows)
- Gmail + Google Sheets(245 workflows)
- Google Drive + Google Sheets(203 workflows)
- Form Trigger + Google Sheets(163 workflows)
- Google Drive + Google Drive Trigger(135 workflows)
- Google Drive + Split Out(134 workflows)
- Gmail + Split Out(132 workflows)
Related Workflows
Discover more workflows you might like
Extract Amazon Bestseller Electronics with Bright Data and Google Gemini
Extracts Amazon bestseller electronic product data using Bright Data and enriches it with Google Gemini for structured output.
Extract Personal Data with Mistral NeMo
Extracts personal data from chat messages using a self-hosted Mistral NeMo LLM and a structured JSON output.
Image-Based Data Extraction API using Gemini AI
Extracts structured data from images using Gemini AI via a webhook.
Community Contributed Recipe Fetcher
Fetches and processes recipe data from a community-contributed website.
Read Sitemap and Filter URLs
Reads an XML sitemap, converts it to JSON, and filters the URLs based on specified criteria.
Extract Text from PDF and Image to CSV
Automates the extraction of text from PDF and image files and converts it into a CSV format.