Step 2: Install Apps Script in Google Sheets

After copying the generated script code from Odoo, install it in your Google Spreadsheet to enable the custom Odoo menu bar and interactive sidebar.

Installation Steps

  1. Open your target Google Sheet.

  2. In the top navigation menu, click Extensions ‣ Apps Script.

    Open Apps Script in Google Sheets Extensions Menu

  3. In the Apps Script editor, erase any default placeholder code inside Code.gs.

  4. Paste the complete script code copied from Odoo into Code.gs.

    Paste Generated Code in Code.gs

  5. Click the Save icon (diskette) or press Ctrl+S (Cmd+S on macOS).

  6. Close the Apps Script editor browser tab and reload your Google Sheet page.

The Custom Odoo Menu

Once reloaded, a custom Odoo menu item appears on the Google Sheets top bar:

Custom Odoo Menu Bar in Google Sheets

  • Fetch Odoo Data: Opens the interactive sidebar to select models, search fields, and load data into the sheet.

  • Push Data to Odoo: Pushes new rows or modifications from the current sheet back to Odoo.

  • Refresh Now: Executes an immediate incremental data fetch for the active worksheet.

  • Scheduled Refresh: Opens a configuration dialog to set automated background update schedules.

Authorizing Permissions

When clicking any option under the Odoo menu for the first time, Google requires one-time permission authorization:

Authorization Required Prompt

  1. Click Continue in the prompt dialog.

  2. Select your Google Account.

  3. Click Advanced, and then click Go to Project (unsafe).

  4. Click Allow to permit Google Apps Script to connect to external Odoo endpoints.

Tip

This authorization is a standard Google security requirement and is performed only once per Google Spreadsheet.

See also