Monitor Shopify low-stock items with OpenAI, Google Sheets, Slack and email

Description

(Retail) Supplier Restock Request Trigger

This workflow automatically monitors your Shopify inventory, detects low-stock products, generates smart alert messages, logs records in Google Sheets and sends priority-based notifications to Slack.

This workflow checks your Shopify store every 5 hours, identifies products with low inventory (≤10 units), generates professional alert messages using AI, prevents duplicate alerts using Google Sheets, assigns priority based on stock level and notifies your team on Slack.

You receive:

Automated inventory checks every 5 hours**
Google Sheet tracking for low-stock products**
Priority-based Slack alerts (High / Medium / Low)**

Ideal for teams that want proactive inventory visibility without manual stock checks.

Quick Start – Implementation Steps

Connect your Shopify account to fetch products and inventory.
Connect OpenAI to generate alert messages.
Connect a Google Sheet for tracking alerts.
Connect Slack to receive notifications.
Activate the workflow — monitoring starts automatically.
What It Does

This workflow automates low-stock monitoring for Shopify products:

Runs automatically every 5 hours.
Fetches all products and inventory levels from Shopify.
Cleans and prepares product data (SKU, name, stock, vendor).
Processes products in small batches to avoid overload.
Filters only products with stock ≤ 10 units.
Generates a professional alert message using AI.
Checks Google Sheets to avoid duplicate records.
Appends new records or updates existing ones.
Assigns priority based on stock level:
2 units → High priority
6 units → Medium priority
10 units → Low priority
Sends a clear Slack alert to the team.

This ensures timely restocking with no duplicate alerts.

Who’s It For

This workflow is ideal for:

E-commerce store owners
Inventory & operations teams
Shopify store managers
Supply chain teams
Startups managing limited stock
Businesses wanting automated restock alerts
Requirements to Use This Workflow

To run this workflow, you need:

n8n instance** (cloud or self-hosted)
Shopify store** with API access
OpenAI API key**
Google Sheets** access
Slack workspace** with API permissions

No advanced technical knowledge required.

How It Works

Scheduled Check – Workflow runs every 5 hours.
Fetch Products – Retrieves all Shopify products.
Prepare Data – Extracts SKU, name, stock, vendor.
Low-Stock Filter – Keeps only items ≤ 10 units.
AI Message Creation – Generates alert text.
Duplicate Check – Looks up Google Sheet records.
Update or Insert – Keeps the sheet up to date.
Priority Assignment – Sets urgency level.
Slack Alert – Notifies the team instantly.
Setup Steps

Import the provided n8n workflow JSON.
Open the Shopify nodes → connect your Shopify credentials.
Add your OpenAI API key in the AI nodes.
Connect your Google Sheets account and map fields.
Connect Slack and select the alert channel.
Adjust stock thresholds if needed.
Activate the workflow — done!
How To Customize Nodes

Customize Stock Thresholds

Modify the IF / Switch nodes to:

Change low-stock limits
Add more priority levels
Customize Alert Messages

Edit the AI prompt to:

Change tone (urgent, friendly, formal)
Add emojis or mentions
Include pricing or vendor info
Customize Google Sheet Fields

You can add:

Vendor name
Last updated date
Restock status
Assigned team member
Customize Slack Alerts

Enhance messages with:

@mentions
Emojis
Links to Shopify product pages
Add-Ons (Optional Enhancements)

You can extend this workflow to:

Send email alerts
Create weekly summary reports
Add auto-restock triggers
Integrate with ERP systems
Track restock completion
Add dashboards using Google Sheets
Use Case Examples

1\. Inventory Monitoring

Automatically track low-stock items.

2\. Restock Planning

Prioritize restocking based on urgency.

3\. Team Alerts

Notify operations instantly via Slack.

4\. Audit & Tracking

Maintain a clean inventory alert log.

5\. Store Scaling

Prevent stock-outs as order volume grows.

Troubleshooting Guide

| Issue | Possible Cause | Solution |
|----------------------|----------------------|----------------------------------|
| No Slack alerts | Slack not connected | Check Slack credentials |
| Duplicate rows | SKU mismatch | Ensure SKU is consistent |
| No low-stock items | Threshold too low | Adjust IF condition |
| AI message empty | OpenAI key missing | Verify API key |
| Workflow not running | Trigger disabled | Enable Schedule Trigger |

Need Help?

If you need help customizing or extending this workflow with advanced features like adding analytics, ERP integrations, advanced alerts or scaling it for high-volume stores, then our n8n workflow developers at WeblineIndia are happy to help.