| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 666 |
| Technical Name |
odootosheets |
| License | OPL-1 |
| Website | https://ksrolabs.com |
| Versions | 14.0 15.0 16.0 17.0 18.0 19.0 |
Effortlessly Connect Odoo ↔ Google Sheets
Export live Odoo data directly into Google Sheets — automate reporting, build dashboards, and analyze business data without manual exports.
🟢 FREE Support & Installation Included — We're With You Every Step of the Way
We don’t just deliver a module — we ensure it works perfectly in your environment. Get hands-on assistance, complete setup guidance, and direct communication with our team.
🚀
Free Installation
Complete setup assistance from start to finish.
⚙️
Free Configuration Guidance
Step-by-step help configuring APIs and exports.
🛠️
Free Technical Assistance
Direct support from the developers.
⚡
Quick Response Time
Fast replies because your business matters.
📞 Contact Us Directly
Why Use a Service Account?
Unlike traditional integrations that rely on user authentication tokens, the Service Account method is 100% autonomous and fully managed from Odoo. No reauthentication. No token expiry. No personal credential risks.
💪 No-Hassle Setup
Configure once and forget — Odoo handles everything securely.
🔒 Enterprise Security
Credentials remain protected within your backend environment.
🧠 Centralized Control
Manage multiple Sheets and connections directly inside Odoo.
🚀 Always-On Automation
Run scheduled exports or trigger updates instantly.
How It Works
1️⃣ Enable Google Sheets API in Google Cloud Console.
2️⃣ Create a Service Account and download its JSON key file.
3️⃣ In Odoo → Google Sheets → Connections, upload the JSON and copy the Service Account email.
4️⃣ Share your target Google Sheet with the Service Account email as Editor.
5️⃣ Configure your export, run your query, and sync data with one click.
Powerful Features
📊 Direct Export
Export any model directly to Google Sheets — skip CSVs forever.
⚙️ SQL Query Support
Run powerful SELECT queries inside Odoo.
🔄 Replace or Append
Flexible sync strategies for any reporting workflow.
🧩 Multi-Sheet Support
Manage multiple connections across departments.
⚡ Real-Time Sync
One click and your sheet mirrors live Odoo data.
📅 Scheduled Exports
Automate refresh intervals with cron jobs.
About KSROLABS
KSROLABS builds powerful, production-grade Odoo integrations, analytics platforms, and AI automation tools designed for modern data-driven companies. Our mission is simple — make business data accessible, intelligent, and actionable.
We specialize in enterprise analytics and advanced integrations including Power BI, Tableau, Google Sheets, and AI-powered automation systems. Our platform ecosystem also includes MCP Server connectivity and AI assistants for business intelligence, helping organizations transform their Odoo data into powerful dashboards, automated reports, and intelligent workflows.
Smart MCP-based analytics helpers
Power BI & Tableau dashboards
Google Sheets & analytics pipelines
Secure, scalable infrastructure
We provide consulting, connector setup, BI dashboard development, and enterprise analytics support.
Email: info@ksrolabs.com
Website: https://ksrolabs.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