How to Create Leads in Odoo from Make.com Without Coding?
Automating Opportunity Creation in Odoo: A Common Problem
Many sales teams working with Odoo want to automate their lead generation workflows. For example, receiving contact forms from a website, ad campaigns or even WhatsApp messages, and having all of that automatically turned into opportunities in the Odoo CRM. The problem is that, when looking for how to integrate external tools such as Make.com (formerly Integromat), people run into technical concepts like JSON-RPC, `uid`, authentication, and data structures that are hard to understand if you are not a programmer. A tourism services company in Peru faced that same challenge. Every time someone filled out a form on its website, a person had to copy the data and paste it manually into Odoo. This not only generated errors, but also slowed down customer service. Thanks to the integration you will see below, its leads now flow directly into Odoo in real time.What Do You Need to Integrate Make.com with Odoo?
Before you start, it is important to understand that you do not need to be technical or install additional modules. You only need three pieces of data:- The URL of your Odoo instance (for example,
https://miempresa.odoo.sh) - The exact name of your database
- The ID of the user who will use the API (with permission to create leads)
- An API Key generated from the preferences of that same user
Why Use an API Key Instead of a Username and Password?
Although Odoo allows you to connect using a username and password through an authentication call (usingcommon.login), that is not best practice. Passwords can change, and sharing them between systems is not secure.
An API Key, on the other hand:
- Is more secure
- Is easier to revoke without affecting the user
- Does not need to authenticate every time
- Simplifies the workflow in Make.com
How to Automate Lead Creation from Make.com
Follow these steps within your scenario in Make.com:- Add an HTTP > Make a request module
-
Configure the module with:
- Method: POST
- URL:
https://tuinstancia.odoo.sh/jsonrpc - Headers:
Content-Type: application/json - Body type: Raw (application/json)
-
In the body, paste this content and customize it:
{ "jsonrpc": "2.0", "method": "call", "params": { "service": "object", "method": "execute_kw", "args": [ "your_database_name", // your database 2, // your UID "your_api_key", // your API Key "crm.lead", // model "create", // method [{ "name": "New Lead from Make", "contact_name": "Carlos Rivera", "email_from": "carlos@ejemplo.com", "phone": "+51987654321", "description": "Requests a product demo", "type": "lead" }] ] }, "id": 1 }
How to Protect Your API Key in Make.com?
Although Make.com does not have an encrypted vault, you can protect your keys using these strategies:- Store the API Key in a Set Variable module so you do not have to repeat it
- Store the key in a Data Store and retrieve it when needed
- Avoid putting the key directly in URLs or in visible plain text