docs-mintlify/docs/integrations/google-sheets.mdx
Available on Premium and above plans.
</Note>After configuring, installing, and authenticating this add-on, you will be able to create reports via pivot table and work with saved reports.
<iframe width="100%" height="400" src="https://www.youtube.com/embed/qPp9hroqd4g" title="YouTube video" frameBorder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowFullScreen />Cube Cloud for Sheets uses the SQL API internally. So, the SQL API has to be enabled in the Cube Cloud deployment settings.
You have to install Cube Cloud for Sheets into your Google Workspace organization. To do so, navigate to its page in the Google Workspace Marketplace and click Install:
<Frame> </Frame>To verify that the add-on is successfully installed, go to any Google Sheets document, open the Extensions menu, and check that there is the Cube Cloud for Sheets menu item:
<Frame> </Frame>You need to authenticate Cube Cloud for Sheets to retrieve data from Cube Cloud. To do so, open the sidebar by going to the Extensions menu and choosing Cube Cloud for Sheets → Open Sidebar. Then, click Sign in.
<Frame> </Frame>A modal window with an authentication prompt will appear. Choose the deployments
that you want to work with in Google Sheets and click Authorize.
Once you see the Access Granted message, close the modal window.
If you want to revoke the authentication, open the add-on menu and click Sign out.
To create a report, go to the add-on menu and click Create report via pivot table. Then, select a Cube Cloud deployment from the drop-down. Finally, you can start building a query by selecting a view and its members in the UI that looks and feels like Playground.
<Info>Cube Cloud for Sheets works only with views, not cubes.
</Info>If the view defines default_ui_filters, those
filters are pre-populated as soon as you select the view — the same way they
are in workbooks. They are a starting point, not enforcement: you can change
their values, switch operators, or remove them.
Click on members to add them to Rows and Measures. If needed, drag dimensions from Rows to Columns. Click on the funnel buttons to add members to Filters. Click on × to remove members from a query.
<Frame> </Frame>Use Order and Filters panes below to sort and filter the data in the report.
If you'd like to move the report to a new location, click on the desired top-left cell and then confirm with the target button under Result location.
<Frame> </Frame>With every change to your query, Cube Cloud for Sheets will update the report on the sheet after a slight delay. If you'd like to minimize it, consider implementing pre-aggregations.
By default, measures nest under each value of the dimension they're paired with — every measure for the first column value, then every measure for the next. Open the Display tab to change Measure position to Before columns to get the opposite layout: each measure spans every column value, with all values of one measure together before moving to the next.
For example, with Forecast Sales Units and Forecast Net Sales on Measures
and a season dimension on Columns:
Q1: [Sales Units, Net Sales] | Q2: [Sales Units, Net Sales]Sales Units: [Q1, Q2] | Net Sales: [Q1, Q2]The same choice applies when measures are placed on Rows instead (set with Measures on, in the same tab) — there it's labeled After rows / Before rows.
To change the order measures appear in within their group, drag them within the Measures pane on the Pivot tab. Position and order are saved with the report and survive Refresh.
When your report is ready, you can optionally move it to saved reports by clicking Save.
Go to the add-on menu and click View saved reports to see a list of reports. Use the search box above the list to quickly find a folder or exploration by name across your whole deployment, not just the current folder — results are grouped by type and show each item's folder location, and selecting one navigates you straight to it.
An exploration can be placed more than once — on different sheets or at different anchors in the same spreadsheet, and in more than one document at once (a Google Sheets spreadsheet and an Excel workbook simultaneously). Hovering a row in this list shows every placement it has in the current document under Location / Locations. Click Refresh to update all of that exploration's placements in the current document at once; click its title to open it and change the query, which applies to every placement.
A placement survives renaming the sheet it's on or the spreadsheet it's in — it's tracked by the sheet's and spreadsheet's own stable ids, not by name. A placement's anchor is a fixed cell reference, though, so it does not survive rows or columns inserted above it: the visible data shifts down with the insert, but the stored anchor doesn't move with it, so the next refresh targets the wrong cell.
<Frame> </Frame>If a report has filters applied, an admin can turn on Show applied filters in reports (Settings → Spreadsheet Add-ins) to make the filter state visible on the sheet itself. When enabled, a summary of active filters is added above the table, and filtered columns are marked "(filtered)" in their header, both when the report is inserted and after Refresh.
You can also manage saved reports in the Saved Reports page in Cube Cloud.