🤝 Monitor Shopify low-stock items with OpenAI, Google Sheets, Slack and email
⚡ 133 views · 🤝 CRM & Sales Operations
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.
🔗 Nodes Used
Google Sheets, Slack, Shopify, Gmail, Schedule Trigger, Basic LLM Chain
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File