Trustpilot review sentiment analysis with OpenAI & Bright Data to Google Sheets
UnknownWhat this workflow does
This AI workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Mcp (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Trustpilot company URL (Edit Fields (Set)): sets 1 field: URL
- Agent : Fetch and analyze reviews (AI Agent): runs an AI agent, with model: Chat Model; 1 tool (Bright Data MCP Scrapper); output parser: Auto-fixing Output Parser
- Splits Reviews into separate Objects (Code): runs custom JavaScript code
- Save Reviews to Google Sheets (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 n8n-nodes-mcp is verified or supports 3.0 (used in Bright Data MCP Scrapper).
Nodes used (9)
- Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Mcp Client Tool
n8n-nodes-mcp.mcpClientTool - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured
From the author
This workflow automatically scrapes customer reviews from Trustpilot and performs sentiment analysis to extract valuable customer insights. It saves you time by eliminating the need to manually read through reviews and provides structured data on customer…