$ 249.32
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 728 |
| Technical Name |
eb_odoo_google_sheets_connector |
| License | OPL-1 |
| Website | https://www.echobitzit.com |
| Versions | 15.0 16.0 17.0 18.0 19.0 |
Odoo Google Sheets Integration
The Odoo Google Sheet Integration app allows seamless two-way
synchronization between Odoo and Google
Sheets. You can easily transfer data from Odoo to Google Sheets for real-time reporting, analysis, or
collaboration, and push updates from Google Sheets back into Odoo without manual effort. With support
for selecting multiple Odoo models, you can manage different business data sets in one place while
ensuring accuracy and consistency across both platforms.
To make data management even more flexible, the app includes both auto-refresh and
manual refresh
options. You can schedule automatic data synchronization at specific intervals to keep your sheets
updated, or trigger an instant sync whenever needed. Whether for sales reports, inventory updates, or
CRM insights, this integration streamlines your workflow by reducing repetitive tasks and enabling
smarter decision-making with live Odoo data inside Google Sheets.
📦 Version 1.0.0 – Initial Release
- First stable release of Odoo Google Sheet Integration – Odoo 15, 16, 17, 18 Version.
Setup
Activate the 'Odoo Google Sheets Integration' module.
In the 'Sheet Connectors' menu, create a 'Google Connector' and then click the 'Generate Token' button.
Click the 'Generate App Script' button, and then download the 'App Script'.
Copy the 'App Script'.
In Google Sheets, click on 'Extensions' and then select 'Apps Script' from the submenu.
Copy the 'App Script' and paste it into 'Apps Script' in Google Sheets.
Go to Google Sheets and refresh the page so that the 'Odoo Integration (echobitz)' menu appears in Google Sheets.
Click on the 'Odoo Integration (echoBitz)' menu, and then click on the 'Set URL and Token' submenu.
Click on the 'OK' button.
Click on your Google account.
Click on the 'Advanced' option, and then click on 'Go to Untitled Project'.
Select the 'Select All' checkbox, and then click on the 'Continue' button.
Odoo configuration setup completed successfully.
Click on the 'Odoo Integration (echoBitz)' menu, and then click on 'Setup Auto Refresh (OTS)'.
Select the module name, set the scheduler time, and then click on 'Setup Auto Refresh'.
Create a company in Odoo.
Create a company in Odoo, then go to Google Sheets and click on the 'Fetch Data from Odoo' submenu.
Select the model, and then click on the 'Fetch Data' button.
The company record created in Odoo has been successfully synced to Google Sheets.
Add contact details in Google Sheets.
Add contact details in Google Sheets, and then click on the 'Send Data to Odoo' submenu.
Select the sheet name, then select the target model, and finally click on the 'Send Data' button.
Add contact data in Google Sheets, then sync it with Odoo. The contact will be created in Odoo with all the data from Google Sheets.
Demo & Support
We're here to help! Whether you need assistance with Odoo app installation, customization, or have any technical or functional questions, our support team is just a call or click away. Choose your preferred method to connect with us - phone, email, or schedule a meeting. You can also explore our detailed video playlist for step-by-step guidance.
Need Odoo Support?
FAQS
It enables seamless two-way synchronization of data between Odoo and Google Sheets for real-time reporting, analysis, and collaboration.
Yes, you can export data from Odoo to Google Sheets with just a few clicks.
Absolutely! Any updates made in Google Sheets can be synced back to Odoo automatically or on demand.
Yes, you can schedule auto-refresh at specific intervals to keep your data up to date.
Yes, you can trigger an instant sync at any time using the “Refresh Now” feature.
Yes, the app allows you to select and sync multiple models simultaneously.
Yes, all data transfers use secure authentication to keep your information safe.
Yes, it supports syncing large volumes of records across different Odoo modules.
No, the app is user-friendly and can be set up without any technical expertise.
You can set custom intervals based on your business needs.
Free Support for 365 Days
We believe that great apps deserve great support. That's why every purchase of our Odoo apps comes with 365 days of free expert support-no hidden fees, no hassle. Whether you need help with installation, customization, or troubleshooting, our team is here to guide you every step of the way. We're committed to ensuring your Odoo experience is smooth, efficient, and worry-free. With fast response times and professional assistance, you can focus on growing your business while we handle the tech. Start strong with support you can count on-for free, for the first 365 days.
Demo & Video
Schedule Meeting for Any Query
watch video playlist
Our Services
Odoo Integration
Seamlessly integrate Odoo with third-party apps, platforms, and tools for better workflow.
Odoo Implementation
We plan, configure, and deploy Odoo tailored to your business processes.
Customization
Get modules and workflows customized to meet your exact needs in Odoo.
Community Apps
Access or develop robust community apps to enhance your Odoo functionality.
Development Outsourcing
Hire dedicated Odoo developers to build solutions efficiently and cost-effectively.
Support & Maintenance
Enjoy peace of mind with our reliable support, updates, and bug fixing services.
A Powerful Integration App for Odoo and Google Sheet
Odoo Google Sheet Integration is an innovative integration app that bridges the gap between two industry-leading platforms, Odoo and Google Sheet. With its advanced features and intuitive design, it empowers businesses to automate facilitate real-time updates, streamline workflows, and eliminate the need for manual synchronization. By Odoo Google Sheet Integration integrating these two powerful systems, Odoo Google Sheet Integration offers unparalleled efficiency and productivity, allowing businesses to focus on what matters most—growing their customer base and driving revenue.
Installation
- Prerequisites
- Python 3.7 or later
- Odoo 15.0 or later
Credits
Contributors
- echoBitz IT Solutions Pvt. Ltd. <info@echobitzit.com>
Author & Maintainer
This module is maintained by the echoBitz IT Solutions Pvt. Ltd.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module