{"product_id":"n8n-workflow-shopify-low-stock-alerts-to-google-sheets-csv","title":"n8n Workflow: Shopify Low Stock Alerts to Google Sheets\/CSV","description":"\u003ch3\u003eKnow which Shopify variants will run out—before they do\u003c\/h3\u003e\n\u003cp\u003eThis free \u003cstrong\u003en8n workflow\u003c\/strong\u003e automatically calculates \u003cstrong\u003eLOW \/ OUT inventory alerts\u003c\/strong\u003e for your \u003cstrong\u003eShopify\u003c\/strong\u003e products using the last 30 days of unit sales, then exports actionable results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (or a \u003cstrong\u003eCSV\u003c\/strong\u003e file). Optional demo mode uses built-in mock data—no LLM required.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun manually\u003c\/strong\u003e and load configuration such as data source mode (mock or Shopify), lookback windows, and output destination.\u003c\/li\u003e\n  \u003cli\u003eIn \u003cstrong\u003emock mode\u003c\/strong\u003e, generates sample product variants with inventory and 7\/30-day sales (for testing the logic).\u003c\/li\u003e\n  \u003cli\u003eIn \u003cstrong\u003elive Shopify mode\u003c\/strong\u003e, queries the \u003cstrong\u003eShopify Admin GraphQL API\u003c\/strong\u003e for products\/variants and recent orders.\u003c\/li\u003e\n  \u003cli\u003eNormalizes Shopify product + order data into a per-variant dataset including:\n    \u003cul\u003e\n      \u003cli\u003einventory quantity\u003c\/li\u003e\n      \u003cli\u003einventory tracking status\u003c\/li\u003e\n      \u003cli\u003eunits sold over the last 7 and 30 days\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eCalculates each variant’s \u003cstrong\u003eaverage daily sales\u003c\/strong\u003e, \u003cstrong\u003ereorder point\u003c\/strong\u003e, suggested order quantity, \u003cstrong\u003edays of cover\u003c\/strong\u003e, and status: \u003cstrong\u003eOK\u003c\/strong\u003e, \u003cstrong\u003eLOW\u003c\/strong\u003e, \u003cstrong\u003eOUT\u003c\/strong\u003e, \u003cstrong\u003eNO_SALES\u003c\/strong\u003e, or \u003cstrong\u003eNOT_TRACKED\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWrites results to a Google Sheets \u003cstrong\u003e“Alerts”\u003c\/strong\u003e tab (append or update by SKU) or to a CSV output file.\u003c\/li\u003e\n  \u003cli\u003eCreates a bilingual (EN\/ZH) \u003cstrong\u003eSummary\u003c\/strong\u003e with status counts and top reorder candidates, outputting to a \u003cstrong\u003e“Summary”\u003c\/strong\u003e tab or a summary CSV.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly (manual) review of \u003cstrong\u003elow stock alerts\u003c\/strong\u003e for Shopify variants with export-ready reporting.\u003c\/li\u003e\n  \u003cli\u003eTesting reorder logic in \u003cstrong\u003edemo mode\u003c\/strong\u003e before connecting Shopify credentials.\u003c\/li\u003e\n  \u003cli\u003eFeeding inventory insights to finance\/ops via \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e or \u003cstrong\u003eCSV\u003c\/strong\u003e for downstream automation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTech stack \/ nodes:\u003c\/strong\u003e if, code, sticky note, http request, google sheets, convert to file\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eShopify authentication:\u003c\/strong\u003e uses an HTTP Header Auth credential with \u003cstrong\u003eX-Shopify-Access-Token\u003c\/strong\u003e (scopes like \u003cem\u003eread_products\u003c\/em\u003e, \u003cem\u003eread_inventory\u003c\/em\u003e, \u003cem\u003eread_orders\u003c\/em\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217918283955,"sku":"N8N-20832","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PmVakYJ2RNrgaz3Upd6P_54LSegZE.png?v=1791882969","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-shopify-low-stock-alerts-to-google-sheets-csv","provider":"N8N Commerce","version":"1.0","type":"link"}