Sync Odoo data to Google Sheets in real time — no manual exports.
Automatically export and sync Odoo records to Google Sheets using secure service-account automation. Schedule syncs, map Odoo fields to sheet columns, and share live Odoo data with stakeholders who live in Google Workspace.
Service Account Auth
Secure Google service account authentication — no OAuth pop-ups or manual sign-ins.
Scheduled Sync
Push Odoo records to Sheets on a schedule you define — hourly, daily, or on demand.
Field Mapping
Map any Odoo model field to a Google Sheet column with a point-and-click UI.
Multi-Sheet Export
Export different Odoo models to separate sheets or separate spreadsheets.
Access Control
Odoo record-level security applied before any data leaves the ERP.
Incremental Updates
Update only changed records to keep sync fast and efficient.
Install the Google Sheets Connector for Odoo from the Odoo App Store or talk to us about your setup.
Common questions about the Google Sheets Connector for Odoo.
Install the KSROlabs Google Sheets Connector from the Odoo App Store, configure a Google Cloud service account with Sheets API access, and map the Odoo models and fields you want to export. Data syncs automatically on the schedule you define — no custom development required.
No. You only need a Google Cloud service account with Sheets API access. No Google Workspace admin rights are required. The service account approach is more secure than OAuth as it runs server-to-server.
Yes. The connector supports any Odoo model including custom models, and lets you map any field to a spreadsheet column. Core models like sale.order, account.move, stock.quant, crm.lead, and res.partner are all supported out of the box.
Sync frequency is configurable from the Odoo backend — you can set hourly, daily, or custom cron-based schedules. Manual on-demand sync is also available for immediate data export.
Data is pushed from Odoo to Google Sheets, keeping Odoo as the single source of truth. This ensures your spreadsheet data is always consistent with what is in the ERP.
Yes. You can configure multiple sync configurations, each targeting a different Odoo model and Google Sheets spreadsheet. For example, sales orders in one sheet, invoices in another, and inventory in a third.
Yes. The connector supports incremental updates — only new or modified records are synced on subsequent runs. This keeps sync fast and efficient, even with large Odoo databases.
The connector uses Google Cloud service account authentication (JSON key file). This provides secure, non-interactive server-to-server communication without OAuth pop-ups or user sign-in flows.
Yes. Once Odoo data is exported to a Google Sheet, you can share it with team members using standard Google Sheets sharing settings. The sheet updates automatically based on your sync schedule.
The connector is designed for Odoo 19.0+ and works with both Community and Enterprise editions. Check the Odoo App Store listing for the latest version compatibility.
Yes. Once data is synced to Google Sheets, you can build charts, pivot tables, and dashboards using native Google Sheets features. For an embedded in-Odoo dashboard experience, see the companion Google Sheets Dashboard module.
Yes. All data transfers use HTTPS encryption. The connector respects Odoo record-level and field-level security — only data the configured Odoo user is authorised to see will be exported to Google Sheets.
Seven production-grade Odoo integrations for analytics, AI, storage, and commerce.
View all modules →
