Predict Shopify stockouts with GPT-4o and email suppliers via Gmail
🚀 How it works Runs daily at 06:00 UTC, pulls every Shopify product variant's stock level, calculates real sales velocity from the last 7 days of orders, then uses GPT-4o to predict stockout dates and decide whether ...
Template notes
🚀 How it works Runs daily at 06:00 UTC, pulls every Shopify product variant's stock level, calculates real sales velocity from the last 7 days of orders, then uses GPT-4o to predict stockout dates and decide whether to reorder — automatically. - 🛍️ Fetches all Shopify product variants and current inventory quantities - 📦 Pulls the last 7 days of orders and computes units sold per variant - ⚡ Calculates sales velocity (units/day) and estimated days until stockout - 🤖 AI Agent classifies risk: critical / high / medium / low and recommends reorder quantity (30-day demand + 20% safety buffer) - 📧 Sends a formatted reorder request email to your supplier for high-risk variants - 📊 Logs every decision (reordered or skipped) to Google Sheets for inventory tracking 🛠️ Set up steps Estimated setup time: ~15 minutes 1. Shopify — create a Custom App in your Shopify Admin → Apps → Develop Apps; enable readproducts and readorders scopes; copy the Admin API Access Token 2. OpenAI — connect your OpenAI API credential (GPT-4o) 3. Gmail — connect Gmail OAuth2; replace supplier@example.com with your real supplier address 4. Google Sheets — connect Google Sheets OAuth2; replace YOURREORDERLOGSHEETID with your sheet ID; create a sheet tab named Reorder Log 5. Follow the sticky notes inside the workflow for per-node guidance 📋 Prerequisites - Shopify store (any plan with Admin API access) - OpenAI API key - Gmail account for supplier notifications - Google Sheets for reorder log Custom Workflow Request with Personal Dashboard
kumar@smartflowcraft.com
https://www.smartflowcraft.com/contact
More free templates https://www.smartflowcraft.com/n8n-templates