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.