Scrape Trustpilot Reviews with DeepSeek and Analyze Sentiment with OpenAI
detail.loadingPreview
This workflow scrapes Trustpilot reviews, extracts detailed information using an Information Extractor node, and optionally analyzes sentiment.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the scraping of reviews from Trustpilot. It utilizes several nodes to fetch review data, extract specific attributes from each review using a powerful 'Information Extractor' node powered by an LLM (like DeepSeek), and check for existing entries in a Google Sheet. It also includes an optional sentiment analysis step.
Key Features
- Scrapes Trustpilot reviews efficiently.
- Extracts detailed review attributes (author, rating, date, text, etc.) using LLM capabilities.
- Checks for duplicate reviews in a Google Sheet to avoid redundant entries.
- Includes an 'If Node' for conditional processing based on extracted data.
- Utilizes a 'Limit' node to control the number of processed items.
- Configurable scraping parameters (company ID, max pages).
How To Use
- Configure Environment Variables: Ensure
BASE_URLandAPI_BASE_URLare set in your n8n environment. - Set Company ID and Max Pages: Update the
Set Parametersnode with your target company's Trustpilot identifier and the maximum number of pages to scrape. - Google Sheets Setup: Configure your Google Sheets credentials and ensure the target spreadsheet ('Trustpilot Review') and sheet ('Foglio1') are correctly set up with an 'Id' column.
- Information Extractor Configuration: In the
Information Extractornode, ensure thesystemPromptTemplateandattributesare correctly configured to match the desired data extraction from the HTML. - Run the Workflow: Execute the workflow to start scraping and processing Trustpilot reviews.
Apps Used
Workflow JSON
{
"id": "a4057704-3314-4192-a407-f5e122cff7b9",
"name": "Scrape Trustpilot Reviews with DeepSeek and Analyze Sentiment with OpenAI",
"nodes": 0,
"category": "Data Scraping",
"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: a4057704-3314...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Verification Info
Related Integrations
- Google Sheets + Schedule Trigger(394 workflows)
- Google Sheets + Split Out(277 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)
- Google Sheets + Telegram(118 workflows)
- Execute Workflow Trigger + Google Sheets(101 workflows)
Related Workflows
Discover more workflows you might like
Automated Twitter Data Scraping and Storage to Google Sheets
This n8n workflow automates Twitter data extraction, allowing you to scrape tweets by username or search query using Apify's tweet-scraper and store the results directly into Google Sheets. It efficiently captures tweet details and engagement metrics.
Google Maps Email Scraper
Scrapes email addresses from Google Maps search results.
Hacker News "Who is Hiring?" Scraper
Scrapes monthly Hacker News 'Who is Hiring?' posts to extract and structure job data.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Convert Any Webpage to PDF and Save Locally
This n8n workflow provides a simple way to convert any public webpage URL into a PDF document. Once converted, the PDF file is automatically saved to your local disk, making it easy to archive or share web content offline.