Skip to Content
Menu

Google Sheet Connector

by
Odoo

300.92

v 18.0 Third Party 1
Live Preview
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 831
Technical Name ol_sheets_connector
LicenseLGPL-3
Websitehttps://www.odolution.com/
Versions 16.0 17.0 18.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 831
Technical Name ol_sheets_connector
LicenseLGPL-3
Websitehttps://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

WATCH QUICK DEMO HERE

Key Attributesof Sheets Connector

Seamless Google Sheets Integration
Seamless data fetching using Query and direct Model
Flexible Data Syncing
Flexible Data Syncing
Multi-Sheet Support
Multi-Sheet Support
Selective Data Export
Selective Data Export
Scheduled Synchronization
Scheduled Synchronization
Access Google Sheets Directly from Odoo
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

Install the gspread and oauth2client python libraries in Odoo.

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
Check out our comprehensive User Guide for step-by-step instructions Here
Contact Us
Still have questions? Don't hesitate to reach out via email at app.support@odolution.com Or via whatsapp at +923356928563 . We are happy to help!
Support Ticket
For any issues you encounter while using our app, we offer free support for 90 days from the date of purchase, provided the issue is related to the app.
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.

FAQs

How does the Sheets Connector integrate with Google Sheets?
The Sheets Connector integrates seamlessly with Google Sheets by allowing you to connect your Google account and automatically sync data between your sheets and other applications. It does not require any complex setup, and once connected, the data flow is smooth and consistent across platforms.
Can I sync data from multiple Google Sheets at the same time?
Yes, the Sheets Connector supports multi-sheet integration, allowing you to synchronize data from several Google Sheets simultaneously. This feature is particularly useful if you're managing data across different sheets and want them all to stay up-to-date without manual intervention.
Can I schedule data syncs to happen automatically?
Absolutely! With the scheduled synchronization feature, you can set specific intervals (e.g., daily, weekly, or monthly) for your data to sync automatically. This ensures your data remains up-to-date without the need for constant manual updates.
Is it possible to selectively export data from Google Sheets using the connector?
Yes, you can export specific fields and records using domain filter on the model you are exporting data from.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.