How long does it take to connect Odoo to Google Sheets with Brooked?

Setup takes ~2 minutes. Install Brooked from the Google Workspace Marketplace, authorize Odoo via OAuth or API key, choose what to sync, and you're live.

Does Brooked support two-way sync between Google Sheets and Odoo?

Yes. Brooked supports two-way sync on every database and warehouse connector, read live data into Sheets and write changes back to Odoo. Audit logs capture every write.

Can I schedule automatic refreshes of Odoo data into Google Sheets?

Yes, on the Pro plan. Schedule imports to refresh hourly, daily, or weekly. The data updates automatically in your spreadsheet without any manual action.

How much does the Odoo integration cost?

Free tier: 100 imports per month, AI Analyst included, no credit card. Pro: $29 per user / month with unlimited imports, Claude & OpenAI, scheduled auto-sync, Python sandbox, and alerts. Enterprise: custom pricing with SSO, SAML, and dedicated support.

Is the Odoo connection secure?

Yes. Brooked uses OAuth 2.0, API keys, or key-pair authentication depending on the source. Credentials are encrypted at rest and in transit, never stored in plain text. Brooked is a verified Google Workspace app.

All integrationsFinance & ERP

Live~2 minutes

Odoo → Google Sheets

Import contacts from Odoo

Connect Odoo Read setup guide ↓

API key · Read-only by default · No data stored

	id	name	value	updated_at
1	1	Alpha	$12,400	2025-04-01
2	2	Beta	$9,820	2025-04-02
3	3	Gamma	$7,650	2025-04-03
4	4	Delta	$6,100	2025-04-04

~2 minutesSetup time

API keyAuthentication

15 minMin sync interval

Read-onlyDirection

Capabilities

Everything in the Odoo connector

3 built-in capabilities, from live queries to scheduled syncs and AI-powered data analysis.

Technical details

Built for IT teams to approve in one read

Every connection is read-only by default. Credentials are encrypted at rest. Brooked is a verified Google Workspace app.

Authentication: API key
Direction: Read-only

Setup guide

Connect in 3 steps

From install to your first live query in under 5 minutes. No engineering help required.

Get started free

Connect your account

Authorize Brooked to access your Odoo data using an API key or token.

Choose what to import

Pick from 4 available data types, like Contacts, Activities, Opportunities.

Schedule your sync

Run it once, or set a recurring schedule. Data flows straight into your Google Sheet.

Need help? Visit support →

Use cases

How teams use Odoo + Brooked

From finance reporting to real-time operations dashboards, see what your team can build.

Keep Odoo data current in Sheets

Automatically sync your finance & accounting data from Odoo into a Google Sheet on a schedule, so reports and dashboards always reflect what's actually in Odoo, no manual exports.

Live in Google Sheets

Odoo → Sheets · auto-refresh

Available functions

Query Odoo from a cell

Five built-in sheet functions, from natural-language queries to raw SQL and AI-powered KPI cells. No coding required.

=BRKD_QUERY("Odoo", "total accounts receivable balance by customer")

Ask a natural-language question against any connected data source. Returns a table of results that spills into adjacent cells.

=BRKD_QUERY("Odoo", "total accounts receivable balance by customer")

Also supported

View all integrations

Get your spreadsheet hours back

Brooked sets up in seconds. Your team is querying live data before lunch.

Get started free

Odoo → Google Sheets

Everything in the Odoo connector

Built for IT teams to approve in one read

Connect in 3 steps

Connect your account

Choose what to import

Schedule your sync

How teams use Odoo + Brooked

Query Odoo from a cell

More Finance & ERP integrations

QuickBooks

Sage Intacct

NetSuite

Get your spreadsheet hours back

Product

Resources

Compare

Company