Who is this workflow for? Streamline your analysis of Trustpilot reviews by automating the scraping, extraction, sentiment evaluation, and data storage processes. This workflow leverages DeepSeek for data extraction, OpenAI for sentiment analysis, and Google Sheets for organized storage, enabling efficient and insightful review management..

What does this workflow do?

1. Scrape Trustpilot Reviews

  • HTTP Request:

  • Retrieves review pages from Trustpilot using the company’s unique URL (e.g., https://it.trustpilot.com/review/{{company_id}}).

  • Iterates through multiple pages up to a specified max_page limit to gather extensive review data.

  • HTML Parsing:

  • Uses CSS selectors to extract individual review URLs from the fetched pages.

  • Separates the collected URLs into distinct links for detailed processing.

2. Extract Review Details

  • Information Extractor:
  • Employs DeepSeek to parse each review URL and extract structured information, including:
    • Author: Name of the reviewer.
    • Rating: Numerical rating (1-5).
    • Date: Date of the review in YYYY-MM-DD format.
    • Title: Title of the review.
    • Text: Full text of the review.
    • Total Reviews: Number of reviews submitted by the user.
    • Country: Reviewer’s country code (2 letters).

3. Sentiment Analysis

  • Sentiment Analysis Node:
  • Utilizes OpenAI to evaluate the sentiment of each review’s text.
  • Classifies sentiments into Positive, Neutral, or Negative categories.
  • Provides confidence scores for each classification, for example:json{ "category": "Positive", "confidence": 0.95 }

4. Save to Google Sheets

  • Google Sheets Node:
  • Appends the extracted and analyzed data to a specified Google Sheet.
  • Updates existing entries or adds new ones, ensuring your data repository remains current and comprehensive.

🤖 Why Use This Automation Workflow?

  • Efficiency: Automates the tedious process of manually collecting and processing reviews, saving valuable time.
  • Structured Data: Extracts key details such as author, rating, and review text in a consistent format for easy analysis.
  • Insightful Analysis: Utilizes advanced AI to categorize sentiments, providing a clear understanding of customer feedback.
  • Seamless Integration: Directly feeds processed data into Google Sheets, facilitating further manipulation and sharing.

👨‍💻 Who is This Workflow For?

This workflow is ideal for businesses and professionals who need to monitor and analyze customer feedback on Trustpilot. It serves marketing teams, customer service managers, business analysts, and anyone interested in gaining actionable insights from online reviews without the hassle of manual data handling.

🎯 Use Cases

  1. Customer Satisfaction Monitoring: Continuously track and assess customer sentiments to identify areas for improvement.
  2. Market Research: Analyze trends and common themes in reviews to inform product development and marketing strategies.
  3. Reputation Management: Quickly identify and respond to negative feedback, enhancing your brand’s online presence.

TL;DR

This workflow offers a comprehensive solution for automating the extraction and analysis of Trustpilot reviews. By integrating DeepSeek for data extraction, OpenAI for sentiment analysis, and Google Sheets for data storage, it empowers businesses to efficiently manage and derive meaningful insights from customer feedback.

Get started with n8n
Need help with n8n?

Related

Automate Euro Exchange Rate Retrieval from ECB via n8n Webhook

Automate the retrieval of Euro exchange rates from ECB using n8n. Benefit from timely updates and seamless data integration in your workflows. 

  • 613
  • 12

Integrate JotForm and KlickTipp for Efficient Webinar Registration

Simplify webinar registrations by integrating JotForm and KlickTipp using this template, ensuring efficient data flow and streamlined communication. 

  • 519
  • 25

Automate Strava Activity Exports to Google Sheets

Streamline your data flow by exporting Strava activities to Google Sheets using this n8n template, featuring seamless integration and easy setup. 

  • 616
  • 14

Help us find the best n8n templates

About

A curated directory of the best n8n templates for workflow automations.

Navigation

Submit