Advanced Odoo to Google Sheets | Google Sheets Connector | Odoo to Google Sheets Sync | Google Sheets Integration
by TeqStars http://teqstars.com/r/bSq$ 299.27
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 946 |
| Technical Name |
google_sheet_connector |
| License | OPL-1 |
| Website | http://teqstars.com/r/bSq |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 946 |
| Technical Name |
google_sheet_connector |
| License | OPL-1 |
| Website | http://teqstars.com/r/bSq |
| Versions | 17.0 18.0 19.0 |
Odoo Google Sheets Integration
Export any Odoo model to Google Sheets, edit data in your spreadsheet, and push changes back to Odoo. With incremental sync, scheduled refresh, custom filters, and secure token access.
Personalized walkthrough · Reply within 24h
Why Odoo Google Sheets Integration?
This app connects your Odoo instance to Google Sheets through a secure API. Select any model, pick specific fields from a visual sidebar, apply filters, and fetch structured data into your spreadsheet. Edit rows, add new records, and push everything back to Odoo with smart validation. Schedule automatic refresh per sheet, and let incremental sync keep your reports always current.
How It Works
Get running in 3 simple steps.
Create Account in Odoo
Click Generate Script to get your security token and Apps Script code. Copy the code in one click.
Paste Script in Google Sheets
Open Extensions → Apps Script, paste code into Code.gs, save, and authorize permissions once.
Fetch, Edit & Push
Use the Odoo menu in your sheet to fetch data, edit rows, push updates back, and schedule auto-refresh.
Key Features
Everything you need to connect Odoo and Google Sheets.
One-Click Script Generation
Generate Google Apps Script from Odoo with URL and token pre-filled. Copy and paste in seconds.
Visual Sidebar for Data Fetch
Browse models, search and pick fields with checkboxes, and add filters from a clean sidebar UI.
Custom Domain Filters
Filter records by any field with operators like =, !=, contains, and more. Selection fields show dropdowns.
Two-Way Data Sync
Fetch Odoo data into sheets and push edits back. Creates new records or updates existing ones by ID.
Incremental Sync
Only fetches new and updated records since last sync. Detects and removes deleted Odoo records from sheet.
Scheduled Auto-Refresh
Set per-sheet refresh intervals (hours + minutes). Time-based triggers keep your reports always current.
Model & Field Access Control
Restrict which models and fields each account can access. No config means full access to all models.
Smart Data Validation
Validates required fields, data types, and many2one links before writing. Row-level error messages on failure.
Multi-Sheet Support
Each sheet tab maps to a different Odoo model with its own fields, filters, and refresh schedule.
Complete Data Operations
Import, export, and automation capabilities at a glance.
Import
ODOO → GOOGLE SHEETS
Export
GOOGLE SHEETS → ODOO
Automation
SCHEDULE & CONTROL
Who Is This For?
Real-world scenarios where this integration shines.
Reporting & Analytics
Build live dashboards, pivot tables, and charts in Google Sheets using real-time Odoo data. Scheduled refresh keeps numbers current without manual work.
Team Collaboration
Share Odoo data with teams who work in spreadsheets. They edit in Google Sheets, you push changes back to Odoo. No Odoo login needed for them.
Bulk Data Operations
Mass-update prices, inventory, contacts, or any model. Edit hundreds of rows in a spreadsheet and push all changes to Odoo in one click.
See It In Action
Step-by-step walkthrough from setup to automation.
1) Google Sheets Menu in Odoo
Navigate to the Google Sheets accounts list under Technical menu in Odoo.
2) Account Configuration
Create an account with name, URL, security token, and configure allowed models and fields.
3) Open Apps Script in Google Sheets
Go to Extensions → Apps Script to open the script editor from your Google Sheet.
4) Paste Generated Script in Code.gs
Copy the generated script from Odoo and paste it into Code.gs. URL and token are already embedded.
5) Odoo Menu in Google Sheets
After saving the script, an "Odoo" menu appears with Fetch, Push, Refresh, and Schedule options.
6) Grant Google Permissions
Authorize the script once so it can communicate with your Odoo server securely.
7) Fetch Odoo Data via Sidebar
Select a model, pick fields with checkboxes, add optional filters, and click Fetch to load data.
8) Push Data Back to Odoo
Edit rows or add new ones, then push all changes to Odoo. New record IDs are mapped back automatically.
9) Incremental Auto-Fetch
Refresh Now pulls only new and modified records. Deleted Odoo records are removed from the sheet.
10) Scheduled Refresh Setup
Configure hours and minutes for automatic refresh. Each sheet has its own independent schedule.
Frequently Asked Questions
Quick answers about setup, sync, and compatibility.
Is this compatible with Odoo Enterprise and Community?
Yes. Fully compatible with Odoo Enterprise (On-premise and Odoo.SH) and Odoo Community. Odoo Online (SaaS) does not support third-party apps.
Can I restrict which models and fields are accessible?
Yes. In the account form, add rows under Allowed Models & Fields. If no models are configured, all models are accessible. If a model is added but no fields are selected, all fields of that model are accessible.
Does it support relational (Many2one) fields?
Yes. On import, many2one fields show the display name instead of the raw ID. On export/push, the app uses name search to match the text you enter to the correct Odoo record.
What happens to records deleted in Odoo?
During incremental sync, the app compares active record IDs. Any row in your sheet whose ID no longer exists in Odoo is automatically removed from the sheet.
What is the minimum scheduled refresh interval?
15 minutes minimum. You can set any combination of hours and minutes above that threshold. Set to 0 to turn off auto-refresh for a sheet.
Can I request a custom feature?
Absolutely. Contact us at info@teqstars.com to discuss custom requirements.
Why Choose Us?
Trusted Since 2019
6+ years in the Odoo ecosystem
Regular Updates
Always compatible with latest Odoo
Dedicated Support
90 days free · Fast response
10+ Years of Odoo Expertise
Deep domain knowledge since day one
100% Customer Satisfaction
Achieved across all apps
125+ Successful Projects
Completed and delivered on time
Serving 100+ Countries
Worldwide trust and reach
9+ Industries Served
Solutions across diverse sectors
More Integrations by TeqStars
Explore our other popular Odoo connectors.
Ready to Connect Odoo and Google Sheets?
Get a personalized demo to see how your team can fetch, edit, and push Odoo data through Google Sheets with full control and automation.
Request a Free Demosales@teqstars.com · TeqStars Technologies
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