Google Sheets Connector Overview

The Google Sheets Connector by TeqStars provides a seamless, real-time two-way integration between any Odoo database and Google Sheets. It empowers sales teams, accountants, inventory managers, and data analysts to build custom live dashboards, extract structured datasets, and update Odoo records directly from Google Sheets without writing backend code or running manual CSV exports.

Core Integration Features

  • Universal Model Compatibility: Connect any standard Odoo model (e.g., Sale Orders, Invoices, CRM Leads, Products, Stock Moves) or custom developer models.

  • Bi-Directional Synchronization: Pull live Odoo records into Google Sheets for custom reporting and push edits or newly inserted spreadsheet rows directly back into Odoo.

  • Interactive Google Sheets Sidebar UI: Choose models, search fields dynamically, check specific columns, and trigger fetch operations directly inside Google Sheets.

  • Granular Access Control: Limit each connection account to the access rights of a chosen Odoo user, restrict it to specific models, limit readable/writable fields, and enforce Odoo domain filters.

  • Reliable Refresh Sync: Each sync updates existing rows, adds new records, restores missing rows and keeps values in your own extra columns.

  • Automated Deletion Cleanup: When a record is deleted or unlinked inside Odoo, the connector automatically identifies it and removes the matching row from your Google Sheet.

  • Scheduled Background Refresh: Configure time-driven background auto-refreshes per sheet tab (customizable intervals starting from 15 minutes up to 24 hours).

  • Smart Relational Field Handling: Displays Many2one record display names on fetch and automatically resolves text back to relational record IDs using Odoo’s name-search during push operations.

Technical Architecture

The integration consists of two primary components communicating over secure HTTP JSON POST requests:

  1. Odoo REST API Engine: Generates secure credentials and serves endpoints (/api/sheets/get_models, /api/sheets/get_fields, /api/sheets/get_data, /api/sheets/push_data).

  2. Google Apps Script Client: Executes inside your Google Spreadsheet, rendering a custom Odoo top menu, modal dialogs, and a responsive sidebar UI.

See also