Scrape and score Amazon products with Apify, OpenAI, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers 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 OpenAI Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Configuration (Edit Fields (Set)): sets 6 fields: amazon_search_url, apify_actor, max_products…
- Scrape Amazon products via Apify (HTTP Request): calls an HTTP API (POST)
- Keep valid products (Filter): keeps only the items that match a condition
- Analyze product with AI (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Build result row (Edit Fields (Set)): sets 13 fields: name, asin, brand…
- Save products to Google Sheets (Google Sheets): append
Services it uses
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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow manually scrapes product results from an Amazon search URL via the Apify Amazon Crawler actor, uses OpenAI to generate a structured product analysis (category, key feature, verdict, value score), and appends the enriched results…