[RFC] Odoo / Google Spreadsheet connector (Odoo -> Spreadsheet) (google_spreadsheet_export)

[cuongnmtm]

Dependencies: base
License: AGPL
Python dependencies: gspread

Authorize by google service p12_json_key

Usage

• Open general config setting and upload google service p12_json_key to authorize.
• Create a new Odoo ir.export for a model.
• Open the Google Spreadsheet Export menu and create a new record with re-use the above ir.export.

Technical Specifications

New model google.spreadsheet.export

• name: char
• model_id: m2o ir.model
• ir_export_id: m2o ir.exports
• domain: text, widget domain
• sheet_name: char
• document_url: char
• ...

Reusing the native Odoo export function to get the data, then using the python package gspread to export data to google spreadsheet.

A daily cron to run the function.

On general config setting

Add a new section to upload p12_json_key to authorize (easily created and downloaded from google)