A Comprehensive Suite of AI Agents for Effortless Odoo Management
OdooSense V2 is an advanced AI-powered platform that transforms how you interact with Odoo ERP systems. Built with cutting-edge LangChain and LangGraph technologies, it provides intelligent agents that understand natural language and execute complex Odoo operations seamlessly.
OdooSense V2 eliminates the complexity of traditional ERP interactions by providing conversational AI agents that can understand natural language queries in plain English, execute complex Odoo operations without technical knowledge, generate professional reports in multiple formats, create interactive visualizations, navigate Odoo modules intelligently, process documents and extract data automatically, and manage CRUD operations with conversational ease.
Try OdooSense_V2 live! Experience the power of AI-driven Odoo management with our interactive demo.
Website: demo.odoosense.xyz
Use these credentials to explore the full functionality:
- Odoo URL:
https://demoinstance.odoosense.xyz - Database:
demo - Username:
admin - Password:
admin
- Ask natural language questions about your Odoo data
- Generate professional PDF reports and interactive charts
- Create and manage records through conversation
- Process documents and extract business data
- Navigate Odoo modules with AI assistance
- Experience the power of Documentation RAG for instant help
Start by connecting to the demo Odoo instance using the credentials above, then try asking questions like "Show me all customers" or "Generate a sales report for this month".
flowchart TD
A[User Input] --> B{Enhanced Agent Router}
B -->|Data Operations| C[Dynamic CRUD Agent]
B -->|Reports & Charts| D[Dynamic Reporting Agent]
B -->|Navigation & Help| E[Main LangGraph Agent]
B -->|Document Processing| F[Document Processing Agent]
B -->|LinkedIn Data| G[LinkedIn Processing Agent]
C --> C1[Data Retrieval]
C --> C2[Record Creation]
C --> C3[Data Updates]
C --> C4[Complex Queries]
D --> D1[PDF Reports]
D --> D2[Interactive Charts]
D --> D3[Excel Exports]
D --> D4[CSV Exports]
E --> E1[Navigation Guide]
E --> E2[Documentation RAG]
E --> E3[Quick Shortcuts]
E --> E4[Q&A Processing]
F --> F1[Bill Processing]
F --> F2[Invoice Analysis]
F --> F3[Lead Generation]
G --> G1[Profile Processing]
G --> G2[Lead Creation]
G --> G3[Company Analysis]
C1 --> H[(Odoo Database)]
C2 --> H
C3 --> H
C4 --> H
D1 --> I[(File Storage)]
D2 --> I
D3 --> I
D4 --> I
E2 --> J[(Odoo Documentation)]
E3 --> H
F1 --> H
F2 --> H
F3 --> H
G1 --> H
G2 --> H
G3 --> H
H --> K[Gemini AI Processing]
J --> K
I --> L[Response Formatter]
K --> L
L --> M[User Interface]
classDef userNode fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef routerNode fill:#fff3e0,stroke:#f57c00,stroke-width:2px
classDef agentNode fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef operationNode fill:#e8f5e8,stroke:#388e3c,stroke-width:2px
classDef dataNode fill:#ffebee,stroke:#d32f2f,stroke-width:2px
classDef aiNode fill:#fff9c4,stroke:#fbc02d,stroke-width:2px
classDef responseNode fill:#e0f2f1,stroke:#00796b,stroke-width:2px
class A userNode
class B routerNode
class C,D,E,F,G agentNode
class C1,C2,C3,C4,D1,D2,D3,D4,E1,E2,E3,E4,F1,F2,F3,G1,G2,G3 operationNode
class H,I,J dataNode
class K aiNode
class L,M responseNode
curl -O https://raw.githubusercontent.com/Shamlan321/OdooSense_V2/main/install-odoosense.sh
chmod +x install-odoosense.sh
./install-odoosense.shNote:- To Install RAG Documentation Assistant Follow RAG Install Steps
- User Input: User sends a natural language query through the chat interface
- Enhanced Agent Router: Analyzes intent and routes to the appropriate specialized agent
- Specialized Agent Processing: Each agent handles specific operations:
- Dynamic CRUD Agent: Data retrieval, record creation, updates, and complex queries
- Dynamic Reporting Agent: PDF reports, interactive charts, Excel/CSV exports
- Main LangGraph Agent: Navigation guidance, documentation RAG, shortcuts, Q&A
- Document Processing Agent: Bill processing, invoice analysis, lead generation
- LinkedIn Processing Agent: Profile processing, lead creation, company analysis
- Data Layer Interaction:
- Odoo Database: Core ERP data storage and retrieval
- File Storage: Generated reports and exported files
- Odoo Documentation: Knowledge base for RAG functionality
- AI Processing: Gemini AI processes queries and generates intelligent responses
- Response Formatting: Results are formatted and delivered through the user interface
- LangGraph Agent: Orchestrates the workflow with stateful nodes
- Gemini Integration: Handles text generation and vision processing
- Odoo Client: Manages ERP interactions via XML-RPC
- CLI Interface: Rich terminal interface with Click and Rich
- Intent Classification: Determines user intent and extracts entities
- Document Processing: Processes uploaded files with Gemini Vision
- CRUD Operations: Performs Odoo database operations
- Q&A Navigation: Handles questions and navigation requests
- Response Generation: Formulates final responses with context
The intelligent traffic controller
Purpose: Routes user queries to the most appropriate specialized agent based on intent analysis.
Capabilities:
- Natural language intent classification
- Intelligent query routing
- Session and credential management
- Multi-agent coordination
- Error handling and fallback mechanisms
When it activates: Every user interaction starts here for optimal routing.
Your data operations specialist
Purpose: Handles all data lookup, creation, reading, updating, and deletion operations in Odoo.
Capabilities:
- Data Retrieval: Find customers, products, orders, invoices, employees
- Record Creation: Create new leads, contacts, sales orders, expenses
- Data Updates: Modify existing records with natural language
- Complex Queries: Multi-table joins and advanced filtering
- Textual Reports: Generate formatted text-based reports and summaries
- Data Analysis: Provide insights and breakdowns of business data
Technologies: LangChain agents with dynamic tool generation, Gemini AI integration
Your visualization and export expert
Purpose: Generates professional reports, charts, and exports data in various formats.
Capabilities:
- PDF Reports: Professional formatted reports with tables and styling
- Interactive Charts: Bar charts, line graphs, pie charts, scatter plots
- Excel Exports: Formatted spreadsheets with auto-sizing and styling
- CSV Exports: Clean data exports for further analysis
- Data Visualizations: Plotly-powered interactive charts
- Dashboard Creation: Multi-chart dashboards and analytics
Technologies: ReportLab (PDF), Plotly (Charts), OpenPyXL (Excel), Pandas (Data processing)
The core intelligence hub
Purpose: Handles navigation, documentation, Q&A, and complex multi-step workflows.
Capabilities:
- Navigation Assistance: Guide users through Odoo modules and menus
- Documentation RAG: Answer how-to queries using official Odoo documentation with intelligent retrieval
- Quick Shortcuts: Provide direct links and shortcuts to relevant Odoo records and pages
- Document Processing: Extract data from uploaded files (bills, invoices, etc.)
- LinkedIn Integration: Process LinkedIn data and create leads
- Multi-step Workflows: Handle complex business processes
- Session Management: Maintain conversation context and memory
Technologies: LangGraph state machines, Multi-node processing, Advanced RAG on Odoo documentation
Your document intelligence specialist
Purpose: Extracts and processes data from various document types.
Capabilities:
- Bill Processing: Extract vendor, amount, and line items
- Invoice Analysis: Parse customer invoices and payment terms
- Lead Generation: Convert business cards and contact info
- Expense Management: Process expense receipts and categorize
- Multi-format Support: PDF, images, text documents
- Automatic Classification: Identify document types automatically
Your social business intelligence
Purpose: Processes LinkedIn data and converts it into actionable Odoo records.
Capabilities:
- Profile Processing: Extract contact information from LinkedIn profiles
- Lead Creation: Convert LinkedIn contacts to Odoo leads
- Company Analysis: Process company information and create partners
- Relationship Mapping: Identify business connections and opportunities
- Data Enrichment: Enhance existing contacts with LinkedIn data
- Official Odoo Documentation: Powered by RAG (Retrieval Augmented Generation) on official Odoo docs
- How-to Query Resolution: Instant answers to "How do I..." questions with step-by-step guidance
- Smart Shortcuts: Direct links to relevant Odoo records, forms, and configuration pages
- Contextual Help: Provides relevant documentation snippets based on your current workflow
- Natural language processing with context awareness
- Intent classification and entity extraction
- Multi-turn conversation support
- Query disambiguation and clarification
- PDF Reports: Professional business reports with formatting
- Excel Files: Structured data with charts and formatting
- CSV Exports: Clean data for analysis and import
- Interactive Charts: Web-based visualizations
- HTML Dashboards: Multi-chart analytics views
- Real-time Odoo API connectivity
- Session-based credential management
- Multi-database support
- Secure authentication handling
- Sales trend analysis
- Revenue reporting
- Customer insights
- Performance metrics
- Custom KPI tracking
- LangChain: Agent orchestration and tool management
- LangGraph: State-based conversation flows
- Google Gemini: Large language model for natural language understanding
- RAG (Retrieval Augmented Generation): Enhanced knowledge retrieval
- Python 3.8+: Core application language
- Flask: Web framework and API server
- SQLAlchemy: Database ORM
- Pandas: Data manipulation and analysis
- XMLRPClib: Odoo API integration
- React: Modern web interface
- Tailwind CSS: Responsive styling
- Socket.IO: Real-time communication
- Plotly.js: Interactive charts and visualizations
- ReportLab: PDF generation
- OpenPyXL: Excel file creation
- Plotly: Interactive visualizations
- Pandas: Data analysis and transformation
- Docker: Containerization support
- Redis: Session and cache management
- PostgreSQL: Database backend
- Nginx: Reverse proxy and static file serving
Before installing OdooSense V2, ensure you have the following prerequisites:
- Operating System: Linux (Ubuntu 18.04+, CentOS 7+, Debian 9+)
- Memory: Minimum 4GB RAM (8GB recommended)
- Storage: At least 10GB free disk space
- Network: Internet connection for downloading dependencies and API access
- Python 3.8+: Core runtime environment
- Node.js 16+: For frontend components
- Docker & Docker Compose: For containerized deployment
- Git: For source code management
- PostgreSQL 12+: Database backend (with pgvector extension)
- Redis: Session and cache management (optional but recommended)
- Google Gemini API Key: Required for AI functionality
- Odoo Instance: Access to Odoo 18
- Apify API Key: Optional, for enhanced LinkedIn data processing
- Outbound Internet Access: For API calls to Google Gemini
- Odoo API Access: Network connectivity to your Odoo instance
- Port Availability: Ports 3000 (frontend), 5000 (backend), 8000 (API), 8501 (documentation UI)
The easiest way to install OdooSense V2 is using the automated installation script:
curl -O https://raw.githubusercontent.com/Shamlan321/OdooSense_V2/main/install-odoosense.sh
chmod +x install-odoosense.sh
./install-odoosense.shThis script will:
- Install all required dependencies (Python, Node.js, Docker)
- Clone both the main application and documentation agent repositories
- Set up the environment configuration
- Configure Docker containers
- Initialize the database and documentation system
For Ubuntu/Debian:
# Update package list
sudo apt-get update
# Install Python and Node.js
sudo apt-get install -y python3 python3-pip python3-venv nodejs npm git curl
**For CentOS/RHEL:**
```bash
# Install Python and Node.js
sudo yum install -y python3 python3-pip nodejs npm git curl
#### Step 2: Clone the Main Application
```bash
# Create installation directory
mkdir -p ~/odoosense
cd ~/odoosense
# Clone the main OdooSense V2 repository
git clone https://github.com/Shamlan321/OdooSense_V2.git
cd OdooSense_V2
# Create virtual environment
python3 -m venv venv
source venv/bin/activate
# Install Python dependencies
pip install -r requirements.txt
# Install Node.js dependencies for frontend
cd agent_frontend
npm install
cd ..# Copy environment template
cp .env.example .env
# Edit the environment file with your settings
nano .envConfigure the following variables in your .env file:
# API Keys
GEMINI_API_KEY=your_google_gemini_api_key
APIFY_API_KEY=your_apify_api_key_for_linkedin_lead_creation(optional)
# Application Settings
FLASK_ENV=production
SECRET_KEY=your_secret_key# Navigate back to installation directory
cd ~/odoosense
# Clone the documentation agent repository
git clone https://github.com/Shamlan321/odoo-exper-gemini.git
cd odoo-exper-gemini
# Copy environment template
cp .env.example .env
# Edit the environment file
nano .envConfigure the documentation agent environment:
GOOGLE_API_KEY=your_google_api_key
POSTGRES_USER=odoo_expert
POSTGRES_PASSWORD=your_secure_password
POSTGRES_DB=odoo_expert_db
POSTGRES_HOST=db
POSTGRES_PORT=5432
LLM_MODEL=gemini-1.5-flash-latest
BEARER_TOKEN=comma_separated_bearer_tokens
CORS_ORIGINS=http://localhost:3000,http://localhost:8501,https://www.odoo.com
ODOO_VERSIONS=18.0
SYSTEM_PROMPT=same as .env.example
RAW_DATA_DIR=raw_data
MARKDOWN_DATA_DIR=markdown# Start Docker services for documentation agent
docker compose up -d
# Pull Odoo documentation
docker compose run --rm odoo-expert ./pull_rawdata.sh
# Convert RST to Markdown
docker compose run --rm odoo-expert python main.py process-raw
# Process and embed documents
docker compose run --rm odoo-expert python main.py process-docs# Navigate to main application directory
cd ~/odoosense/OdooSense_V2
# Activate virtual environment
source venv/bin/activate
# Start the backend server
python flask_app.py &
# Start the frontend (in a new terminal)
cd agent_frontend
npm start-
Access the Application:
- Main Application: http://localhost:3000
- API Endpoint: http://localhost:8000
- Documentation Agent UI: http://localhost:8501
-
Verify Installation:
# Check if all services are running docker-compose ps # Test API connectivity curl http://localhost:8000/health
-
Configure Odoo Connection:
- Navigate to the settings page in the web interface
- Enter your Odoo instance details
- Test the connection
Screenshots will be added here to showcase the user interface and key features of OdooSense V2.
"How many sales orders do we have this month?"
"Show me all customers from California"
"List the top 5 products by revenue"
"Find all unpaid invoices over $1000"
"What's our monthly recurring revenue?"
"Show me employee headcount by department"
"Generate a PDF sales report for Q3 2024"
"Create an Excel sheet of all customers with their contact details"
"Export monthly sales data to CSV"
"Generate a quarterly revenue report"
"Create a customer analysis report"
"Create a bar chart showing sales by month"
"Generate a pie chart of revenue by product category"
"Show me a line graph of customer acquisition trends"
"Create a dashboard with sales metrics"
"Plot monthly expenses as a bar graph"
"Create a new lead for John Smith from ABC Corp"
"Update customer XYZ's phone number to 555-1234"
"Add a new product called 'Premium Widget' priced at $99"
"Create an expense record for my lunch meeting"
"Register a new employee in the HR system"
"How do I access the sales module?"
"Take me to the customer management page"
"Show me how to create a purchase order"
"Where can I find the inventory reports?"
"Help me navigate to the accounting dashboard"
"How do I set up automated email campaigns in Odoo?"
"What's the process for configuring multi-company accounting?"
"How do I create custom fields in Odoo?"
"Show me how to set up inventory reordering rules"
"How do I configure payment terms for customers?"
"What are the steps to set up a new warehouse?"
"How do I create custom reports in Odoo?"
"Show me how to configure automated invoicing"
Upload a document, select from the menu what type of records you want to create, and the Agent will return extracted data from the document. Press Add to Odoo.
"Analyze our sales performance compared to last year"
"Show me customer retention rates by region"
"What are our best-selling products this quarter?"
"Generate insights on our revenue trends"
"Compare monthly sales across different product lines"
We welcome contributions to OdooSense V2! Please read our contributing guidelines and submit pull requests to help improve the project.
This project is licensed under the MIT License. See the LICENSE file for details.
For support and questions:
- Create an issue on GitHub
- Check the documentation
- Built with LangChain and LangGraph
- Powered by Google Gemini AI
- Inspired by the Odoo community's needs for better ERP interaction