AI-powered review sentiment analysis to Salesforce & Google Sheets with Decodo
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.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
@decodo/n8n-nodes-decodo(Decodo)
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Decodo
@decodo/n8n-nodes-decodo.decodo - Salesforce
n8n-nodes-base.salesforce - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
What it does
What this workflow does This workflow scrapes customer reviews from Trustpilot, analyzes them with AI, and keeps both Salesforce and Google Sheets automatically updated with customer sentiment insights. It uses Decodo to reliably extract review content from Trustpilot, processes the text with OpenAI, and orchestrates everything using n8n. 👉 Deocodo How it works (high level) 1. Reads Trustpilot review URLs and Salesforce Account IDs from Google Sheets 2. Scrapes Trustpilot reviews using Decodo 3. Uses AI to summarize sentiment, trends, and key positives/negatives 4. Generates two outputs in parallel Outputs generated 1. Salesforce Account update The workflow updates an existing Salesforce Account by writing the AI-generated sentiment summary into a custom text field (e.g. recenttrendsummaryc). This brings external customer feedback directly into Salesforce, allowing teams to work with real market perception inside the CRM. 2. Google Sheets analytics dataset At the same time, structured review metrics are stored in Google Sheets: - Ratings and sentiment distribution - Top positive and negative keywords - Trend summaries over time This creates a reusable dataset for dashboards and reporting. How to configure it (general) - Google Sheets: add review URLs + Salesforce Account IDs - Decodo: add your API key to scrape Trustpilot reliably - OpenAI: add your API key for AI analysis - Salesforce: - Create a custom Text (255) field on Account - Connect Salesforce credentials in n8n - Only existing Accounts are updated