{"product_id":"monitor-product-prices-stock-with-n8n-sheets-openai-slack","title":"Monitor Product Prices \u0026 Stock with n8n, Sheets, OpenAI, Slack","description":"\u003ch3\u003eNever miss a product price drop or stock change—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your monitored product URLs every 6 hours, extracts the latest price and availability from fully rendered pages, and sends Slack alerts only when something actually changes—then updates your Google Sheets watchlist with the new values.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every 6 hours to keep your data current.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads a watchlist from Google Sheets:\u003c\/strong\u003e Loads product URLs and the last known price\/availability values from a dedicated tab, then processes items one by one.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCaptures fully rendered HTML:\u003c\/strong\u003e Uses \u003cstrong\u003eSnapshot Site\u003c\/strong\u003e to fetch each product page as rendered HTML. If Snapshot Site returns an API error, the workflow posts a failure message to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts price and availability with OpenAI:\u003c\/strong\u003e Cleans the HTML and uses \u003cstrong\u003eOpenAI (LangChain Information Extractor)\u003c\/strong\u003e to extract current \u003cstrong\u003eprice\u003c\/strong\u003e, \u003cstrong\u003ecurrency\u003c\/strong\u003e, \u003cstrong\u003eavailability\u003c\/strong\u003e, \u003cstrong\u003etitle\u003c\/strong\u003e, and \u003cstrong\u003eSKU\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects changes vs. last recorded values:\u003c\/strong\u003e Compares extracted price and stock status against the previously saved values to classify results as a \u003cstrong\u003echange\u003c\/strong\u003e, \u003cstrong\u003eunchanged\u003c\/strong\u003e, or \u003cstrong\u003einitial baseline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies only when it matters:\u003c\/strong\u003e Sends a \u003cstrong\u003eSlack message only when a real price or stock change\u003c\/strong\u003e is detected.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e Appends or updates the matching watchlist row (matched by \u003cstrong\u003eURL\u003c\/strong\u003e) with the latest price, availability, currency, check timestamp, and change type.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor competitor listings and get instant alerts in \u003cstrong\u003eSlack\u003c\/strong\u003e when prices drop or items go in\/out of stock.\u003c\/li\u003e\n  \u003cli\u003eTrack inventory visibility for multiple SKUs with a Google Sheets-backed watchlist.\u003c\/li\u003e\n  \u003cli\u003eUse as a lightweight “price \u0026amp; stock monitoring” pipeline for SaaS operations or e-commerce teams.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/integrations:\u003c\/strong\u003e n8n \u003cem\u003ecommunity node\u003c\/em\u003e \u003ccode\u003en8n-nodes-snapshot-site\u003c\/code\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (LangChain Information Extractor)\u003c\/strong\u003e, and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupporting logic:\u003c\/strong\u003e scheduling plus flow controls using nodes such as \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, and documentation via \u003ccode\u003esticky note\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (quick)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eInstall \u003ccode\u003en8n-nodes-snapshot-site\u003c\/code\u003e and add a \u003cstrong\u003eSnapshot Site\u003c\/strong\u003e API credential.\u003c\/li\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e credentials and update the watchlist Spreadsheet ID\/URL.\u003c\/li\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eOpenAI API credentials\u003c\/strong\u003e for the Information Extractor model.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830467059891,"sku":"N8N-18208","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kgLZ5rA37JtPrKd6Wv_qG_ZdKBqxUM.png?v=1786699086","url":"https:\/\/buyflowscripts.com\/products\/monitor-product-prices-stock-with-n8n-sheets-openai-slack","provider":"N8N Commerce","version":"1.0","type":"link"}