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.
Steps
- Trigger: Manual trigger starts the reconciliation
- Fetches records from NotionNotion
Physical stock counts. - Fetches records from AirtableAirtable
System-of-record counts. - Merges Notion and Airtable inputs
- Validates the payload structure
- Logs invalid requests to Google SheetsGoogle Sheets
- Builds the combined payload
- Compares the records, calculates the difference
- Checks if the record requires an update
- Updates the Airtable record with the countAirtable
- Configures the GPT-4o Slack summary modelsAzure OpenAI
- AI generates the Slack summary
- 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
Meeting action items to Asana tasks
Also for scheduling and ops, 9 steps.
Calendly meeting prep briefs by email
Also for scheduling and ops, 7 steps.
Competitor watch report with GPT-4o
Also for scheduling and ops, 7 steps.
Google Sheets and Slack: 16 templates compared
Same two apps, different steps.
Google Sheets and Notion: 3 templates compared
Same two apps, different steps.
Notion and Slack: 3 templates compared
Same two apps, different steps.
Airtable and Google Sheets: 2 templates compared
Same two apps, different steps.
Azure OpenAI and Google Sheets: 2 templates compared
Same two apps, different steps.
Azure OpenAI and Slack: 2 templates compared
Same two apps, different steps.
Copy records between apps
Other templates that do this task.