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 Google 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.
A new Looker instance may not be available in Connected Sheets for up to 24 hours.
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; created 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 and you can 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 on your dashboard
Learn how to display the pivot table data on your dashboard with the steps in this guide.