{"product_id":"n8n-competitor-price-tracker-openai-sheets-slack-notion","title":"n8n Competitor Price Tracker: OpenAI, Sheets, Slack \u0026 Notion","description":"\u003ch3\u003eTrack competitor prices automatically—daily—using Google Sheets, OpenAI, Slack \u0026amp; Notion\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors competitor product URLs from your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, extracts \u003cstrong\u003eprice and stock status\u003c\/strong\u003e with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and sends \u003cstrong\u003eSlack alerts\u003c\/strong\u003e (including a “manual check” path for low confidence). When a meaningful \u003cstrong\u003eprice drop\u003c\/strong\u003e is detected, it logs the event in \u003cstrong\u003eNotion\u003c\/strong\u003e and updates the latest prices back in your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration\u003c\/strong\u003e and pulls competitor rows from a Google Sheet (e.g., productName, competitorUrl, ourPrice\/lastKnownPrice, and checkedAt).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches each competitor page\u003c\/strong\u003e via HTTP requests with retries; on fetch failures, it posts an \u003cstrong\u003eerror alert to Slack\u003c\/strong\u003e and continues processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts fetched HTML to plain text\u003c\/strong\u003e and sends the content to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to extract:\n    \u003cul\u003e\n      \u003cli\u003eprice\u003c\/li\u003e\n      \u003cli\u003estock status\u003c\/li\u003e\n      \u003cli\u003econfidence level\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes low-confidence results\u003c\/strong\u003e to a Slack “manual check” alert; otherwise compares the extracted price to the \u003cstrong\u003elast known price\u003c\/strong\u003e and detects drops beyond your configured threshold.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFor significant drops:\u003c\/strong\u003e sends a Slack alert, creates a \u003cstrong\u003eNotion database entry\u003c\/strong\u003e, then writes the \u003cstrong\u003elatest checked time\u003c\/strong\u003e and \u003cstrong\u003enew last-known price\u003c\/strong\u003e back to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a daily Slack summary\u003c\/strong\u003e with counts of checked items, detected drops, fetch errors, and low-confidence extractions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators tracking competitive pricing across multiple SKUs without manual checking\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up an n8n competitor price tracker with Slack notifications and Notion logging\u003c\/li\u003e\n  \u003cli\u003eTeams validating promotions by capturing price drops and recording them for review\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, OpenAI, Slack, Notion\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used (as implemented):\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, \u003cem\u003enotion\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey setup:\u003c\/strong\u003e configure your Sheet\/document ID and tab, and ensure columns like \u003cem\u003eproductName\u003c\/em\u003e, \u003cem\u003ecompetitorUrl\u003c\/em\u003e, \u003cem\u003eourPrice\u003c\/em\u003e, \u003cem\u003elastKnownPrice\u003c\/em\u003e, and \u003cem\u003echeckedAt\u003c\/em\u003e exist.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869896073395,"sku":"N8N-18432","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Vlj2_JbL6btOdyga0eFww_k41Qy6EX.png?v=1787130652","url":"https:\/\/buyflowscripts.com\/products\/n8n-competitor-price-tracker-openai-sheets-slack-notion","provider":"N8N Commerce","version":"1.0","type":"link"}