Inventory check: Notion vs Airtable

Compares Notion counts with Airtable stock, sums up in Slack. This n8n template starts by hand and fetches inventory records from Notion, which holds physical counts, and from Airtable. Merge and Code nodes compare them. When a mismatch is detected, the workflow writes the Notion count into Airtable; Azure OpenAI GPT-4o writes short Slack messages for the operations team depending on whether a discrepancy existed. Broken or incomplete entries are stored in Google Sheets for later review. You need Notion, Airtable, Azure OpenAI, Slack and Google Sheets access. It is for operations teams that count stock in Notion.

n8nRead on 2026-11-1613 steps

Steps

  1. Trigger: Manual trigger starts the reconciliation
  2. Fetches records from NotionNotion
    Physical stock counts.
  3. Fetches records from AirtableAirtable
    System-of-record counts.
  4. Merges Notion and Airtable inputs
  5. Validates the payload structure
  6. Logs invalid requests to Google SheetsGoogle Sheets
  7. Builds the combined payload
  8. Compares the records, calculates the difference
  9. Checks if the record requires an update
  10. Updates the Airtable record with the countAirtable
  11. Configures the GPT-4o Slack summary modelsAzure OpenAI
  12. AI generates the Slack summary
  13. Output: Slack sends the summary notificationSlack

Limits

  • Starts by hand; no schedule is described.
  • Uses Azure OpenAI, not the OpenAI API directly.

What it does well

  • Logs broken or incomplete entries in Google Sheets for review.
  • Notion is the source and Airtable receives the count.

Before you import

Prerequisites listed on the page: a Notion API integration, Airtable API credentials, Azure OpenAI GPT-4o, a Slack API connection and Google Sheets OAuth.

Similar templates