Export Directly to Google Sheets

Transform your Odoo data export experience with our revolutionary app that seamlessly integrates Google Sheets into your workflow. Our app adds an innovative option to the traditional CSV and XLSX export formats, allowing you to export any list from Odoo directly to Google Sheets with just a few clicks. Enhance your data management and sharing capabilities, making collaboration easier than ever before.

Get the App Free!


Key Features:

  • Google Sheets Integration: Export Odoo lists directly to Google Sheets, facilitating real-time data sharing and collaboration.
  • Seamless Workflow: Simplify your data export process with an intuitive, user-friendly option that fits right into your existing workflow.
  • Enhanced Collaboration: Share your exported data instantly with team members, stakeholders, or clients, improving teamwork and decision-making.
  • Real-Time Data Access: Access up-to-date data anytime, anywhere, without the need for manual downloads and uploads.
  • Customizable Export Options: Tailor your exports to fit your needs, selecting specific fields or data points for inclusion in your Google Sheet.
  • Secure Data Handling: Enjoy peace of mind with built-in security features that ensure your data is safe and accessible only to those you choose to share it with.
  • Easy Setup: Get up and running quickly with minimal configuration, thanks to our user-friendly design and comprehensive support documentation.




Example Video



Create Google Sheet











Installation Guide

Introduction:

Download the app and either place it in your custom addons folder or use the upload app feature with v17. Gain access from your google account to be able to connect with odoo. Install python libraries needed to run app.

1. Enable API Access for a Project

  1. Head to Google Developers Console and create a new project (or select the one you already have).
  2. In the box labeled “Search for APIs and Services”, search for “Google Drive API” and enable it.
  3. In the box labeled “Search for APIs and Services”, search for “Google Sheets API” and enable it.

Authentication - Service Account

  1. Enable API Access for a Project if you haven’t done it yet.
  2. Go to “APIs and Services - Credentials” and choose “Create credentials - Service account key”.
  3. Fill out the form
  4. Click “Create” and “Done”.
  5. Press “Manage service accounts” above Service Accounts.
  6. Press on ⋮ near recently created service account and select “Manage keys” and then click on “ADD KEY - Create new key”.
  7. Select JSON key type and press “Create”.

You will automatically download a JSON file with credentials. It may look like this:



2. Upload your Google Sheet JSON credentials and add your shared email list.



3. Install missing python dependencies:

Open the Command Prompt or Terminal and type


pip install gspread
pip install gspread_formatting

pip install oauth2client





Note

1. This app requires python libraries gspread, gspread_formatting, oauth2client on your server. Please install them first.

2. Please contact us for any customizations! I'm happy to work on minor updates or any bug fixes.