Generate AI inventory reorder recommendations from Airtable with GPT-4o, Slack and email
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 17 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Azure OpenAI Chat Model, Airtable, Google Sheets and Slack and 3 more.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Fetch Inventory Records from Airtable (Airtable): search
- Send a message (Gmail): uses Gmail
- Validate Inventory Record Structure (If): checks a condition and branches into true / false
- Generate Inventory Optimization Output (AI) (AI Agent): runs an AI agent, with model: Configure GPT-4o — Inventory Optimization Model
- Log Invalid Inventory Rows to Google Sheet (Google Sheets): append
- Merge AI Optimization Results (Code): runs custom JavaScript code
- Generate Inventory Email Summary (AI Agent): runs an AI agent, with model: Configure GPT-4o Model
- Generate Inventory Slack Summary (AI Agent): runs an AI agent, with model: Configure GPT-4o Model
- Create Asana Task for Inventory Db (Asana): uses Asana
- Log Trade Decision to Notion (inventory db) (Notion): work with database page
…plus 2 more steps. See the full node list below.
Services it uses
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 (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Airtable
n8n-nodes-base.airtable - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Error Trigger
n8n-nodes-base.errorTrigger - Notion
n8n-nodes-base.notion - Asana
n8n-nodes-base.asana
From the author
📘 Description This workflow automates end-to-end AI-driven inventory intelligence, transforming Airtable stock data into optimized reorder recommendations, daily operational summaries, and instant Slack alerts. It fetches all inventory rows, validates…