Analyze & summarize Amazon product reviews with Decodo, OpenAI and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI Chat Model and Decodo (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set the Input Fields (Edit Fields (Set)): sets 3 fields: amazon_url, geo, file_name
- Decodo: amazon
- Extract the Reviews (Code): runs custom JavaScript code
- Create a Binary Response (Function): runs custom JavaScript (legacy Function node)
- Perform Review Analysis (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Write the Structured JSON to Disk (Read/Write Files from Disk): writes a file to disk
- Append or update row in sheet (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Create a Binary Response: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Create a Binary Response | Code node, mode 'Run Once for All Items' |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Decodo
@decodo/n8n-nodes-decodo.decodo - Code
n8n-nodes-base.code - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Function
n8n-nodes-base.function - Read/Write Files from Disk
n8n-nodes-base.readWriteFile - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Disclaimer Please note - This workflow is only available on n8n self-hosted as it’s making use of the community node for the Decodo Web Scraping This n8n workflow automates the process of scraping, analyzing, and summarizing Amazon product reviews using…