Import your Looker data onto a pivot table, then connect it to Geckoboard using our Google Sheets data source.
Connecting to Looker from Google Sheets
Open a new file in Sheets.
In the menu at the top, click Data > Data connectors > Connect to Looker. The first time you connect, you must link your Google and Looker accounts.
Enter the name of your Looker instance or select an instance you recently connected, and click Continue. It may take up to 24 hours for a new Looker instance to be available in Connected Sheets.
Select the Looker model and Explore that you want to use for your query, and click Connect.
Once connected, a new sheet will open showing the structure of the selected Explore.
Adding Looker data to your sheet using pivot tables
From the new sheet showing your Explore, click Pivot Table.
Select whether to insert a new pivot table in either a new sheet or an existing sheet, and click Create.
After the pivot table editor window opens, you can add rows, columns, values, and filters to build your query based on the dimensions and measures in your Looker Explore. Click Add to add a row, column, value, or filter.
The rows, columns, values, and filters in the pivot editor are equivalent to your Looker dimensions and measures in the following ways:
Rows = Looker dimensions.
Columns = Looker pivoted dimensions.
Values = Looker measures. You can create a custom measure by selecting a Looker dimension and a Sheets Summarize by function.
Filters = Looker filters.
Connected Sheets displays a list of the views available in your Explore. Click on a view name to show the list of the dimensions and measures in the view, and then select the field that supplies the data for your row, column, value, or filter. In the case of filters, you'll be able to specify how you want to filter the data on that field:
Once you've added your Looker fields and filters to build your query, click Apply. This will populate your sheet with data from your Looker instance:
Display pivot table data in Geckoboard
Though pivot tables cannot be automatically read from Google Sheets in Geckoboard, you can use ImportRange to copy the pivot table in a new sheet.
Add a new sheet and select a cell.
Use ImportRange on this new sheet to reproduce the pivot table. For this, you'd enter
=IMPORTRANGE([spreadsheet_url], [range_string]), wherespreadsheet_urlis the URL of the Google Sheet andrange_stringis the pivot table sheet name and cell range you want to import.After entering this formula for the first time you'll see the
#REF!error in the sheet. Hover over the cell and click Allow access.Use this new sheet to display your pivot table when connecting your Google Sheet to Geckoboard.