Monitor D2C inventory, forecast demand with GPT-4o, and send POs via Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 41 nodes and runs on a schedule (every day at 08:00) (plus 4 other triggers). Along the way it connects Google Sheets, Gmail and OpenAI. It also calls dummyjson.com over HTTP.
How it runs
Trigger: On a schedule (every day at 08:00) (plus 4 other triggers).
- Fetch Products (DummyJSON) (HTTP Request): calls dummyjson.com
- Read Inventory Master (Google Sheets): uses Google Sheets
- Read Inventory Master (Google Sheets): uses Google Sheets
- Read Inventory Master (Google Sheets): uses Google Sheets
- Read sales log (Google Sheets): uses Google Sheets
- Simulate Daily Sales (Code): runs custom JavaScript code
- Read Sales Log (Google Sheets): uses Google Sheets
- Filter Stockout SKUs (If): checks a condition and branches into true / false
- Filter Dead & Overstock SKUs (If): checks a condition and branches into true / false
- Read Inventory Master (Google Sheets): uses Google Sheets
…plus 26 more steps. See the full node list below.
Services it uses
HTTP calls to: dummyjson.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Filter
n8n-nodes-base.filter - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
📊 Description Stop finding out you're out of stock after a customer already tried to buy. This workflow monitors your entire product inventory daily, calculates how fast each SKU is selling, and automatically raises purchase orders to your supplier before…