Odoo Help


Can anyone provide a detailed explanation of how to use the Google Spreadsheets module?

Bill Ennals
on 5/17/18, 9:34 AM 481 views

I know this question has been asked many times but there has never been (as far as I can see) a satisfactory answer given.  Some basic steps to setup the initial connection and how to pull data from the models would be much appreciated. 

Please note, this question is not about the Google Drive app.  It's about this one:


same need for clear documentation or answer from Odoo; I will post a ticket for the odoo support.

AD LIBITOM, Thomas Guénard
on 6/11/18, 5:56 AM

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 6/26/18, 11:29 AM

I confirm that all the necessary steps are included inside the google sheet when it is created.

A menu called Odoo is available onto the spreadsheet: this where you can give access to your database data for the speadsheet (which is saved outside Odoo (if I am correct). see below.

Login: your login name used to access your db

Password: Password you use to access Odoo

Database URL: https://xxx as per your installation

Database name: "your db name"

Do not load large sets of data to make sure they are accurately read by the google spreadsheet. If necessary split your data in several sub-sets or make sure you have filtered as necessary inside odoo before your selected the data to export.

AD LIBITOM, Thomas Guénard
on 6/27/18, 4:21 PM
Haresh Kansara (hak)
On 6/25/18, 2:52 AM

Hi Bill Ennals,

There is no any documentation available about google spreadsheet, if you want to learn and get aware about it, then you just visit this link and install module and do trial and run then you can understand.



accept the answer if helpful..

Thank you.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/17/18, 9:34 AM
Seen: 481 times
Last updated: 6/26/18, 11:29 AM