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.

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:

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: