Extract Airtable data and send analyzed messages to Slack
Workflow Description
Automation that retrieves records from Airtable, processes them in batches with AI analysis, removes duplicates, and delivers organized notifications to relevant Slack channels based on data categories and conditions.
How it works
- 1.Trigger when new records are added or modified in Airtable
- 2.Process data in batches and analyze content using OpenAI intelligence
- 3.Remove duplicate entries and apply conditional routing rules
- 4.Send formatted messages to appropriate Slack channels
Use cases
- Monitor new projects and alert teams instantly through Slack notifications
- Collect feedback from Airtable and distribute summaries to team members
Requirements
- Active Airtable account with configured database and table structure
- Slack workspace with API token and message posting permissions
- OpenAI API key for intelligent content analysis and summarization
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (19)
Issues to List
Split Out
OpenAI Chat Model
OpenAI
Combine Sentiment Analysis
Set
Sentiment over Issue Comments
Information Extractor
Copy of Issue
Set
For Each Issue...
Split In Batches
Get Existing Sentiment
Airtable
Update Row
Airtable
Airtable Trigger
Airtable Trigger
Sentiment Transition
Switch
Fetch Active Linear Issues
Graphql
Schedule Trigger
Schedule Trigger
Deduplicate Notifications
Remove Duplicates
Report Issue Negative Transition
Slack
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note