Do users need a Google account to view the embedded dashboard?
No. The sheet is embedded as a read-only iframe inside Odoo. Odoo users do not need a Google account or any Google sign-in to view the dashboard.
Google Workspace · Odoo 16.0+
Google Sheets Dashboard for Odoo
Embed Google Sheets dashboards directly inside Odoo.
What is the Google Sheets Dashboard for Odoo?
Display live Google Sheets dashboards inside Odoo without leaving your ERP. Ideal for teams that build reporting in Google Sheets and want to surface it directly in the Odoo UI for operational teams.
Key capabilities
What's included
In-App Dashboard
Render any Google Sheets document directly inside Odoo — no browser switching.
Live Data
The embedded sheet always reflects the latest data without manual refresh.
Role-Based Visibility
Control which Odoo user groups see the embedded dashboard.
Responsive Embed
Dashboard renders correctly across desktop and tablet views inside Odoo.
Easy Configuration
Paste a Google Sheets URL in the Odoo settings — done.
Multiple Dashboards
Configure multiple embedded dashboards for different teams or menus.
Ready to connect Odoo?
Install the Google Sheets Dashboard for Odoo from the Odoo App Store — pricing available on the listing. Free setup support included with every purchase.
Frequently asked questions
Common questions about the Google Sheets Dashboard for Odoo.
Can I show different dashboards to different Odoo users?
Yes. Dashboard visibility is controlled by Odoo user groups and access rights. You can create multiple embedded dashboard configurations, each visible to a different Odoo team or role.
Does it work with private Google Sheets?
The sheet needs to be shared with view access for the embed to work. You can share via a standard Google Sheets shareable link (anyone with the link can view) or grant access to a specific service account used by your Odoo instance.
What is the difference between the Google Sheets Connector and the Google Sheets Dashboard?
The Google Sheets Connector syncs Odoo data OUT to a Google Sheet — it writes Odoo records into a spreadsheet on a schedule. The Google Sheets Dashboard embeds an existing Google Sheet INSIDE the Odoo interface so your team can view it without leaving Odoo. They complement each other: use the Connector to populate the sheet with Odoo data, then use the Dashboard to display it inside Odoo.
Can I embed multiple Google Sheets dashboards in Odoo?
Yes. You can configure multiple embedded dashboard instances, each pointing to a different Google Sheet. Common setups include a Sales dashboard for the sales team, a Finance dashboard for accounting, and an Inventory dashboard for the warehouse — each accessible from the relevant Odoo menu.
Does the embedded dashboard update in real time?
The embedded dashboard always shows the current version of the Google Sheet. Since it is an iframe pointing to the live Google Sheets URL, any changes made to the sheet are reflected immediately when users reload the view inside Odoo. There is no separate sync or caching layer.
How do I set up the Google Sheets Dashboard for Odoo?
Install the module from the Odoo App Store, navigate to the module settings in Odoo, paste your Google Sheets URL into the dashboard configuration, assign it to the desired Odoo menu location, and set the user group visibility. Setup takes under five minutes and requires no API credentials or developer access.
Which Odoo versions does the Google Sheets Dashboard support?
The Google Sheets Dashboard module supports Odoo 16.0 and above, including Odoo 17 and Odoo 18. It works with both Odoo Community and Odoo Enterprise editions. Check the Odoo App Store listing for the current version compatibility.
Can I embed a Google Looker Studio report instead of a plain Google Sheet?
The module is designed for Google Sheets embeds. Google Looker Studio (formerly Data Studio) reports have different embed requirements and authentication flows. For Looker Studio, we recommend contacting us — our team can advise on the best approach for embedding rich BI reports inside Odoo.
What happens if the Google Sheet is deleted or moved?
If the Google Sheet URL changes or the sheet is deleted, the embedded dashboard will show an error or blank view inside Odoo. Simply update the URL in the module settings to point to the correct sheet. No data is lost on the Odoo side.
Is this module suitable for non-technical Odoo users?
Yes. The Google Sheets Dashboard requires zero technical setup beyond pasting a URL. It is designed for operations managers, finance teams, and sales leads who want to surface Google Sheets reports they already build inside Odoo without any developer involvement.
You may also need
Other KSROlabs modules that pair well with Google Sheets Dashboard for Odoo.
Sheets
Google Sheets Connector
Sync Odoo data to Google Sheets in real time — no manual exports.
Learn more →BigQuery
BigQuery Connector
Sync Odoo data to Google BigQuery with incremental CDC and automated scheduling.
Learn more →SQL / Analytics
SQL Explorer Pro
Advanced SQL query builder, data visualisation, and export for Odoo.
Learn more →Explore all KSROlabs modules
Eleven production-grade Odoo integrations for AI, analytics, storage, and commerce.
View all modules →