Why connect Gemini to Odoo?
Odoo is where your operational truth lives — sales orders, invoices, CRM pipeline, inventory, purchasing. Getting answers out of it usually means custom reports, SQL, or exporting spreadsheets. When you connect Google Gemini to Odoo, you can ask for those answers in plain language instead: "Which customers grew fastest this quarter?", "Show me invoices overdue by more than 30 days", "Draft a quotation for Acme Corp based on their last order."
The important detail is how Gemini reaches Odoo. Gemini supports function calling and the Model Context Protocol (MCP) — the same open standard used by Claude, Cursor, and n8n. MCP lets Gemini call governed tools that read and write live ERP records. That is very different from a "Gemini content-generation" connector module, which only pushes AI-written text into Odoo and never gives Gemini sight of your actual data.
There is exactly one fork in the road, and it is decided by your hosting. Everything below splits into two clean paths.
Two paths, decided by your hosting
Pick the row that matches where your Odoo runs. The Gemini side is identical either way — it is the Odoo side that differs.
Self-hosted, Odoo.sh or on-premise
Install the MCP Server for Odoo, a native Odoo App Store module. It adds a first-class MCP endpoint inside Odoo with OAuth, scoped API keys, and built-in BI tools — so Gemini talks to Odoo directly, with full permission enforcement and audit logging.
Odoo Online (*.odoo.com SaaS)
You cannot install modules on Odoo Online, so use the Odoo Online MCP Gateway — a pioneering, purpose-built external gateway that connects Gemini to your SaaS instance over XML-RPC. Nothing installs inside Odoo; the gateway sits outside and speaks the standard Odoo API.
Path A — self-hosted setup with the MCP Server
If you control your Odoo instance, these five steps take you from install to a working Gemini + Odoo integration.
Get the MCP Server module from the Odoo App Store
Purchase the KSROlabs MCP Server for Odoo from the Odoo App Store and install it in your self-hosted, Odoo.sh, or on-premise instance via Apps → Upload Module. It behaves like any standard Odoo module — no external services required.
Enable the MCP endpoint and create a scoped API key
Go to Settings → Technical → MCP Server, enable the endpoint, then create an API key named "Gemini". Choose exactly which Odoo models the key may reach — for example sale.order, res.partner, and account.move. Copy the bearer token; it is shown only once.
Expose the Odoo tools to Gemini as function calls / MCP tools
Gemini reaches external systems through function calling and MCP tool definitions. Point your Gemini agent — via the Gemini API, an MCP-capable client, or a framework like the Google Gen AI SDK — at your Odoo MCP endpoint (e.g. https://your-odoo.com/mcp/v1) with the Authorization header set to "Bearer <your-token>".
Confirm Gemini discovers the Odoo tools
Start a session and ask a schema question such as "Describe the sale.order model in Odoo." Gemini should invoke the describe_model tool and return real field metadata from your instance. If you see live data, the connection is working.
Query and act on live Odoo data in natural language
Ask Gemini business questions — "List overdue invoices above £10,000" or "Draft a quotation for Acme Corp based on last month's order." Gemini calls the appropriate MCP tools against your live Odoo instance, governed by the key's scope.
Path B — Odoo Online with the MCP Gateway
On Odoo Online you skip the module entirely. The Odoo Online MCP Gateway is a purpose-built external service — the first of its kind for SaaS Odoo — that authenticates to your *.odoo.com database over XML-RPC and re-exposes it as MCP tools that Gemini can call. You configure the models and permissions the gateway is allowed to use, then point your Gemini agent at the gateway endpoint exactly as you would any other MCP server.
Because there is nothing to install and nothing to maintain inside Odoo, this is the fastest route for SaaS customers. Setup is handled with you directly — get in touch and we will provision the gateway for your instance and share pricing.
What Gemini can do once connected
With either path in place, Gemini can query and act on your live ERP through natural language. A few examples:
Answer business questions
Ask "What is my top-selling product line this month?" and Gemini searches live Odoo records to answer — no report builder required.
Chase receivables
"List every invoice overdue by more than 30 days, grouped by customer." Gemini queries account.move and hands you an actionable list.
Draft and create records
Where the key allows writes, Gemini can draft quotations, log CRM activities, or update fields — validated against Odoo's own rules.
Explore the schema
Ask Gemini to describe any model and it returns real field names and relations from your instance, not stale documentation.
A note on security
Giving any AI model access to your ERP demands proper access control. Both paths are built around that:
Every request runs under a scoped API key tied to a specific Odoo user — Gemini inherits only that user's permissions.
Restrict each key to named models, and enable field allowlists on sensitive data like HR, payroll, and accounting.
Every action Gemini takes is logged in Odoo's audit trail with timestamp and payload — essential for compliance and debugging.
Use per-key rate limits, IP restrictions, and regular key rotation to keep the integration tightly governed in production.
Frequently asked questions
Can I connect Gemini to Odoo?
Yes. Google Gemini supports function calling and the Model Context Protocol (MCP), which is how it reaches external systems. By exposing your Odoo instance as MCP tools — through the KSROlabs MCP Server module (self-hosted) or the Odoo Online MCP Gateway (SaaS) — Gemini can query and act on live Odoo data using natural language.
Does it work with Odoo Online (SaaS)?
Yes, but the path is different. Odoo Online (*.odoo.com) does not allow custom module installation, so the MCP Server module cannot run there. For Odoo Online, KSROlabs provides the Odoo Online MCP Gateway — a purpose-built external gateway that connects Gemini to your SaaS instance over XML-RPC, with no module to install. Contact us to get set up.
Do I need a module?
It depends on your hosting. On self-hosted, Odoo.sh, or on-premise instances you install the MCP Server module from the Odoo App Store. On Odoo Online you do not install anything inside Odoo — the Odoo Online MCP Gateway sits outside Odoo and talks to it over the standard XML-RPC API. This is also the key distinction from generic "Gemini content-generation" connector modules, which only push AI-written text into Odoo and cannot let Gemini read your live records.
Is it secure?
Yes. Both paths enforce Odoo's built-in access controls. Each API key is scoped to specific models, so Gemini can only see and touch what you allow, and every action runs as a defined Odoo user with full audit logging. The MCP Server module adds field allowlists, per-key rate limits, IP restrictions, and zero-downtime key rotation.
How is this different from a Gemini content-generation connector?
Generic Gemini connector modules for Odoo generate text — product descriptions, email drafts, summaries — and write it back into records. They do not give Gemini live, structured access to your ERP data. The MCP approach described here is the reverse: it lets Gemini read, search, and act on real Odoo records through governed tools, which is what makes natural-language ERP querying possible.
How do I get it / pricing?
The MCP Server for Odoo is a one-time paid product on the Odoo App Store, and free setup support is included with every purchase as a service. The Odoo Online MCP Gateway is a paid, commercial service for *.odoo.com instances — get in touch through our contact page and we will scope your setup and share pricing.