📖 Classify developer questions with GPT-4o from Slack to Notion & Airtable
⚡ 61 views · 📖 Internal Wiki & Knowledge Base
Description
📘 Description:
This workflow automates the Developer Q&A Classification and Documentation process using Slack, Azure OpenAI GPT-4o, Notion, Airtable, and Google Sheets. Whenever a new message is posted in a specific Slack channel, the workflow automatically:
- Captures and validates the message data
- Uses GPT-4o (Azure OpenAI) to check if the question matches any existing internal FAQs
- Logs answered questions into Notion as new FAQ entries
- Sends unanswered ones to Airtable for human follow-up
- Records any workflow or API errors into Google Sheets This ensures that every developer query is instantly categorized, documented, and tracked, turning daily Slack discussions into a continuously improving knowledge base.
⚙️ What This Workflow Does (Step-by-Step)
🟢 Slack Channel Trigger – Developer Q&A Triggers the workflow whenever a new message is posted in a specific Slack channel. Captures message text, user ID, timestamp, and channel info.
🧩 Validate Slack Message Payload (IF Node) Ensures the incoming message payload contains valid user and text data. ✅ True Path → Continues to extract and process the message ❌ False Path → Logs error to Google Sheets
💻 Extract Question Metadata (JavaScript) Cleans and structures the Slack message into a standardized JSON format — removing unnecessary characters and preparing a clean “question object” for AI processing.
🧠 Classify Developer Question (AI) (Powered by Azure OpenAI GPT-4o) Uses GPT-4o to semantically compare the question with an internal FAQ dataset. If a match is found → Marks as answered and generates a canonical response If not → Flags it as unanswered
🧾 Parse AI JSON Output (Code Node) Converts GPT-4o’s text output into structured JSON so that workflow logic can reference fields like status, answer_quality, and canonical_answer.
⚖️ Check If Question Was Answered (IF Node) If status == “answered”, the question is routed to Notion for documentation; otherwise, it’s logged in Airtable for review.
📘 Save Answered Question to Notion FAQ Creates a new Notion page under the “FAQ” database containing the question, AI’s canonical answer, and answer quality rating — automatically building a self-updating internal FAQ.
📋 Log Unanswered Question to Airtable Adds unresolved or new questions into Airtable for manual review by the developer support team. These records later feed back into the FAQ training loop.
🚨 Log Workflow Errors to Google Sheets Any missing payloads, parsing errors, or failed integrations are logged in Google Sheets (error log sheet) for transparent tracking and debugging.
🧩 Prerequisites:
- Slack API credentials (for message trigger)
- Azure OpenAI GPT-4o API credentials
- Notion API connection (for FAQ database)
- Airtable API credentials (for unresolved questions)
- Google Sheets OAuth connection (for error logging)
💡 Key Benefits:
✅ Automates Slack Q&A classification ✅ Builds and updates internal FAQs with zero manual input ✅ Ensures all developer queries are tracked ✅ Reduces redundant questions in Slack ✅ Maintains transparency with error logs
👥 Perfect For:
- Engineering or support teams using Slack for developer communication
- Organizations maintaining internal FAQs in Notion
- Teams wanting to automatically capture and reuse knowledge from real developer interactions
🔗 Nodes Used
Airtable, Google Sheets, Notion, AI Agent, Azure OpenAI Chat Model, Slack Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File