Connected Sheets for Looker lets users interactively explore data from LookML models through the familiar Google Sheets spreadsheet interface. Two new features have now been added to enable connecting to a saved Look, and API support.
Connect to Look
Connect to Look enables you to bring data from an existing Look into your Google Sheet. Now you can choose whether you want to build a query from scratch directly in Sheets (Connect to Explore), or just reference an already existing query that has been saved in a Look (Connect to Look).
To get started, open the Google Sheets Data menu, select Data Connectors and then select Connect to Looker. Choose Connect to Look, then search and select the Look you would like to add.
Connected Sheets API Support
API support for Connected Sheets for Looker is now accessible through both AppsScript and Google Sheets APIs.
Some of the things you can do programmatically with API support include the following:
- Automated data refresh: You can schedule regular updates to your Looker-powered spreadsheets to ensure that you’re using the latest information.
- Custom workflows: You can build complex processes that incorporate Looker data into your existing Google Sheets workflows.
- Integration with other applications: You can connect Looker data to external tools and services using AppsScript or Google Sheets APIs.
- To specify Looker as a data source with the Google Sheets API, use the looker object with the DataSourceSpec REST resource.
To get started with Connected Sheets for Looker, check out our documentation page.