{"product_id":"optimize-dead-shelf-with-n8n-google-sheets-gemini-slack","title":"Optimize Dead Shelf with n8n, Google Sheets, Gemini \u0026 Slack","description":"\u003ch3\u003ePut your dead shelf on a schedule—optimize prime eye-level SKUs with n8n, Google Sheets, Gemini \u0026amp; Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically detects “dead shelf” candidates in your planogrammed prime eye-level assortment, validates recommended actions with \u003cstrong\u003eGemini\u003c\/strong\u003e, writes an actionable plan back to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts a clear daily digest to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eBuilt for daily merchandising decisions, it runs at \u003cstrong\u003e01:00\u003c\/strong\u003e (or via manual trigger) and:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003eLoads configuration thresholds (e.g., \u003cstrong\u003estagnation days\u003c\/strong\u003e, \u003cstrong\u003eexpiry limits\u003c\/strong\u003e, and \u003cstrong\u003eAI batch size\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003eReads \u003cstrong\u003eCatalog_Master\u003c\/strong\u003e, \u003cstrong\u003eSales_Rollup\u003c\/strong\u003e, \u003cstrong\u003eInventory_Snapshot\u003c\/strong\u003e, and \u003cstrong\u003ePlanogram\u003c\/strong\u003e tabs from Google Sheets and joins them into a per-store, per-SKU dataset with cohort stats and a replacement SKU candidate.\u003c\/li\u003e\n  \u003cli\u003eCalculates risk\/performance metrics such as \u003cstrong\u003edays unsold\u003c\/strong\u003e, \u003cstrong\u003edays to expiry\u003c\/strong\u003e, \u003cstrong\u003eprice index vs category median\u003c\/strong\u003e, \u003cstrong\u003erun rate\u003c\/strong\u003e, \u003cstrong\u003edays to clear\u003c\/strong\u003e, and \u003cstrong\u003ecapital at risk\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFilters to prime eye-level SKUs that have stayed in the zone long enough, have stock on hand, and show low sales over the last \u003cstrong\u003e30 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAssigns a recommended action via a rule matrix: \u003cstrong\u003eliquidate\u003c\/strong\u003e, \u003cstrong\u003edelist\u003c\/strong\u003e, \u003cstrong\u003eprice test\u003c\/strong\u003e, \u003cstrong\u003erelocate\u003c\/strong\u003e, or \u003cstrong\u003emonitor\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eRanks suspects by \u003cstrong\u003ecapital at risk\u003c\/strong\u003e, sends the top N items to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for a structured merchandising decision, and applies deterministic guardrails (including pricing clamping and enforcing delist\/replacement rules).\u003c\/li\u003e\n  \u003cli\u003eCreates action tickets (movement, facings, pricing, ERP flags, review date) and upserts them into the \u003cstrong\u003eAction_Queue\u003c\/strong\u003e tab; posts a summary digest to \u003cstrong\u003eSlack\u003c\/strong\u003e and records a run audit log back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily detection and prioritization of \u003cstrong\u003edead shelf\u003c\/strong\u003e items for prime eye-level planograms.\u003c\/li\u003e\n  \u003cli\u003eAutomated liquidate\/delist\/price-test recommendations with AI validation and ERP-ready flags.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility through Slack digests and Google Sheets audit logs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n\u003c\/strong\u003e nodes: set, code, sort, limit, filter, and Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads Catalog_Master, Sales_Rollup, Inventory_Snapshot, Planogram; writes to Action_Queue and run audit logs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e: validates merchandising decisions using structured input for the top N ranked SKUs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSEO note:\u003c\/strong\u003e Ideal for n8n automation engineers and SaaS operators looking to optimize dead shelf management workflows with Google Sheets, Gemini, and Slack.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192849748147,"sku":"N8N-20665","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/bO58-gXGMkwnuenFTny0T_Jxabcgu8.png?v=1791537207","url":"https:\/\/buyflowscripts.com\/products\/optimize-dead-shelf-with-n8n-google-sheets-gemini-slack","provider":"N8N Commerce","version":"1.0","type":"link"}