CODEerts Google Sheets Connector | Odoo to Google Sheets Sync | Export Data to Spreadsheet | Scheduled Sheet Integration
by CODEerts https://www.codeerts.com$ 79.07
Google Sheets Connector
Push any Odoo model into Google Sheets,
manually or on a schedule.
Map fields from dropdowns, filter with an Odoo domain, choose full or incremental refresh, and keep an audit log of every sync.
|
Any
Odoo Model
|
2
Refresh Modes
|
0
Code Required
|
Live
Scheduled Sync
|
v19
Compatible
|
What this module does
Google Sheets Connector is a live data bridge that pushes records from any Odoo model into Google Sheets. Authenticate once with a Google service account, point a connector at a spreadsheet, then map a model to a worksheet and pick the columns from dropdowns, including related paths such as a customer's country.
Filter exactly which records go out with a standard Odoo domain, choose full overwrite or incremental refresh, and run the push manually or on a schedule. Every run is written to a sync log, and a failed scheduled run posts a note and notifies the responsible user.
|
🗂
Map From Dropdowns
Pick fields and related paths from dropdowns, no typing field names. Choose a format per column: text, number, date, currency or an embedded image. |
⏱
Manual or Scheduled
Push on demand with one click, or set an interval and let a background job keep the sheet current on its own. |
📋
Every Sync Logged
A per-run log records rows written, failures and duration. A failed scheduled run posts a chatter note and notifies the responsible user. |
|
🔗 Related And Dotted Paths
Export a customer's country, a product's category and other related fields, not just direct columns. |
🔍 Odoo Domain Filter
Send only the records you want with a standard Odoo domain, for example only confirmed orders. No SQL. |
|
🔄 Incremental Refresh
Update changed rows by key and append new ones, leaving the extra columns and formulas you added in the sheet untouched. |
🖼 Image Embedding
Format a column as an image and the connector writes the Google Sheets IMAGE formula so pictures render in the cell. |
|
🗂 Multiple Tabs
Push several models into several worksheets of the same Google Sheet from a single connector. |
✅ Connection Test
A guided setup form validates the service account key and confirms sheet access before your first sync. |
|
💱 Currency And Date Aware
Monetary columns format with the record currency and datetimes convert to the user timezone. |
🛡 Two Tier Security
A User group runs connectors while a Manager group configures service accounts and credentials. |
Per column formats
|
🔤
Text
Names and labels |
🔢
Number
Quantities and counts |
📅
Date / Time
Timezone aware |
💰
Currency
With record currency |
🖼
Image
Via IMAGE formula |
How it works
|
1
|
Add a service account
Upload your Google service account JSON key. The in-app guide walks you through creating it in Google Cloud, and the form shows the email to share your sheet with. |
|
2
|
Share your sheet
Give the service account email Editor access to your Google Sheet, then use the connection test button to confirm access. |
|
3
|
Create a connector and mapping
Point a connector at the sheet, then map a model to a worksheet, choose the columns and formats, and set an optional filter. |
|
4
|
Choose the refresh mode
Full overwrite for a clean rewrite, or incremental to update changed rows and append new ones while keeping your extra columns. |
|
5
|
Sync now or schedule it
Push once with Sync Now, or set an interval and let the connector keep the sheet current. Check the sync log any time. |
Screenshots
GUIDED SETUP: upload the key and share the sheet with the shown email
CONNECTOR: point at any sheet, run manually or on a schedule
MAPPING: pick fields and related paths from dropdowns, set formats and refresh
SYNC LOGS: rows written, failures and duration for every run
Technical information
|
Version
19.0
|
License
OPL-1
|
Runs On
On-premise & Odoo.sh
|
Dependencies
base, mail
|
Technical name: codeerts_google_sheets_connector · Python libraries: gspread and google-auth · Auth: Google service account
Frequently asked questions
Create a connector pointing at your Google Sheet, map an Odoo model to a worksheet, and set the connector to Scheduled. A background job then pushes the latest records on the interval you choose, and every run is written to a sync log.
Yes. Each mapping picks its columns from dropdowns, including related fields such as a customer's country, and filters the records with a standard Odoo domain, so only the rows and columns you want are pushed.
Not if you use incremental refresh. It matches rows by a key field, updates changed rows and appends new ones, and leaves any extra columns or formulas you added in place. Full overwrite mode is also available when you want a clean rewrite.
It uses a Google service account. You upload the service account JSON key in Odoo and share your Google Sheet with the service account email shown on the form. The in-app guide walks you through creating the key in Google Cloud.
The connector runs on Odoo on-premise and Odoo.sh, which allow the required Python libraries. Odoo Online (SaaS) does not allow installing those libraries, so use on-premise or Odoo.sh for this app.
It is maintained for current major Odoo versions and each Odoo Apps Store listing shows the exact version it supports.
The team behind this module
About CODEerts
Full-Service Odoo ERP Agency · Solutions That Scale
Every module in our store is built from real client work, tested in production and maintained long-term by a team of Odoo certified consultants. When you need more than an app, we deliver the full solution.
|
🏗️ Implementation
Full Odoo roll-outs from requirements to go-live, across any industry and company size. |
🧩 Custom Development
Bespoke modules, OWL components and business logic built precisely to your workflow. |
🔄 Migrations
Zero-data-loss upgrades from older Odoo versions with full custom module porting. |
|
🔌 Integrations
Payment gateways, shipping carriers, biometric devices, eCommerce and third-party APIs. |
🔍 Odoo Audits
Performance, security and code-quality reviews that surface risks before they become problems. |
🧑💻 Support & Training
Ongoing helpdesk, user training and monthly retainers so your team stays productive. |
More from CODEerts
Other apps we build to make Odoo do more. Tap any card to open it on the Odoo Apps Store.
 FREE Archive Anything |  FREE Transaction Flow Visualizer |  FREE Smart Mail Rebrand |  FREE Duplicate Record Detector |
 AI Dashboard Builder |  Advance Payment Pro |  Dual Book & Tax Depreciation |  Smart Duplicate Detector |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 886 |
| Technical Name |
codeerts_google_sheets_connector |
| License | OPL-1 |
| Website | https://www.codeerts.com |
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