Analyze Trustpilot & Sitejabber sentiment with Decodo + Gemini to sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 10 nodes and runs when someone submits an n8n form (“Business Review Lookup”). Along the way it connects Google Gemini, Google Sheets, Google Gemini Chat Model and Decodo (community).
How it runs
Trigger: When someone submits an n8n form (“Business Review Lookup”).
- Set: Config Variables (Edit Fields (Set)): sets 3 fields: business_name, spreadsheet_id, sheet_id
- Agent: Business Review Scanner (AI Agent): runs an AI agent, with model: AI Model: Google Gemini (Agent); 1 tool (Decodo Review Scraper); output parser: Parse: Structured JSON Output
- Set: Output Fields (Edit Fields (Set)): sets 7 fields: output.business_name, output.industry_field, output.company_summary…
- LLM: Summarize & Recommendations (Google Gemini): uses Google Gemini
- Merge: merges the data from its input branches
- Google Sheets: append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @decodo/n8n-nodes-decodo is verified or supports 3.0 (used in Decodo Review Scraper).
Nodes used (9)
- Decodo Tool
@decodo/n8n-nodes-decodo.decodoTool - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Merge
n8n-nodes-base.merge - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Quick overview Sign up for Decodo HERE For Discount This template scrapes public reviews from Trustpilot and Sitejabber with a Decodo tool, converts findings into a flat, spreadsheet-ready JSON, generates a concise sentiment summary with Gemini, and appends…