Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to connect Zapier to an Odoo.sh database?

leads zapier quickstart Odoo.sh

2 Odpowiedzi

10511 Widoki

Valentin Gailly (vag)

[CONTEXT] Zapier is a freemium service that is able to "Connect your apps and automate workflows". A zap is already created in Zapier that enables you to create new leads coming from an infinite types of sources (e.g. ninjaform / facebook / google spreadsheet / etc.)

Connecting Zapier with an OdooSaas database is easy. Just follow the steps Zapier is giving you.

However - connecting Zapier with an Odoo.sh database is complexier.

It often gives you this error "Fault (code AccessDenied) occurred. Message: Access Denied"

Please check below answer to get this solved.

JumpWish sarl

Hi Valentin,

Just trying your tips to connect zapier and to my odoo sh database but still not working.

Does we need to use API key instead of my traditional password ?

With both passeword and allias database name still “AccessDenied“ return.

Thank you for your return.

Gauthier

Valentin Gailly (vag)

Autor Najlepsza odpowiedź

We need here to add a specific custom allias domain to enable Zapier understand the actual name of the database.

More concretely - follow these steps :

1/ Odoo.sh -> Select the production branch -> go in the shell
2/ Copy the name of the database "mydatabase-main-XXXXXXX"
3/ Go in the "setting" tab. Create a new domain allias by pasting this database name e.g. " mydatabase-main-XXXXXXX.odoo.com"
4/ In the zapier settings (for connection) - please use this new database domain to get connected.

Emilio San Jose

Hi Valentin, thanks for the explanation. Is this still working for you?

Valentin Gailly (vag)

Autor

Hello Emilio,

Yes it is still working on my database. What kind of error do you have?

Regards

Hayden

Great suggestion, however, the issue still persists for me. Has anyone figured this out? I have already set list_db to true and used the alternative URL

Valentin Gailly (vag)

Autor

Hello Hayden, what is the error message you get?

Nery Caballero

Thanks Valentin, this worked for me.

Fabricio Salazar

Hello Emilio!
I tried to do it but I cant find the domain alias https://prnt.sc/qFINZSPCZb56
I added the damain as you can see at the image and triedt to access to zappier but didnt got success

Allec Baldwin

This worked for me. Thank you so much for the answer!

Rahul Rathod | Rootlevel

How to Connect Odoo.sh (or Self-Hosted Odoo) to Zapier

Odoo.sh works like a self-hosted Odoo environment managed by Odoo SA. That means in Zapier, you’ll connect it using the “Odoo ERP Self Hosted” app.

Select Odoo ERP Self Hosted as the Action App

In the Action step, search for and select “Odoo ERP Self Hosted”.
This is the app Zapier uses to connect with Odoo.sh or self-hosted Odoo.

Connect Your Odoo.sh or Self-Hosted Odoo Account

Zapier will ask for:

Odoo URL – Your full Odoo.sh or server URL (e.g., https://yourcompany.odoo.com or https://yourdomain.com).
Odoo Username – Usually your Odoo login email.
Odoo Password or API Key – For better security, generate an API Key in Odoo (My Profile → API Keys → Create).
Database Name – The name of your Odoo database (you can find it in your Odoo URL after /web?db=).

Set Up the Action

Choose what Odoo should do when the Zap runs:
Examples: Create a record, update a record, create a lead, etc.

Test Your Zap

Zapier will run a quick test to check the connection and make sure data flows

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Create Leads in Odoo CRM by Connecting to Zapier zapier quickstart Quickstart	0 sty 25	5959
Odoo.sh Basics terms explained Rozwiązane technical functional quickstart Odoo.sh	1 cze 22	5142
Set a color change in a lead/opportunity based on a time condition - v15 crm leads colors quickstart v15	0 kwi 22	4034
Why is there a discrepancy between the Odoo.sh container filesystem size and the total File Size listed in the Database Attachments Menu? Rozwiązane attachment filestore size quickstart mismatch Odoo.sh	1 gru 25	280
How to Add a User to Access the Database on Odoo.sh? Rozwiązane Odoo.sh	1 lis 25	4335

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!