Block 1 - Google Gemini Chat Model
- Type / Role
- @n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
- Config choices
- Version 1
Aggregate web product reviews and sentiment with Decodo and Google Gemini
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
1. Workflow Overview
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. ...
Best for
- Market Research automation workflows
- AI Summarization automation workflows
- advanced n8n builders looking for reusable templates
Tools used
@n8n/n8n-nodes-langchain.lmchatgooglegemini, n8n-nodes-base.splitinbatches, n8n-nodes-base.stickynote, n8n-nodes-base.telegramtrigger, n8n-nodes-base.set, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.agent, n8n-nodes-base.telegram
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Abdullah Alshiekh.
Original n8n.io source1.1 Workflow description
- Title
- Aggregate web product reviews and sentiment with Decodo and Google Gemini
- Workflow name
- Aggregate web product reviews and sentiment with Decodo and Google Gemini
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
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Loop Over Items
- Type / Role
- n8n-nodes-base.splitInBatches - splitInBatches
- Config choices
- Version 3
Block 3 - Google Gemini Chat Model1
- Type / Role
- @n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
- Config choices
- Version 1
Block 4 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 5 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 6 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 7 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 8 - Get Message
- Type / Role
- n8n-nodes-base.telegramTrigger - telegramTrigger
- Config choices
- Version 1.2
Block 9 - Set Search Query
- Type / Role
- n8n-nodes-base.set - set
- Config choices
- Version 3.4
Block 10 - Extract URLs
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 11 - Clean HTML
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 12 - Analyze Sentiment
- Type / Role
- @n8n/n8n-nodes-langchain.agent - agent
- Config choices
- Version 3
Block 13 - Merge Results
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 14 - Draft Final Report
- Type / Role
- @n8n/n8n-nodes-langchain.agent - agent
- Config choices
- Version 3
Block 15 - Reply to User
- Type / Role
- n8n-nodes-base.telegram - telegram
- Config choices
- Version 1.2
Block 16 - Sticky Note4
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 17 - Google Search1
- Type / Role
- @decodo/n8n-nodes-decodo.decodo - decodo
- Config choices
- Version 1
Block 18 - Scrape Page Content1
- Type / Role
- @decodo/n8n-nodes-decodo.decodo - decodo
- Config choices
- Version 1
3. Summary Table
| Workflow | Aggregate web product reviews and sentiment with Decodo and Google Gemini |
|---|---|
| Complexity | advanced |
| Nodes | 18 |
| Categories | Market Research, AI Summarization |
| Author | Abdullah Alshiekh |
| Published | 23 Dec 2025 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/12068/12068.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Aggregate web product reviews and sentiment with Decodo and Google Gemini do?
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. ...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.