Automated smart price monitor with AI prediction, Google Sheets and Gmail
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 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI Chat Model and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Products (Google Sheets): uses Google Sheets
- Loop Products (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Product Page (HTTP Request): calls an HTTP API
- Extract Price (HTML): parses or builds HTML
- Get Price History (Google Sheets): uses Google Sheets
- Check Duplicate (Code): runs custom JavaScript code
- Add to History (Google Sheets): append
- Prepare AI Data (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Parse AI Response (Code): runs custom JavaScript code
…plus 4 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 (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - HTML
n8n-nodes-base.html
From the author
Think of this workflow as your personal shopping assistant that: - Watches prices for you 24/7 - Learns when prices are good or bad - Sends you an email when it's time to buy - Keeps a history of all price changes --- ✅ Prerequisites (What You Need Before…