Get Started
Back to Templates

Aggregate web product reviews and sentiment with Decodo and Google Gemini

Created by

Created by: Abdullah Alshiekh || abdullah01

Abdullah Alshiekh

Last update

Last update 6 days ago

Categories

Share

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