Inventory reconciliation between Notion & Airtable with GPT-4o Slack alerts

📘 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 payload, validates the structure, and calculates discrepancies. If a mismatch is detected, the workflow automatically updates Airtable with the corrected count and notifies the operations team on Slack. If everything matches, a simple “No action needed” Slack message is sent. Any malformed or incomplete payloads are logged into Google Sheets for audit tracking.

⚙️ What This Workflow Does (Step-by-Step)

🟢 Manual Trigger – Execute Workflow Starts the reconciliation process on demand.

📥 Fetch Records from Notion Retrieves physical stock data (cycle count) stored in Notion.

📦 Fetch Records from Airtable Loads inventory data from Airtable’s system-of-record table.

🔀 Merge Notion + Airtable Inputs Combines both datasets into a single payload for unified processing.

🔍 Validate Payload Structure (IF Node) Ensures that key fields (like id) exist. Valid → continue Invalid → logged to Google Sheets.

🧾 Log Invalid Versioning Requests to Google Sheets Stores broken or incomplete payload entries for later review.

🧮 Build Combined Notion + Airtable Payload (Code Node) Constructs the structured comparison object: { notion: {...}, airtable: [...] }

📊 Compare Notion Record With Airtable Record (Code Node) Performs core reconciliation logic: Matches items by name Compares physical vs. system count Calculates difference Determines if a correction is needed If mismatch → flagged for update.

🔎 Check If Record Requires Update (IF Node) Branches logic into: Mismatch → Update Airtable + Alert Match → No action summary

🛠️ Update Airtable Record With Corrected Count Writes the accurate physical count from Notion into Airtable.

🧠 Configure GPT-4o – Slack Summary Models Two models: For “no action needed” summaries For “Airtable updated” discrepancy alerts

🤖 Generate Slack Summary / Generate Slack Summary1 AI produces short, precise, operations-friendly Slack messages based on whether a discrepancy existed.

💬 Slack – Send Summary Notification / Send Update Notification Sends final Slack message to the operations user, confirming: Stock match status Updates made Item details Difference values

🧩 Prerequisites

• Notion API integration
• Airtable API credentials
• Azure OpenAI GPT-4o
• Slack API connection
• Google Sheets OAuth

💡 Key Benefits

✔ Eliminates manual reconciliation errors ✔ Keeps Airtable continuously aligned with real physical counts ✔ Provides instant Slack visibility to operations teams ✔ Logs all invalid or malformed cases ✔ Centralizes Notion + Airtable consistency checks

👥 Perfect For

• Operations teams managing multi-system inventory
• Warehouse cycle count workflows
• Audit-driven companies needing accurate stock data
• Businesses using Notion + Airtable as parallel systems