Monitor D2C inventory, forecast demand with GPT-4o, and send POs via Google Sheets and Gmail
Read Inventory Master
googleSheets
Read Sales Log
googleSheets
IF Dead or Overstock
IF Stockout Risk
Read Inventory Master1
googleSheets
Read Inventory Master2
googleSheets
Read sales log
googleSheets
Read Inventory Master3
googleSheets
Build Forecast Prompt
Build Forecast Email
🕐 Daily 8AM Trigger
Fetch Products (DummyJSON)
dummyjson.com
Simulate Daily Sales
Log to Sales Log
googleSheets
Write to Inventory Master
googleSheets
Daily 8:05AM Trigger
Calculate Velocity & Flags
Alert — Stockout Risk
gmail
Alert — Dead Stock
gmail
Update Flags (Stockout)
googleSheets
Update Flags (Dead Stock)
googleSheets
Daily 8:10AM Trigger
Filter Stockout SKUs
Calculate Reorder Quantity
Skip Zero-Velocity SKUs
filter
Send PO to Supplier
gmail
Log PO to Tracker
googleSheets
Notify — PO Raised
gmail
Weekly Sunday 9AM Trigger
Filter Dead & Overstock SKUs
Build GPT Prompt
Inventory Strategist
openai
Parse AI Recommendations
Build Weekly Digest Email
Send Weekly Digest
gmail
Weekly Sunday 9:30AM Trigger
Aggregate 90 Day Sales
Demand Forecaster
openai
Parse Forecast Response
Filter Actionable SKUs
filter
Send Forecast Report
gmail
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.