Scrape Trustpilot reviews with DeepSeek, analyze sentiment with OpenAI
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Parameters (Edit Fields (Set)): sets 2 fields: company_id, max_page
- Get reviews (HTTP Request): calls an HTTP API
- Extract (HTML): parses or builds HTML
- Split Out: splits a list into separate items
- Limit: keeps the first few items
- Get Google Sheets (Google Sheets): append or update
- Get rows (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Get Single review (HTTP Request): calls an HTTP API
- Extract review (HTML): parses or builds HTML
…plus 3 more steps. See the full node list below.
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Split Out
n8n-nodes-base.splitOut - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Limit
n8n-nodes-base.limit - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Google Sheets
n8n-nodes-base.googleSheets - Sentiment Analysis
@n8n/n8n-nodes-langchain.sentimentAnalysis - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Workflow Overview This workflow automates the process of scraping Trustpilot reviews, extracting key details, analyzing sentiment, and saving the results to Google Sheets. It uses OpenAI for sentiment analysis and HTML parsing for review extraction. --- How…