AI-Powered Inquiry System for Cin7 ERP Data

This workflow creates an intelligent AI chatbot that answers questions about internal business data stored in the Cin7 ERP system. Leveraging advanced language models, custom SQL queries, and a dedicated data warehouse, it provides instant insights by converting natural language questions into SQL queries, executing them on the Peliqan platform, and delivering accurate responses. The setup involves a webhook trigger for incoming chat messages, an AI agent with a system message tailored to Cin7 data, and an OpenAI language model for natural language understanding. The core logic allows users to ask complex questions related to inventory, sales, orders, contacts, and more, which are translated into SQL commands executed on the data warehouse. This workflow is ideal for businesses seeking real-time data insights through a conversational interface, improving decision-making and operational efficiency.