Step 1: Create Connection Account in Odoo

To link Google Sheets with Odoo, you must first create a Connection Account in Odoo. This account generates a unique Connector URL and secure Access Token used by Google Apps Script.

Create Connection Account

  1. Navigate to Settings ‣ Technical ‣ Google Sheets ‣ Accounts (or Base ‣ Custom ‣ Google Sheets).

  2. The list view displays all existing connection accounts, their URL, and creation dates.

    Accounts List View

  3. Click New to create a new connection record.

  4. Enter a descriptive Name for your connection account (e.g., Sales Team Reporting Sheet).

  5. The system automatically populates the Connector URL and generates an encrypted Access Token.

    Connection Account Form View

  6. Click Save.

API Credentials Summary