{"product_id":"n8n-competitor-price-repricing-shopify-gpt-4o-slack-approval","title":"n8n Competitor Price Repricing: Shopify + GPT-4o + Slack Approval","description":"\u003ch3\u003eReprice your Shopify competitor prices every day—with GPT-4o guidance and Slack approvals\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically scrapes competitor product pages from URLs stored in Google Sheets, calculates rule-based target prices, requests a second opinion from OpenAI (GPT-4o), and sends Approve\/Reject requests to Slack. When you approve, it updates the matching Shopify variant prices via the Shopify Admin GraphQL API and logs everything back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns daily at 7 AM IST\u003c\/b\u003e to load SKU, pricing, and proposal configuration from \u003cb\u003eGoogle Sheets\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds competitor scrape jobs per SKU\u003c\/b\u003e, fetches each competitor page via HTTP, and extracts price\/stock using structured data and regex.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI as a parsing fallback\u003c\/b\u003e when extraction is unreliable, so your repricing pipeline stays resilient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eCalculates eligible target pricing\u003c\/b\u003e using the lowest in-stock competitor price, margin floor\/ceiling, stock-based constraints, daily change caps, cooldown checks, and \u003cb\u003e₹…9 rounding\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWrites daily market observations + rule results\u003c\/b\u003e into the Google Sheets “Price History” tab and posts a Slack digest summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends meaningful changes to GPT-4o\u003c\/b\u003e for a guardrailed second opinion, then clamps suggestions to hard guardrails and generates a one-time approval token.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eStores proposals in Google Sheets\u003c\/b\u003e and posts Slack messages with \u003cb\u003eApprove\/Reject\u003c\/b\u003e buttons linking to a webhook approval URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOn approval\u003c\/b\u003e, validates token\/expiry, updates Shopify variant pricing via the \u003cb\u003eAdmin GraphQL API\u003c\/b\u003e, and records approvals\/rejections back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain competitive pricing for SKUs where competitor prices change daily.\u003c\/li\u003e\n  \u003cli\u003eReduce manual pricing decisions using Slack approvals with audit trails in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eHandle messy competitor pages by using GPT-4o as a fallback parser.\u003c\/li\u003e\n  \u003cli\u003eEnforce pricing safety (margin floors\/ceilings, daily caps, cooldowns) before any Shopify update.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes:\u003c\/b\u003e if, code, wait, slack, switch, webhook\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e Google Sheets (configuration, proposals, price history logging), Slack (digest + approval buttons), OpenAI (GPT-4o second opinion + parsing fallback), Shopify Admin GraphQL API (variant price updates), HTTP scraping (competitor pages)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232372904115,"sku":"N8N-21075","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AjZXIA52pYv6SDSa_EolK_iqxDZCm6.png?v=1792141393","url":"https:\/\/buyflowscripts.com\/products\/n8n-competitor-price-repricing-shopify-gpt-4o-slack-approval","provider":"N8N Commerce","version":"1.0","type":"link"}