How to set ODOO new sales order -> Google sheet update row

[lelehelloworld]

I want to fetch new Sales Order to Google Sheet.
How can I do the setup? Pls advise.

 

[Preeti Paryani]

Hello @lelehelloworld,

Follow the steps below to set up a webhook in Odoo for new Sales Order details:

1. Login to Odoo and switch to "Odoo Studio" mode.
2. Go to the "Automations" tab, create a new automation, and assign it a meaningful name (e.g., "Sales Order Webhook").
3. Choose the trigger as "Sales Order Created" or "Sales Order Updated" depending on when you want to capture the data.
4. Under the trigger field, select the relevant field that will activate the automation (e.g., when a sales order is confirmed or updated).
5. Click on "Add Action", and select the "Send Webhook Notification" action.
6. Copy the provided webhook URL and paste it into the URL section in your Odoo automation settings.
7. In the Fields section, choose the data fields you want to receive (e.g., Sales Order ID, Customer Name, Order Details, Total Revenue, etc.).
8. Save the automation once you have configured the fields.
9. Click on the "Capture Webhook Response" button to initiate a test. Trigger the action by creating or updating a sales order in Odoo so that the webhook response can be captured here.

Once the webhook response is captured, you can use the details for further actions in your workflow.

You can also refer to this tutorial to set up the trigger -

.