Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Extra Tools
  3. Google Sheet Connector v 18.0
  4. Sales Conditions FAQ

Google Sheet Connector

by Odolution https://www.odolution.com/
Odoo

$ 302.85

v 18.0 Third Party 2
Live Preview
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 831
Technical Name ol_sheets_connector
LicenseLGPL-3
Websitehttps://www.odolution.com/
Versions 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 831
Technical Name ol_sheets_connector
LicenseLGPL-3
Websitehttps://www.odolution.com/
Versions 16.0 17.0 18.0 19.0

Why Sheets Connector?

The Sheets Connector seamlessly integrates your Odoo data with Google Sheets, enabling dynamic and automated synchronization. With flexible data syncing, multi-sheet support, and the ability to customize exports, you can easily manage, filter, and update your data in real-time. Whether you're creating new worksheets, syncing model data, or scheduling automatic updates, our connector ensures a smooth, efficient workflow directly between Odoo and Google Sheets.

Need Help?

Connect with us on email

Chat with us on WhatsApp

WATCH QUICK DEMO HERE

Key Attributesof Sheets Connector

Seamless Google Sheets Integration
Seamless data fetching using Query and direct Model
Flexible Data Syncing
Flexible Data Syncing
Multi-Sheet Support
Multi-Sheet Support
Selective Data Export
Selective Data Export
Scheduled Synchronization
Scheduled Synchronization
Access Google Sheets Directly from Odoo
Access Google Sheets Directly from Odoo
  • Features
  • Setup
  • Support

Seamless Google Sheets Integration

Sync data seamlessly between Odoo and Google Sheets. With this feature, you can easily synchronize any data between your Odoo instance and Google Sheets, making it simple to manage and share data in real-time. No need for manual updates just a few clicks, and your data is synced automatically.

Customizable Data Syncing

Easily update data using model selection or custom queries, ensuring that only the relevant data is transferred. Whether you want to sync customer details, sales orders, or inventory, this feature provides flexibility to control exactly what gets updated between Odoo and Google Sheets. Tailor your sync processes to fit your business needs.

Multi-Sheet Support

Work with multiple sheets in a single Google Sheets document. This feature allows you to manage various types of data on separate sheets, providing a more organized and efficient way to handle large datasets. You can update and manage different types of records, all within the same document, for better structure.

Selective Data Export

Export specific fields and records with ease. Whether you need to export customer details, order data, or inventory levels, you can select exactly what to export, avoiding unnecessary data clutter. This ensures that only the most relevant information is shared, improving data accuracy and reducing errors.

Scheduled Synchronization

Automate your data syncing process at regular intervals. Set your preferred sync schedules whether it's daily, weekly, or hourly and the system will handle the rest. This automated process ensures your data is always up-to-date, without the need for manual intervention.

Access Google Sheets Directly from Odoo

Open and edit your Google Sheets directly from the Odoo interface. This seamless integration means you can view and manage your Google Sheets without switching between platforms. Make real-time changes to your sheets while staying within Odoo, improving your workflow efficiency and saving time.

Install the required Python libraries

Install the gspread and oauth2client python libraries in Odoo.

Navigate to https://console.cloud.google.com/

Click "Select a Project"

Click New Project

Type Project Name and click "Create"

Click "Select Project"

Search for Google Sheets API in the search bar.

Enable Google Sheets API

Go to Menu > IAM and admin > Service accounts

Click "Create service account"

Type Service Account name and Click "Done"

If your service account key is not listed refresh the page.

Open Service Account and click on "Add Key"

Click "Create new key"

Select "JSON" key type and click create. Your service account key will be downloaded.

Open Odoo database and Navigate to Settings > Technical > Google Sheets Service Account Key.

Click on Service Account Key kanban

Upload the downloaded Service account key JSON file.

Click "Validate Key"

Copy client_email from your Service Account Key. Open your Google sheet and Share with your client_email.

Click "Send"

Copy your Google sheet link.

Open your database and navigate to "Sheets"

Click on Configuration

Select "Worksheet Configuration"

Click "New"

Enter a Configuration Name and paste the Google Sheet Link.

Click Test Connection

You will see connected in status if the worksheet connects successfully.

Navigate to Data Menu

Create a New record. Fill in all required fields, select the configured Google Sheet, Input the Worksheet Name.

Click "Execute" to view records.

Click "Sync Data".

Click "Open Google Sheet"

Data has been synced successfully with Google Sheets

Check "Enable Scheduler" to automate the synchronization.

Need Help? We have Got You Covered!

User Guide
Check out our comprehensive User Guide for step-by-step instructions Here
Contact Us
Still have questions? Don't hesitate to reach out via email at app.support@odolution.com Or via whatsapp at +923356928563 . We are happy to help!
Support Ticket
For any issues you encounter while using our app, we offer free support for 90 days from the date of purchase, provided the issue is related to the app.
To get assistance, please visit www.odolution.com to create a support ticket. Simply register on our platform and provide the details of the issue, and our team will work to resolve it promptly.

FAQs

How does the Sheets Connector integrate with Google Sheets?
The Sheets Connector integrates seamlessly with Google Sheets by allowing you to connect your Google account and automatically sync data between your sheets and other applications. It does not require any complex setup, and once connected, the data flow is smooth and consistent across platforms.
Can I sync data from multiple Google Sheets at the same time?
Yes, the Sheets Connector supports multi-sheet integration, allowing you to synchronize data from several Google Sheets simultaneously. This feature is particularly useful if you're managing data across different sheets and want them all to stay up-to-date without manual intervention.
Can I schedule data syncs to happen automatically?
Absolutely! With the scheduled synchronization feature, you can set specific intervals (e.g., daily, weekly, or monthly) for your data to sync automatically. This ensures your data remains up-to-date without the need for constant manual updates.
Is it possible to selectively export data from Google Sheets using the connector?
Yes, you can export specific fields and records using domain filter on the model you are exporting data from.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with