Monitor e-commerce price changes with Decodo Scraper, OpenAI & Google Sheets
Needs changesWhat this workflow does
This AI workflow has 21 nodes and runs on a schedule (every day at 09:00). Along the way it connects AI Agent, Structured Output Parser, OpenAI Chat Model and Gmail and 3 more.
How it runs
Trigger: On a schedule (every day at 09:00).
- 2. Global Configuration (Edit Fields (Set)): sets 4 fields: productTargets, priceThresholds, alertRecipients…
- 3. Initial Aggregate (Pass-Through) (Aggregate): combines items into one
- 4. Parse Product Targets (Function) (Function): runs custom JavaScript (legacy Function node)
- 5. Clone Items (Split In Batches) (Loop Over Items (Split in Batches)): loops over the items in batches
- 6. Map Threshold (Function) (Function): runs custom JavaScript (legacy Function node)
- 8. Intelligent Price Scraping Agent (AI Agent): runs an AI agent, with model: 10. OpenAI Price Analyzer (LLM); 1 tool (7. Decodo Web Scraper); output parser: 9. Structured Price Data Parser
- Log Price Data to Google Sheets (Google Sheets): append
- 12. Price Analysis & Strategy Agent (AI Agent): runs an AI agent, with model: 13. OpenAI Strategy Model (LLM); output parser: Auto-fixing Output Parser
- 14. Advanced Price Condition Check (IF) (If): checks a condition and branches into true / false
- 15. Critical vs. Standard Check (IF) (If): checks a condition and branches into true / false
…plus 2 more steps. See the full node list below.
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 4. Parse Product Targets (Function), 6. Map Threshold (Function): replace with Code node, mode 'Run Once for All Items'.
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) 4. Parse Product Targets (Function), 6. Map Threshold (Function) | Code node, mode 'Run Once for All Items' |
Nodes used (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Aggregate
n8n-nodes-base.aggregate - Function
n8n-nodes-base.function - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Decodo Tool
@decodo/n8n-nodes-decodo.decodoTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - Google Sheets
n8n-nodes-base.googleSheets
From the author
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Stay ahead of market changes with this Automated Price Intelligence System! This workflow monitors e-commerce product prices 3x daily using advanced web…