Dynamic Google Sheets & Odoo Product Integration

Transform the way you manage and interact with product data in Odoo using our custom-built Google Sheets Integration app. Seamlessly blend the power of Google Sheets with the robust functionality of Odoo to elevate your business operations.

Get the App Free!


Key Features:

  • Effortless Sheet Creation: Instantly generate Google Sheets based on any selected product in Odoo. Choose the fields you want, and watch as a new sheet populates with your product data organized into neatly arranged columns.
  • Data Update: Make changes to product information directly in Google Sheets and have those modifications reflected in Odoo without the need for manual updates.
  • Quick Product Access: Navigate from Odoo to Google Sheets with a single click. Open up detailed product sheets directly from Odoo records, ensuring you have all the information you need at your fingertips.
  • Efficient Sheet Management: Access and manage all your previously created product sheets without the hassle. Our app keeps a well-organized list, so you can open any existing sheet with ease.




Google Sheet Menus


Create Google Sheet










Update Data from Google Sheet







Open Products from Google Sheet in Odoo



Open Google Sheet from Odoo







Streamlined Workflows

Save time with automated sheet creation and data population, allowing you to focus on what matters most.

Enhanced Data Accuracy

Minimize errors with automatic updates, ensuring your product data is always current and correct.

Improved Collaboration

Share and collaborate on product data with team members in real-time, leveraging the collaborative features of Google Sheets.

Increased Productivity:

 Eliminate redundant tasks and accelerate your productivity with quick access to product sheets and data within Odoo.

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.



2. 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, and gspread_formatting 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.