Odoo CRM connection guide

  • Updated on Dec 1, 2025
  • Published on Dec 1, 2025
Prev Next

This guide contains all permissions and requirements for connecting your Odoo CRM data to Supermetrics.

You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in all available destinations.

Required permissions

You will need an API key and your database name in order to connect to Odoo CRM.

How to create an API key

  1. Log in to your Odoo account.

  2. Select your database and the CRM module.

  3. In the top-right corner, click on your user profile picture and select Preferences.

  4. Select the Security tab.

  5. In the API Keys section, click Add API key.

  6. Enter your password to confirm your identity.

  7. Give a name to your key (for example, “Supermetrics”) and define how long the key will be valid. If the key expires, you will need to create a new one.

  8. Click on Generate key.

  9. The API key will now be shown once; copy it to a secure location for later use.

Full instructions to create an API key are available in Odoo’s documentation.

How to find your database name

  1. Log in to your Odoo account.

  2. The database name is visible on the left side.

Query types

If prompted, you need to select a query type to pull data.

  • Leads: Retrieve detailed insights about your Odoo leads data.

Connection instructions

  1. Select the Odoo CRM data source on the Supermetrics Hub or in the data destination.

  2. Enter the API key and database name.

  3. If prompted, choose to make this connection shared or private.

  4. Click Start.

  5. In your data destination, select the ad accounts to include in your reporting and a query type, if prompted.

You can also connect to Odoo CRM from these destinations:

More resources