| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 2913 |
| Technical Name |
gsheet_connector |
| License | LGPL-3 |
| Website | https://www.webanixsolutions.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 2913 |
| Technical Name |
gsheet_connector |
| License | LGPL-3 |
| Website | https://www.webanixsolutions.com |
Google Sheets Connector – Two-Way Sync
Many organizations rely on Google Sheets for reporting, analysis, and collaboration, while operational data lives inside Odoo. Native exports and manual imports are time-consuming, error-prone, and difficult to audit.
Problem
- Manual CSV exports and imports
- No reliable way to push updates back into Odoo
- Data inconsistencies between systems
- Lack of traceability for changes made in spreadsheets
- Limited collaboration for non-Odoo users
Solution
The Google Sheets Connector provides a structured, secure, and auditable integration between Odoo and Google Sheets. It enables controlled one-way or two-way synchronization between Odoo models and Google Sheets, ensuring data consistency while preserving governance and access control.
Key Features
- Sync any Odoo model to Google Sheets
- Optional two-way synchronization (Sheet ↔ Odoo)
- Manual and scheduled synchronization
- Flexible column mapping between Odoo fields and sheet columns
- Change tracking and synchronization logs
- Support for filtered datasets using domain rules
- Multiple Google accounts support
Technical Highlights
- Built for Odoo 19
- Uses official Google Sheets REST APIs
- OAuth 2.0 authentication with token refresh
- No external Python dependencies required
- Upgrade-safe and uninstall-safe design
- Role-based access control
- Detailed audit logs for compliance and troubleshooting
Typical Use Cases
- Management reporting and dashboards
- Sales pipeline and CRM analysis
- Finance and operational data sharing
- Collaboration with external stakeholders
- Data validation and controlled mass updates
Industries Served
- SMEs and enterprises
- Sales-driven organizations
- Finance and accounting teams
- Operations and supply chain teams
- Consulting and service companies
Pricing
This is a paid module. Pricing reflects the flexibility, security, and operational value provided by controlled two-way data synchronization between Odoo and Google Sheets.
Version Information
- Version: 19.0.1.0.0
- License: LGPL-3
- Dependencies: base, web
Please log in to comment on this module