Odoo to Google Sheets Connector | Two-Way Data Sync & Automated Reporting
by Creyox Technologies https://www.creyox.com$ 345.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 1038 |
| Technical Name |
cr_odoo_to_sheets_connector |
| License | OPL-1 |
| Website | https://www.creyox.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
Odoo To Google Sheets Connector
Overview
The Odoo to Google Sheets Connector is a powerful bidirectional integration tool that seamlessly bridges your Odoo ERP system with Google Sheets. This connector eliminates manual data entry and enables real-time synchronization between both platforms, allowing users to work with familiar spreadsheet tools while maintaining data integrity in Odoo.This connector provides a flexible and efficient solution for data management and collaboration.
Flexible scheduling options allow you to set up automatic import and export refresh intervals on a per-table basis, ranging from hourly to custom time periods. For immediate needs, the "Refresh Now" feature enables on-demand synchronization of selected sheets. The connector also provides column-wise fallback mechanisms during data import, ensuring maximum data integrity by attempting to update fields individually if bulk operations encounter issues.
Comprehensive logging and monitoring capabilities track every synchronization operation, recording success counts, partial updates, and failures with detailed error messages. Each log entry includes timestamps, duration metrics, record counts, operation types (Import/Export), and status indicators, providing complete visibility into data transfer activities. This robust audit trail enables quick troubleshooting and ensures accountability for all data synchronization processes.
Hot Features
Features
Odoo To Google Sheets Connector
- Go to the Google Sheet Connector from the main Odoo dashboard.
- Navigate to Configuration from the main menu.
- Click New to create a new connector configuration.
- Click the Generate Token button to create an authentication token.
- Once generated, the authentication token will be displayed in the Access Token field.
- Copy this token and paste it into Google Sheets to establish a secure connection between Odoo and Google Sheets.
- Click on button Generate App Script to generate App Script to connect with Google Sheet.
- Generated App Script is Attached in chatter.
- Copy the Generated App script content.
- Open your Google Sheet and navigate to Extensions >> Apps Script to access the script editor.
- Navigate to Code.gs and paste the previously copied Apps Script code into the editor.
- This script will add the Odoo data import and export menu to your Google Sheet, allowing you to connect and synchronize data with Odoo.
- Now Odoo Connector menu will be visible In Google Sheets, navigate to Odoo Connector >> Set URL and Token.
- Enter the Odoo URL (Connector Url) and the authorization token (Access Token) generated from Configuration menu in Odoo.
- From your Google Sheet, go to Select Tables and Fetch Data to retrieve data from Odoo.
- Choose the required table to fetch data from Odoo and click Next: Select Columns.
- The data for each selected table will be imported into a separate sheet within the Google Sheet.
- Select the specific fields from which you want to fetch data, then click the Fetch Data button.
- This allows only the selected columns to be imported, ensuring that only relevant and important data is fetched into the Google Sheet.
- Once the process is complete, the imported data will appear in the Google Sheet.
- To export data from Google Sheets to Odoo, Navigate to Google Sheet >> Send data to odoo.
- Select the sheet containing the data you want to export to Odoo, then click Next: Select Columns.
- Select The Specific Fields of which you want to export the data >> click on button Export Data
- If a record already exists in Odoo with the same ID, the system will update the existing record with the new values.
- If no record exists in Odoo with the same ID, a new record will be created automatically.
- Even if the ID field is not selected during column selection, the system will still use the ID internally to identify records.
- The Exported Data Can Be found in Odoo.
- Navigate to Google Sheet >> Setup Automatic Import Refresh.
- Select Tables and Enter the Hours for each table in which You want to Automatically fetch data from Odoo to Sheets.
- The sheet data will be refreshed automatically based on the selected time interval.
- Navigate to Google Sheet >> Setup Automatic Export Refresh.
- Select Tables and Enter the Hours for each table in which You want to Automatically export data from Sheets to Odoo.
- The sheet data will be exported automatically based on the selected time interval.
- Navigate to Google Sheet >> Refresh Now.
- Select specific tables and click on Refresh Selected to fetch records of selected tables from odoo to sheets.
- In Odoo Navigate to Odoo To Sheets >> Data Processing Logs .
- This section displays transaction logs for data synchronization between Odoo and Google Sheets.
- It shows how many records were successfully imported or exported, how many failed, along with analytical reasons for any failures.
Our Services
- Yes. You can choose exactly which columns you want to import from or export to Google Sheets. This helps keep your data clean and relevant.
- Every import and export action is logged. You can review logs and history anytime to confirm what data was synced or to troubleshoot issues.
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & On-Premise) as well as Community.
- No, this app will not work for Odoo Online.
- Please contact us on support@creyox.com
- Yes, we give free support when you buy these app for 60 Days.
- Yes, you need to pay different prices of app version wise.
- You can raise a Ticket on support@creyox.com we'll get back to you with fixes.
Our Services
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