Sign inGet started
Sources

Odoo

View as MarkdownOpen in ChatGPTOpen in Claude
Connect your agent
Add to CursorAdd to VS Code

Read Odoo's sales orders and CRM leads, with the campaign Odoo recorded on each, so revenue meets the visits behind it.

Updated

What we read

  • Confirmed and cancelled sales orders, with their amount and campaign
  • Leads and opportunities: new, won and lost, with the campaign

How it connects

Open Sources > Odoo in your project, fill in Odoo address and Database (only if needed), paste your API key, and click Connect.

To find the key: in Odoo: click your avatar, My Preferences, Account Security, New API Key. Needs Odoo 19 or later and a plan with the external API.

We check the key with the vendor at once. It is kept encrypted for this project, never shown again, and deleted when you disconnect.

Requirements

  • Odoo 19 or later, on Odoo Online, Odoo.sh or your own server. Older versions don't have the API we use.
  • A plan that includes the external API.
  • The Sales app, the CRM app, or both, and a user who can read them. We recommend a user made only for nextanalytica.
  • The address of your Odoo (https://yourcompany.odoo.com). Name the database only if your server has several.

To make the key: click your avatar in Odoo, then My Preferences > Account Security > New API Key.

What does it sync, and how often?

We sync every hour and read the last 30 days again each time, since an order can still be cancelled and a lead won or lost.

WhatWhen it countsAs
A confirmed sales orderThe day it was confirmedRevenue, in its currency
A cancelled sales orderThe day it was confirmedNot revenue
A new lead or opportunityThe day it was createdA lead, with its expected revenue
A won opportunityThe day it closedRevenue, unless it already became sales orders
A lost opportunityThe day it closedA lost deal

Each comes with the Source and Campaign Odoo recorded on it. Odoo Website records them from the visit's UTM tags on its own. If another site sends leads to Odoo, send the visit's UTM tags with them.

Troubleshooting

"This Odoo doesn't have the JSON-2 API"

The server runs Odoo 18 or older, or the address points elsewhere. Check the address; the source needs Odoo 19 or later.

"This server has several databases: name the one to read."

Fill in Database with the database's name, as it shows on Odoo's sign-in page.

"Odoo didn't accept this key"

Make a new key under My Preferences > Account Security and paste it.

"This Odoo user can read neither Sales nor CRM"

Give the key's user access to Sales or CRM in Odoo, or connect with another user's key.

Related
  • Sources overview: How nextanalytica copies data from the tools you already use, keeps it 30 days, and puts it next to your visits.
  • Google Search Console: Read the Google searches that show your site, with clicks, impressions and position by page and query, next to your visits, in your own agent.
  • Google Analytics 4: Read Google Analytics 4's sessions and key events, by day, source and campaign, next to the tag's visits.
  • Bing Webmaster Tools: Read the Bing searches that show your site, with clicks, impressions and position, by query and page.
  • ChatGPT Ads: Read your ChatGPT Ads spend, impressions, clicks and conversions, by campaign and day. Read-only, never changes your ads.
Still have questions?
Was this page useful?