Skip to Content

Is your business losing valuable hours on repetitive tasks? Connect Odoo with N8N and automate your processes

Discover how to integrate your business systems and free your team from manual work that consumes time and resources
September 10, 2025 by
Is your business losing valuable hours on repetitive tasks? Connect Odoo with N8N and automate your processes
Wilfredo Fernando Pastor Avila
| No comments yet

To connect Odoo with n8n you need four details: your Odoo URL, the user, an API key and the database name. With them you create the Odoo credential in n8n and your workflows can read and create records. Note that Odoo's external API is only available on Custom plans.

The frustration of repetitive manual tasks

Imagine María, a sales manager at a mid-sized company. Every day, her team spends hours copying data from web forms into Odoo, sending follow-up emails manually and updating spreadsheets. Human errors are frequent, opportunities are lost along the way, and the team is exhausted from so much repetitive work. María knows there is a solution, but she does not know where to start.

The solution: automation with N8N and Odoo

The integration between Odoo and N8N lets you create automated workflows that eliminate manual work. N8N acts as the brain that connects different systems, while Odoo centralizes all business information.

Step 1: Setting up credentials in N8N

The first step to connect Odoo with N8N is creating the connection credentials. This can be done from N8N's main menu or directly when adding an Odoo node to your workflow.

The four essential details for the connection

To connect Odoo with N8N you need four key details: access URL, username, API key and database name. Each one serves a specific function in authentication.

Configuring user permissions

It is crucial to understand that N8N inherits the permissions of the Odoo user you use for the connection. If the user cannot create opportunities, N8N cannot either, regardless of how the workflow is set up.

Generating and managing API keys

API keys are application passwords that enable secure connections. They are generated in Odoo from Preferences → Security → API Keys, and it is essential to save them immediately because they cannot be recovered later.

Finding the database name

The database name is found by activating developer mode in Odoo. It appears in the top bar next to the username and must be copied exactly, including all characters.

Testing and using the connection

Once all the details are configured, N8N tests the connection automatically. If it succeeds, you can start using the Odoo nodes in your automation workflows.

Conclusion: The power of integrated automation

Ready to start your automation journey? At Ganemo we provide not only the platform but also the expertise for successful implementations that truly impact your business productivity.

Related video

Odoo 19, the JSON-2 API and the end of XML-RPC

Odoo 19 adds the JSON-2 external API: each call is a POST to /json/2/<model>/<method> with the Authorization: bearer header and your API key. The old /xmlrpc, /xmlrpc/2 and /jsonrpc endpoints are scheduled for removal in Odoo 22 (fall 2028) and Odoo Online 21.1 (winter 2027).

If your n8n workflows rely on those endpoints, plan their move to HTTP calls with JSON-2 before those dates. And treat the API key like a password: create it for a dedicated user with just the permissions it needs and keep it in a secrets manager (at Ganemo we use Secrevo), never pasted into a workflow or a document.

Source: official Odoo 19 documentation (External JSON-2 API), checked on 2026-11-21.

Odoo and n8n FAQ

Create an Odoo credential in n8n with the URL, user, API key and database name. Then use that credential in your workflow nodes.

One with external API access. According to the Odoo 19 documentation, that access is only available on Custom plans, not on Standard or One App Free.

In your Preferences ‣ Account Security ‣ New API Key. Copy it when you create it: it cannot be shown again later.

Those of the user who owns the API key. If that user cannot create invoices, the workflow cannot either. That is why a dedicated user per integration is a good idea.

Keep reading

Want to review your case with us? Book a diagnostic session or message us on WhatsApp at +1 (828) 672 6150.

Is your business losing valuable hours on repetitive tasks? Connect Odoo with N8N and automate your processes
Wilfredo Fernando Pastor Avila September 10, 2025
Share this post
Tags
Archive
Sign in to leave a comment
How to Delete Fields in Odoo Studio Without Compromising Your Database: The Definitive Guide
Discover the correct process for deleting custom fields in Odoo Studio and avoid common mistakes that can affect your business information