We are currently using Odoo 18, which comes with a built-in PostgreSQL database. We access this database through pgAdmin 4 on Windows 11.

Our goal is to automate responses in the Live Chat module, which is integrated into our Odoo-based website. What we want to achieve is for our AI LLM (Large Language Model) to automatically respond to visitors depending on their questions with no human involved.

We believe this is feasible, and one possible approach we’ve identified is to connect our PostgreSQL database to an n8n workflow, allowing n8n to handle the automation process. We have already established this connection successfully and can retrieve data from the PostgreSQL database.

However, we anticipate challenges when it comes to inserting data back into the database, due to the complexities involved in managing SQL records within Odoo’s data structure.

If anyone is working on a similar problem, please do let me know! Any help will be appreciated.