| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 656 |
| Technical Name |
odoo_module_blueprint |
| License | OPL-1 |
| Versions | 18.0 19.0 |
Work in Google Sheets. Keep Odoo as the source of truth.
Sync Odoo records into Google Sheets without manual CSV exports, copy-paste mistakes, or scattered team files. Built for teams that already work inside Google Workspace.
No more exporting Odoo data again and again
Many teams still use Google Sheets for approvals, trackers, quick reports, and finance checks. This connector lets those teams work in Google Sheets while Odoo remains the main business system.
Send Odoo records
Select any Odoo model, choose fields, map columns, and push records straight into a Google Sheet.
Control mapping
Decide exactly which Odoo fields appear in Google Sheets. Keep the Sheet clean, relevant, and useful.
Track every sync
Queue records, process syncs, and effortlessly check built-in logs when something needs attention.
Safer queue-first sync design
The connector prepares the record queue, processes mapped records, writes through the Google Sheets API, and records the result safely in sync logs.
Setup in a few clear steps
Connect Google, create a mapping, choose fields, and click Sync Now.
Create a Google Cloud service account
Enable Google Sheets API and Google Drive API in Google Cloud. Create a service account and download the JSON key.
Share the Sheet with the service account
Open your Google Sheet and share it with the service account email as Editor. Paste only the email address.
Create the connection in Odoo
Go to Google Sheets → Connections, create a new connection, and paste the full service account JSON.
Create a mapping
Go to Google Sheets → Mappings, choose the Odoo model, paste the Spreadsheet ID, enter the Sheet tab name, and map fields.
Click Sync Now
The connector perfectly formats and sends the selected Odoo records directly into your Google Sheet.
Simple screens your team will understand
1. Google Sheets Connection
Store the Google service account JSON and confirm the identity Odoo uses to write into Google Sheets.
2. Field Mapping
Select the Odoo model and columns to send. Each row tightly controls one Odoo field mapped to one Google Sheets column.
3. Google Sheets Output
Odoo records appear instantly inside Google Sheets with an internal Odoo ID column alongside your mapped business fields.
4. Sync Queue
Queue records explicitly show what is pending, done, or failed during sync processing.
5. Sync Logs
Sync logs show the mapping, model, record status, and detailed message for every single record.
For teams that live in Sheets
Give business users a clean Google Sheets view of Odoo data without asking them to download CSV files.
-
✓Sales: Review contacts, leads, quotations.
-
✓Inventory: Export products & stock levels.
-
✓Purchasing: Vendor reviews & procurement.
-
✓Finance: Create controlled working sheets.
Map the fields you actually need
| Odoo Field | Appears In Sheets As |
|---|---|
| Text / Char | Plain text (Name, email, phone) |
| Number / Float / Int | Readable values (Qty, price) |
| Date / Datetime | ISO format (Create date) |
| Many2one | Display name (Company) |
| Boolean | True / False (Active) |
Remove the daily CSV habit
Less manual work
No repeated CSV export just to update a Google Sheet.
Cleaner sheets
Mappings exclusively control what appears in the spreadsheet.
Better debugging
Queue status and sync logs help users easily see what worked.
Google Sheets Connector for Odoo
Built for practical Odoo teams that need clean, automated spreadsheet workflows.
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