📊 Aggregate web product reviews and sentiment with Decodo and Google Gemini

⚡ 20 views · 📊 Market Research & Insights

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

Description

What Problem Does It Solve?

• Brands and marketers spend hours manually searching Google for product reviews.
• Reading through multiple websites to gauge general sentiment is tedious and inefficient.
• It is difficult to spot recurring customer complaints or praises without aggregating data.
• This workflow solves these by:
  • Instantly searching and scraping review content from the web.
  • Using AI to read and score the sentiment of every review found.
  • Generating a consolidated “Executive Summary” with key quotes and actionable advice.

How to Configure It

Telegram Setup

• Connect your Telegram Bot credentials in n8n.
• Set the Get Message node to watch for text messages.

Search & Scraping (Decodo)

• Connect your Decodo credentials (requires a Web Scraping API plan).
• This handles both the Google Search and the content extraction.

AI Setup

• Add your Google Gemini API key.
• The prompts are pre-configured to act as a “Strict Data Analyst,” but you can edit the system prompt in the AI Agent node to match your preferred tone.

How It Works

• Trigger: You send a company or product name (e.g., “XQ Pharma”) to your Telegram bot.
• Search: The workflow uses Decodo to Google search for “[Name] reviews” and extracts the top URL results.
• Scrape: It visits the review pages and strips away the HTML code to get clean text.
• Analyze (Loop): The first AI Agent reads the text and determines the sentiment (Positive/Neutral/Negative) and key topics.
• Report: A second AI Agent collects all the analysis pieces and writes a final summary containing a Sentiment Score, Customer Voice (direct quotes), and an Actionable Verdict.
• Delivery: The final report is sent back to you as a Telegram message.

Customization Ideas

• Change the Source: Modify the search query to target specific platforms (e.g., “site:reddit.com [Product] reviews”).
• Change the Output: Send the final report to a Slack channel or Email for your team to see.
• Database Logging: Save the “Actionable Verdict” and sentiment scores into Notion or Airtable to track brand reputation over time.
• Competitor Analysis: Use it to research competitor products instead of your own to find their weaknesses.

If you need any help Get in Touch

🔗 Nodes Used

Telegram, Telegram Trigger, AI Agent, Google Gemini Chat Model

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup