AI Chatbot Queries Cin7 ERP Data via Peliqan Text-to-SQL

This n8n workflow powers an in-house AI chatbot that retrieves and interprets business data from Cin7 ERP (Omni or Core) in response to natural language questions. Users can inquire about products, stock levels, accounting, or any Cin7 data. Peliqan.io acts as a high-speed cache by syncing Cin7 data via one-click ELT to its built-in warehouse, enabling efficient querying without direct ERP load.

The core mechanism uses an AI Agent node with OpenAI, augmented by a Peliqan tool for Text-to-SQL. The user's query is converted to SQL, executed on Peliqan-synced Cin7 data, and results are naturally interpreted back to the user. This setup ensures accuracy, speed, and scalability for business intelligence tasks.

Benefits include time savings on manual reporting, democratized data access for non-technical teams, and reduced ERP API strain. Ideal use cases: procurement teams checking stock, sales querying product info, finance reviewing accounts—all via chat. Prerequisites: Peliqan trial and Cin7 API key; setup involves connecting sources and credentials in n8n.

Optional enhancements: Run Peliqan's template script to customize the AI's system prompt with your exact Cin7 datamodel for optimal precision.