Inventory reconciliation between Notion & Airtable with GPT-4o Slack alerts
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 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Azure OpenAI Chat Model, Google Sheets, Airtable and Notion and 1 more.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Records from Notion Database (Notion): get many (database page)
- Fetch Records from Airtable (Airtable): search
- Merge: merges the data from its input branches
- Validate Payload Structure (If): checks a condition and branches into true / false
- Build Combined Notion + Airtable Payload (Code): runs custom JavaScript code
- Log Invalid Versioning Requests to Google Sheets (Google Sheets): append
- Compare Notion Record With Airtable Record (Code): runs custom JavaScript code
- Check If Record Requires Update (If): checks a condition and branches into true / false
- Update Airtable Record With Corrected Count (Airtable): create or update
- Generate Slack Summary (AI Agent): runs an AI agent, with model: Configure GPT-4o – Slack Summary Model
…plus 3 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 (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Airtable
n8n-nodes-base.airtable - Notion
n8n-nodes-base.notion - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack
From the author
📘 Description This workflow performs automated inventory reconciliation between Notion (physical counts) and Airtable (system counts), ensuring both databases stay synchronized. It fetches records from both systems, merges them into a unified comparison…