Automated Slack IT Helpdesk with GPT, Supabase Vector Search, and JIRA Ticketing

Description

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Who is this for?
IT teams and support organizations looking to automate Level 1 support with AI-powered assistance while maintaining proper ticket management workflows.

What problem does this solve?
Eliminates repetitive manual support tasks by providing instant, context-aware assistance that references organizational knowledge and creates structured tickets when needed.

What this workflow does
RAG Pipeline**: Processes PDF/CSV documents into searchable vector database
Intelligent Slack Bot**: This AI-helpdesk assistant handles support requests with thread-aware conversations
Vector Knowledge Search**: Searches embedded knowledge base articles and historical case data
JIRA Integration**: Creates, searches, and manages support tickets automatically
Emoji Reactions**: Users can trigger actions (create tickets, escalate) via emoji reactions

Requirements
Required Accounts:
n8n Cloud or self-hosted instance
Slack workspace with admin access
Supabase account (vector database)
JIRA Cloud instance
OpenAI API key

Technical Prerequisites:
Basic n8n workflow knowledge
Slack app creation experience
Understanding of vector databases

Setup Steps

1. Slack App Configuration
Create new Slack app with Bot Token Scopes: app_mentions:read, channels:history, channels:read, groups:history, groups:read, im:history, im:read, mpim:history, mpim:read, users:read
Configure Event Subscriptions: app_mention, message.channels, message.groups, reaction_added
Set Request URL to your n8n Slack Trigger webhook

2. Supabase Vector Database Setup
Create new Supabase project
Enable pgvector extension
Create documents table with vector column (1536 dimensions for OpenAI embeddings)
Configure RLS policies for secure access

3. JIRA Configuration
Generate API token from JIRA Cloud
Create helpdesk project with appropriate issue types
Note project ID and issue type IDs for workflow configuration

4. n8n Workflow Configuration
Import workflow and configure credentials
Update Slack channel IDs in trigger nodes
Set OpenAI API key in all OpenAI nodes
Configure Supabase connection in vector store nodes
Update JIRA project settings in MCP server nodes

5. Knowledge Base Data Format
Supported file formats: PDF, CSV
CSV Structure: Structure your data with columns, but not limited to, Ticket#, Issue Description, Issue Summary, Resolution Provided, Case Status, Contact User
PDF Content: Technical documentation, troubleshooting guides, policy documents

Upload documents via the form trigger to automatically embed in vector database.

Customization Options

AI Agent Behavior
Modify system prompt in AIHelpdesk Agent node
Adjust conversation memory window (default: 20 messages)
Change AI model (GPT-4o, GPT-3.5-turbo, etc.)

Reaction Mappings
Customize emoji-to-action mappings in Reaction Handler code
Add new reaction types for department-specific workflows
Configure escalation rules and priority levels

JIRA Integration
Customize ticket templates and fields
Add auto-assignment rules based on issue type
Configure SLA and priority mappings

Vector Search
Adjust similarity thresholds for knowledge retrieval
Modify search result limits and relevance scoring
Add metadata filtering for departmental knowledge bases

Advanced Features
Thread-aware conversation memory
Automatic bot loop prevention
Context-preserving ticket creation
Multi-modal file processing (PDF + CSV)
Scalable MCP architecture for tool integration

Use Cases
Level 1 IT Support**: Automate common troubleshooting workflows
Employee Onboarding**: Answer policy and procedure questions
Internal Help Desk**: Route and track internal service requests
Knowledge Management**: Make organizational knowledge searchable and actionable

Template includes
Complete Slack integration with thread support
RAG pipeline for document processing
Vector similarity search implementation
JIRA ticket lifecycle management
Emoji reaction-based user interactions
Comprehensive error handling and validation