User Guide for Odoo Google Looker Studio

INTRODUCTION

Odoo Google Looker Studio connects Odoo with Looker, helping businesses sync important data like sales, inventory, CRM, and accounting.

With this module, users can leverage Looker’s data analytics and visualization tools directly on their Odoo data, gaining deeper insights and better decision-making.

It offers automated data synchronization, customizable reporting, and interactive visualizations to track business performance efficiently.

FEATURES

1. Sync Odoo data with Odoo Google Looker Studio module for real-time insights.
2. Make your tables using Odoo data with many columns from different data models.
3. Select specific Odoo modules like Sales, CRM, and Accounting for seamless synchronization.
4. Import Odoo tables into Looker effortlessly for enhanced data analysis.
5. View Odoo data on Looker dashboards for improved decision-making.
6. Update and re-import tables from Odoo to Looker to maintain accurate, up-to-date data.
7. Generate custom reports in Looker to gain deeper insights into your Odoo data.
8. Visualize Odoo data with charts, graphs, and tables for clearer analysis.

INSTALLATION

1. Download the module’s zip file and extract its content.
2. Locate the folder named odoo_looker_connector and copy it to your Odoo Add-Ons path.
3. Open Odoo App and navigate to the Settings.
4. Enable Developer Mode.
5. Go to the Apps menu and click on Update Modules List.
6. Search for odoo_looker_connector, select the module, and click Install.

WORKFLOW

1. Install Looker Connector from Google Marketplace

First, install the Looker Connector from the Google Marketplace. This allows Google Looker Studio to communicate with Odoo and fetch the required data seamlessly.

2. Configuration at Odoo End

a) Open Odoo and navigate to Odoo Google Looker Studio (Looker Connector) App from the main dashboard.

b) Click on New to create a Looker Table, which will act as a bridge between Odoo and Google Looker Studio.

c) Enter the Table Name and select the Model Name that holds the required data fields.

d) Add relevant fields to the table using the field selection options provided.

e) Use “Search More” to find more fields that are not listed. Here you can choose fields to add for the looker columnn.

f) Select the model field that you want to add to the Looker Table. You will be shown as a looker table as below.

g) Activate the Looker table to make it available for Odoo Google Looker Studio data fetching.

g) Navigate to Looker Settings and generate an Access Token. This token is required to authenticate Odoo with Looker.

3. Configuration at Looker End

a) Open Looker and go to the Looker Connector interface to set up the connection. Enter Odoo URL and Access Token to authenticate the integration process.

b) Select Odoo table from the dropdown list, ensuring that the correct dataset is fetched Click Next to proceed with the integration process

c) Choose the Service Type from the dropdown, which includes all the Looker tables created at Odoo end.

d) Click on Connect to establish a secure connection between Odoo and Looker.

e) After connecting, click “Create Report” to make visual reports with Odoo data.

4. Update Odoo Table in Looker

a) You can update the looker table in Odoo in our Odoo Google Looker Studio module. After making changes, select the table again from the list to re-import it into Looker.

d) Create relationships between different tables in Looker to build more insightful and interactive reports.

NEED HELP?

I hope you find Odoo Google Looker Studio guide helpful! Feel free to share your feedback in the comments.

For any queries create a ticket UV Desk or contact our support mail.

Thanks for your attention!