Cube Cloud for Sheets

After configuring, installing, and authenticating this add-on, you will be able to create reports via pivot table and work with saved reports.

​

Configuration

Cube Cloud for Sheets uses the SQL API internally. So, the SQL API has to be enabled in the Cube Cloud deployment settings.

​

Installation

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: 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:

​

Authentication

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. 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.

​

Create reports via pivot table

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. 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. 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. 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. When your report is ready, you can optionally move it to saved reports by clicking Save.

​

Work with saved reports

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. Click Refresh to manually refresh the data in the report’s location. Click Edit to change the query or the location. 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.

​

Number formatting

A measure’s format from the data model — including abbr (compact notation, e.g. 1.2M) — is applied as a native spreadsheet number format, so the cell keeps its numeric value and stays usable in SUM, pivots, and charts. To pin every measure column in a report to a fixed magnitude regardless of the data model’s format, open the sidebar’s Display tab and set Scale to Model default, Absolute, Thousands (K), Millions (M), or Billions (B). The setting is session-local to the current report.