Embedded Files
Query, Post and Sync Data from Odoo Inventory
What is Sheet Director?
What is Sheet Director?
Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc.Â
It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.Â
What is Odoo Inventory?
What is Odoo Inventory?
In Odoo, inventory is a comprehensive warehouse management system for tracking and managing stock levels, movements, and storage. It serves as a central hub for all inventory-related operations, including receiving, shipping, internal transfers, and manufacturing, and integrates with other Odoo modules like Sales, Purchase, and Accounting for a complete business overview.
Odoo Inventory and Google Sheets: Use Cases
Odoo Inventory and Google Sheets: Use Cases
> Query: Pull data from Odoo Inventory and present on Google Sheets
> Query: Pull data from Odoo Inventory and present on Google Sheets
Table Of Contents
Table Of Contents
Setting up Odoo Inventory with Sheet Director
Setting up Odoo Inventory with Sheet Director
Choose the Odoo Inventory (Premium app) from the list and choose the service that you want to perform
If you're opening it for the first time on the sheet, then you won't be having any connections.
Don't worry Sheet director provides a way to create a connection easily
To create the connection you have to provide the following details.
Connection name - Provide a nice name for the connection you're creating
Provide the configuration details which are mandatory
How to get credentials?
How to get credentials?
Domain :Â
Domain :Â
In your Odoo Inventory application, copy the browser URL up to odoo.com/ and use it as the domain URL
(Ex: https://yourApp.odoo.com/Â )
Database :Â
Database :Â
Use your odoo Inventory database name.
Username and Password :Â
Username and Password :Â
Use the username and password you provided to the Odoo app during sign-up.Â
Test Connection
Test Connection
Once you have provided the credentials you can easily check the connectivity by clicking on the test connection button
Based on the credentials authenticity, you will be having the feedbacks from the test
Once after connecting successfully, you can save the connection and continue.
These connections can be reused anytime and from any services used on the same Google Sheets
Querying on Odoo Inventory
Querying on Odoo Inventory
Once after saving the connection successfully, you can select the table and fields that you want to present on the Google Sheets
You also have a refresh button to get the updated tables list from the database
Max Result
Max Result
You can limit how much no of records you want to fetch using a query
Destination Settings:
Destination Settings:
Configure the destination settings to save the records.
Scheduler Settings:
Scheduler Settings:
Switch on Run automatically to execute services automatically in the background.
Notification Settings:
Notification Settings:
Configure the Notification settings to set up the email templates and add attachments.
Click on execute to query the records in the Google Sheets.
Click save to save the service.
Sample Output
Sample Output
Without Filters and Sort
Without Filters and Sort
Report abuse