---
title: "Odoo CRM connection guide"
slug: "odoo-crm-connection-guide"
description: "Connect your Odoo CRM data to Supermetrics with our guide. Learn about API keys, permissions, and integration steps for seamless data access."
updated: 2025-12-01T10:34:43Z
published: 2025-12-01T10:34:43Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Odoo CRM connection guide

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

<meta charset="utf-8">

You can connect to data sources from the [Data sources page on the Supermetrics Hub](https://hub.supermetrics.com/token-management). On the Hub, you can also [share an authentication link](https://docs.supermetrics.com/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub#share-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](/docs/odoo-crm-connection-guide#connection-instructions).

## 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](https://www.odoo.com/my/databases).
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](https://www.odoo.com/documentation/master/developer/reference/external_rpc_api.html#api-keys).

### How to find your database name

1. Log in to your [Odoo account](https://www.odoo.com/my/databases).
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](https://hub.supermetrics.com/token-management) or in the data destination.
2. Enter the API key and database name.
3. If prompted, choose to make this connection [shared or private](https://docs.supermetrics.com/docs/about-shared-and-private-connections).
4. Click **Start**.
5. In your data destination, select the ad accounts to include in your reporting and a query type, if prompted.

See detailed instructions on [how to connect to a data source from the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-connect-to-data-sources-from-supermetrics-hub).

You can also connect to Odoo CRM from these destinations:

- Google Sheets: [How to connect to a Supermetrics data source in Google Sheets](https://docs.supermetrics.com/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets)
- Data Studio: [How to connect data sources to Data Studio](/v1/docs/how-to-connect-data-sources-to-data-studio)
- Excel: [How to connect data sources to Excel with Supermetrics](https://docs.supermetrics.com/docs/how-to-connect-data-sources-to-excel-with-supermetrics)
- Power BI: [How to create your first Supermetrics query for Power BI](https://docs.supermetrics.com/docs/how-to-create-your-first-supermetrics-query-for-power-bi)
- The Supermetrics API: [How to use the Query Manager](https://docs.supermetrics.com/docs/how-to-use-the-query-manager)
- Data warehouse and cloud storage (Hub): [How to create a transfer](https://docs.supermetrics.com/docs/how-to-create-a-transfer)
- BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](https://docs.supermetrics.com/v1/docs/how-to-create-a-bigquery-marketplace-transfer)

## More resources

- [How to reauthenticate a data source in Google Sheets, Data Studio, Excel, or Power BI](https://docs.supermetrics.com/docs/how-to-reauthenticate-a-data-source-connection-in-google-sheets-looker-studio-excel-power-bi-and-supermetrics-hub)
- [How to reauthenticate a data source in data warehouse, API, or cloud storage platform](https://docs.supermetrics.com/docs/how-to-reauthenticate-a-data-source-connection-in-data-warehouse-destinations-or-the-supermetrics-api)
- [How to manage data source connections on the Supermetrics Hub](https://docs.supermetrics.com/docs/how-to-manage-data-source-connections-on-supermetrics-hub)