📊 AI-powered review sentiment analysis to Salesforce & Google Sheets with Decodo

⚡ 40 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.

View All Scrapers

Description

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. recent_trend_summary__c).

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:

This creates a reusable dataset for dashboards and reporting.

How to configure it (general)

🔗 Nodes Used

Google Sheets, Salesforce, AI Agent, OpenAI Chat Model

📥 Import

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

📖 Importing guide · 🔑 Credential setup