{"product_id":"n8n-inventory-sync-shopify-amazon-flipkart-via-google-sheets-slack-alerts","title":"n8n Inventory Sync Shopify Amazon Flipkart via Google Sheets + Slack Alerts","description":"\u003ch3\u003eKeep Shopify, Amazon, and Flipkart inventory perfectly in sync—using Google Sheets as the master ledger and Slack for instant alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically syncs a single, unified inventory count across \u003cstrong\u003eShopify\u003c\/strong\u003e, \u003cstrong\u003eAmazon (SP-API)\u003c\/strong\u003e, and \u003cstrong\u003eFlipkart\u003c\/strong\u003e every \u003cstrong\u003e10 minutes\u003c\/strong\u003e. It uses \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to track inventory and order processing, applies a \u003cstrong\u003esafety buffer\u003c\/strong\u003e to calculate sellable quantities, updates channel availability, and posts \u003cstrong\u003elow-stock, out-of-stock, oversold, and failure alerts\u003c\/strong\u003e to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled sync (every 10 minutes)\u003c\/strong\u003e: Reads the last orders cursor from Google Sheets and uses an overlap window to avoid missing updates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads inventory sources\u003c\/strong\u003e: Pulls the \u003cstrong\u003eInventory Master\u003c\/strong\u003e, the \u003cstrong\u003eProcessed Lines\u003c\/strong\u003e ledger for deduplication, and any \u003cstrong\u003epending manual stock adjustments\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches order\/shipment changes\u003c\/strong\u003e: Retrieves updated orders from \u003cstrong\u003eShopify\u003c\/strong\u003e (GraphQL), fetches updated \u003cstrong\u003eAmazon\u003c\/strong\u003e line items via \u003cstrong\u003eSP-API\u003c\/strong\u003e (using an \u003cstrong\u003eLWA token\u003c\/strong\u003e), and pulls \u003cstrong\u003eFlipkart\u003c\/strong\u003e pre-dispatch and cancelled shipments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes sellable quantity\u003c\/strong\u003e: Calculates per-SKU stock movements, applies cancellations and queued adjustments, and subtracts each SKU’s \u003cstrong\u003esafety buffer\u003c\/strong\u003e to determine sellable inventory.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates only what changed\u003c\/strong\u003e: Pushes updated sellable quantities to \u003cstrong\u003eShopify\u003c\/strong\u003e, \u003cstrong\u003eAmazon listing availability\u003c\/strong\u003e, and \u003cstrong\u003eFlipkart inventory\u003c\/strong\u003e—or performs a \u003cstrong\u003enightly full sync\u003c\/strong\u003e when required.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLedger + state updates\u003c\/strong\u003e: Writes SKU totals back to the Inventory Master, appends new ledger entries to Processed Lines, marks adjustments as applied, and saves the new cursor (Sync State).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack alerts\u003c\/strong\u003e: Sends alerts for \u003cstrong\u003eoversold\/out-of-stock\/low-stock\u003c\/strong\u003e SKUs (including recent sales velocity and days of cover) and posts a separate Slack alert if any run fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePrevent overselling by keeping sellable stock accurate across \u003cstrong\u003emultiple sales channels\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eUse Google Sheets as a human-editable \u003cstrong\u003einventory control center\u003c\/strong\u003e with audit-ready ledgers.\u003c\/li\u003e\n  \u003cli\u003eMonitor health of your inventory sync with \u003cstrong\u003eSlack notifications\u003c\/strong\u003e for both stock risk and workflow failures.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: if, code, slack, sticky note, form trigger, http request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets (Inventory Master, Processed Lines, Sync State), Shopify (GraphQL), Amazon SP-API (LWA token), Flipkart (pre-dispatch + cancelled shipments), Slack alerts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46254510047411,"sku":"N8N-21270","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9mrPV2DQYIRBzJFN1eDWD_M1zQs1kF.png?v=1792573593","url":"https:\/\/buyflowscripts.com\/products\/n8n-inventory-sync-shopify-amazon-flipkart-via-google-sheets-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}