Monitor product prices and stock with Google Sheets, OpenAI, and Slack
UnknownWhat this workflow does
This AI workflow has 16 nodes and runs on a schedule (every 6 hours). Along the way it connects Google Sheets, Slack, OpenAI Chat Model and Snapshot Site (community).
How it runs
Trigger: On a schedule (every 6 hours).
- Read Products from Sheets (Google Sheets): uses Google Sheets
- Loop Over Watchlist Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Product HTML (Snapshot Site): uses Snapshot Site
- If: checks a condition and branches into true / false
- Set Error Details (Edit Fields (Set)): sets 4 fields: url, productName, message…
- Clean Product HTML (Code): runs custom JavaScript code
- Alert Slack on Price Check Fail (Slack): uses Slack
- Extract Price & Stock Data (Information Extractor): extracts structured fields from text with AI, with model: OpenAI GPT-4 Extractor
- Compare Current vs Last Values (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-snapshot-site is verified or supports 3.0 (used in Fetch Product HTML).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Snapshot Site
n8n-nodes-snapshot-site.snapshotSite - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Code
n8n-nodes-base.code - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
Quick overview This workflow runs every 6 hours to monitor product URLs from Google Sheets by capturing rendered HTML with Snapshot Site, extracting price and availability with OpenAI, posting change alerts to Slack, and updating the watchlist rows with the…