Quick overview
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 latest values. How it works Runs every 6 hours on a schedule. Reads the product watchlist (URLs and last known values) from a Google Sheets tab and processes the items one by one. Uses Snapshot Site to fetch each product page as fully rendered HTML, and posts a failure message to Slack if the capture returns an API error. Cleans the HTML and uses OpenAI (LangChain Information Extractor) to extract the current price, currency, availability, title, and SKU. Compares the extracted price and stock status with the last recorded values in Google Sheets to classify the result as a price/availability change, unchanged, or an initial baseline. Sends a Slack message only when a real price or stock change is detected. Appends or updates the matching watchlist row in Google Sheets (matched by URL) with the latest price, availability, currency, check timestamp, and change type. Setup Install the community node n8n-nodes-snapshot-site and add a Snapshot Site API credential. Add Google Sheets OAuth credentials and replace the placeholder Google Spreadsheet URL/ID used by the watchlist read and update steps. Add an OpenAI API credential for the Information Extractor model and adjust the model name if needed. Add Slack credentials and set the target channels for change alerts and capture-failure alerts. Create a Google Sheets tab named Watchlist with a header row including at least url, productName, lastPrice, lastAvailability, currency, lastCheckedAt, and lastChangeType, and ensure URLs are full https:// links. An n8n automation workflow template by Snapshot Site.
Snapshot Site
web
free
Others in the same category, ranked by how often they are opened.
