Google Sheets Odoo Connector
The Google Sheets Odoo Connector provides a seamless way to fetch and work with Odoo data directly inside Google Sheets. After generating an API key and connecting your Odoo instance, you can browse any Odoo model and instantly load them into Google Sheets. This connector is built for users who prefer spreadsheet-based workflows but need real-time access to Odoo data. It eliminates manual exports, improves accuracy, and saves hours of repetitive work.
Features
Connect with Odoo Using API Key
You can securely connect Google Sheets with your Odoo database using your generated API key.
Select Odoo Model Inside Google Sheets
Select any Odoo model directly from Google Sheets and instantly connect your spreadsheet to live Odoo data.
Refresh Odoo Models
You can refresh the entire Odoo model list whenever new models or fields are added.
Schedule Auto Refresh
Schedule auto-refresh for any Odoo model, and remove auto refresh whenever you no longer need it.
Configurable Refresh Frequency
Schedule automatic data refresh at defined intervals such as hourly, every 6 hours, every 12 hours, or daily to keep records updated without manual intervention.
Go to the 'Settings'.
Generate your Odoo URL and API Key using Generate Key, then click Save to apply the configuration.
You can copy your Odoo URL and API Key from here to use in the Google Sheets.
Make a copy of the provided sheet to use the Google Sheets connector.
Click on the "Make a Copy".
Go to the "Configure Odoo URL and API key" from the "Odoo Connector" menu.
Add the generated Odoo URL and API key from the settings, then click on the "Test and Save Connection" button.
Select the models and click on the "Fetch Data" button.
Here, you can see the fetched data of the selected models.
Go to the "Scheduled Refresh" from the "Odoo Connector" menu.
Select the "Refresh Frequency", The data will refresh automatically at the scheduled interval (e.g., every 1 hour).
Click on the "Setup Auto Refresh" button.
Select the "Refresh Now" to refresh models now.
Data refreshed popup comes, when refresh done.
Version 19.0.1 | Released on : 23rd January 2026
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
- No, this application is not compatible with odoo.com(odoo saas/Odoo Online)
- Yes, to test this module, please contact us at sales@softhealer.com.
- Please contact us at sales@softhealer.comto request customization.
- Yes, we provide free support for 365 days from the date of purchase.
- Yes, you will receive lifetime free updates for the version of the module you purchased.
- No, there is no need to install any additional libraries.
- Yes, for version 12 and above, you need to purchase the module separately for each version you intend to use.
- No, exchanges or refunds are not allowed. Please make sure to select the correct version before purchasing.
- You can contact us at support@softhealer.com for language translation support. We use Google Translator tools to provide translations in multiple languages, so the accuracy may vary. We welcome your suggestions to help improve translations.
Discover Our Latest Apps
