Step 3: Allowed Models, Fields & Domain Filters

Security and data restriction rules are configured directly inside Odoo for each connection account. By setting up the Allowed Models & Fields notebook tab, you control exactly which models, fields, and filtered datasets a Google Sheet is authorized to read or write.

Access Control Matrix

Configuring Model Lines & Domains

  1. Open your connection account in Settings ‣ Technical ‣ Google Sheets ‣ Accounts.

  2. Under the Allowed Models & Fields tab, click Add a line.

  3. Select the target Odoo Model (e.g., Sale Order).

  4. In the Fields column, select allowed fields using the tags widget. Leave it empty to allow all fields.

  5. In the Filter column, use Odoo’s visual domain builder widget to specify criteria (e.g., [('state', '=', 'sale')]).

  6. Click Save.

Important

Domain filters act as a strict server-side firewall. Even if a spreadsheet user requests all records, Odoo enforces the domain rule and returns only matching records.

See also