Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 831 |
Technical Name |
ol_sheets_connector |
License | LGPL-3 |
Website | https://www.odolution.com/ |
Versions | 16.0 17.0 18.0 |
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 831 |
Technical Name |
ol_sheets_connector |
License | LGPL-3 |
Website | https://www.odolution.com/ |
Versions | 16.0 17.0 18.0 |

Why Sheets Connector?
The Sheets Connector seamlessly integrates your Odoo data with Google Sheets, enabling dynamic and automated synchronization. With flexible data syncing, multi-sheet support, and the ability to customize exports, you can easily manage, filter, and update your data in real-time. Whether you're creating new worksheets, syncing model data, or scheduling automatic updates, our connector ensures a smooth, efficient workflow directly between Odoo and Google Sheets.
Need Help?
Connect with us on email

Chat with us on WhatsApp

Key Attributesof Sheets Connector

Seamless data fetching using Query and direct Model

Flexible Data Syncing

Multi-Sheet Support

Selective Data Export

Scheduled Synchronization

Access Google Sheets Directly from Odoo
Seamless Google Sheets Integration
Sync data seamlessly between Odoo and Google Sheets. With this feature, you can easily synchronize any data between your Odoo instance and Google Sheets, making it simple to manage and share data in real-time. No need for manual updates just a few clicks, and your data is synced automatically.

Customizable Data Syncing
Easily update data using model selection or custom queries, ensuring that only the relevant data is transferred. Whether you want to sync customer details, sales orders, or inventory, this feature provides flexibility to control exactly what gets updated between Odoo and Google Sheets. Tailor your sync processes to fit your business needs.

Multi-Sheet Support
Work with multiple sheets in a single Google Sheets document. This feature allows you to manage various types of data on separate sheets, providing a more organized and efficient way to handle large datasets. You can update and manage different types of records, all within the same document, for better structure.

Selective Data Export
Export specific fields and records with ease. Whether you need to export customer details, order data, or inventory levels, you can select exactly what to export, avoiding unnecessary data clutter. This ensures that only the most relevant information is shared, improving data accuracy and reducing errors.

Scheduled Synchronization
Automate your data syncing process at regular intervals. Set your preferred sync schedules whether it's daily, weekly, or hourly and the system will handle the rest. This automated process ensures your data is always up-to-date, without the need for manual intervention.

Access Google Sheets Directly from Odoo
Open and edit your Google Sheets directly from the Odoo interface. This seamless integration means you can view and manage your Google Sheets without switching between platforms. Make real-time changes to your sheets while staying within Odoo, improving your workflow efficiency and saving time.

Install the required Python libraries
Navigate to https://console.cloud.google.com/

Click "Select a Project"

Click New Project

Type Project Name and click "Create"

Click "Select Project"

Search for Google Sheets API in the search bar.

Enable Google Sheets API

Go to Menu > IAM and admin > Service accounts

Click "Create service account"

Type Service Account name and Click "Done"

If your service account key is not listed refresh the page.

Open Service Account and click on "Add Key"

Click "Create new key"

Select "JSON" key type and click create. Your service account key will be downloaded.

Open Odoo database and Navigate to Settings > Technical > Google Sheets Service Account Key.

Click on Service Account Key kanban

Upload the downloaded Service account key JSON file.

Click "Validate Key"

Copy client_email from your Service Account Key. Open your Google sheet and Share with your client_email.

Click "Send"

Copy your Google sheet link.

Open your database and navigate to "Sheets"

Click on Configuration

Select "Worksheet Configuration"

Click "New"

Enter a Configuration Name and paste the Google Sheet Link.

Click Test Connection

You will see connected in status if the worksheet connects successfully.

Navigate to Data Menu

Create a New record. Fill in all required fields, select the configured Google Sheet, Input the Worksheet Name.

Click "Execute" to view records.

Click "Sync Data".

Click "Open Google Sheet"

Data has been synced successfully with Google Sheets

Check "Enable Scheduler" to automate the synchronization.

Need Help? We have Got You Covered!
User Guide
Contact Us
Support Ticket
To get assistance, please visit www.odolution.com to create a support ticket. Simply register on our platform and provide the details of the issue, and our team will work to resolve it promptly.
Please log in to comment on this module