AI-driven inventory management with OpenAI forecasting & ERP integration

by Oneclick AI Squad ✓ · 8,780 views · created 2025-11-05 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 12 nodes and runs on a schedule (every 6 hours). Along the way it connects OpenAI and Postgres.

How it runs

Trigger: On a schedule (every 6 hours).

1. Fetch Current Inventory (HTTP Request): calls an HTTP API
2. Fetch Sales Velocity (HTTP Request): calls an HTTP API
3. Merge Inventory & Sales Data (Code): runs custom JavaScript code
4. AI Demand Forecasting (OpenAI): work with custom api call
5. Parse AI Response (Code): runs custom JavaScript code
6. Filter: keeps only the items that match a condition
7. Create Purchase Order (Code): runs custom JavaScript code
8. Send PO to Supplier (HTTP Request): calls an HTTP API (POST)
9. Log to ERP System (HTTP Request): calls an HTTP API (POST)
10. Save to Database (Postgres): run a query

…plus 1 more step. See the full node list below.

Services it uses

OpenAIPostgres

Before you upgrade to n8n 3.0

Nodes used (7)

• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Filtern8n-nodes-base.filter
• Postgresn8n-nodes-base.postgres
• Send Emailn8n-nodes-base.emailSend
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

This n8n workflow automates the monitoring of warehouse inventory and sales velocity to predict demand, generate purchase orders automatically, send them to suppliers, and record all transactions in ERP and database systems. It uses AI-driven forecasting to…

View the original on n8n.io → Check your own copy