Dynamic Google Sheets & Odoo Customer Integration
Transform the way you manage and interact with customer 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.
Key Features:
- Effortless Sheet Creation: Instantly generate Google Sheets based on any selected customer in Odoo. Choose the fields you want, and watch as a new sheet populates with your customer data organized into neatly arranged columns.
- Data Update: Make changes to customer information directly in Google Sheets and have those modifications reflected in Odoo without the need for manual updates.
- Quick Customer Access: Navigate from Odoo to Google Sheets with a single click. Open up detailed customer 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 customer 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
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 customer data is always current and correct.
Improved Collaboration
Share and collaborate on customer 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 customer 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
- Head to Google Developers Console and create a new project (or select the one you already have).
- In the box labeled “Search for APIs and Services”, search for “Google Drive API” and enable it.
- In the box labeled “Search for APIs and Services”, search for “Google Sheets API” and enable it.
Authentication - Service Account
- Enable API Access for a Project if you haven’t done it yet.
- Go to “APIs and Services - Credentials” and choose “Create credentials - Service account key”.
- Fill out the form
- Click “Create” and “Done”.
- Press “Manage service accounts” above Service Accounts.
- Press on ⋮ near recently created service account and select “Manage keys” and then click on “ADD KEY - Create new key”.
- Select JSON key type and press “Create”.
You will automatically download a JSON file with credentials. It may look like this:
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.