Shopify to Airtable Inventory Sync with Slack Low-Stock Alerts

Automatically Sync Shopify Inventory to Airtable—and Get Slack Low-Stock Alerts

This n8n workflow listens for paid Shopify orders, subtracts sold quantities from your Airtable inventory per SKU, and instantly posts a Slack low-stock warning whenever stock drops to (or below) your reorder threshold.

What this workflow does

• Triggers on paid Shopify orders once an order is marked as paid.
• Splits the order into individual line items so each SKU is processed separately.
• Finds the matching Airtable inventory record by SKU.
• Calculates and updates stock levels by subtracting the ordered quantity from StockOnHand.
• Checks the reorder threshold after the update.
• Posts to Slack only when needed: if StockOnHand is at or below ReorderThreshold, a warning is sent to your chosen Slack channel; otherwise the workflow ends.

Use cases

• Keep Airtable inventory accurate in near real time without manual SKU tracking after each Shopify sale.
• Notify your team in Slack when a product is about to run out, so you can reorder before stockouts.
• Support operators and SaaS teams who want a reliable “source of truth” for inventory with automated alerts.

Technical details

• Shopify (OAuth2): triggers when orders are marked as paid.
• Airtable: searches and updates an inventory table using fields including SKU, ProductName, StockOnHand, and ReorderThreshold.
• Slack: sends low-stock warnings to a specified channel via Slack OAuth2.
• n8n nodes used: if, set, no op, slack, airtable, split out.

Setup at a glance

• Connect Shopify OAuth2 credentials and ensure the workflow has access to the store’s Admin API order webhooks.
• Connect Airtable Personal Access Token and point nodes to your inventory base/table.
• Connect Slack OAuth2 and select the channel for low-stock alerts.