In 2020, we introduced Connected Sheets on Google Sheets, to help you analyze, visualize, and share billions of rows of data from your spreadsheets. Since then, we’ve made numerous improvements to the feature, including the recent announcement that you can now explore Google Cloud hosted Looker instances using Connected Sheets.
Today, we’re expanding upon this by making Connected Sheets available for Looker instances hosted on non-Google Cloud providers like AWS and Azure.
- In order for users to take advantage of this feature, make sure Connected Sheets for Looker is enabled in Looker's Admin menu.
- Visit the Help Center to learn more about using Connected Sheets in your organization.
- End users:
- If enabled by your admin, follow these steps to explore Looker data using Connected Sheets:
- In a Google Sheet navigate to “Data” > “Data connectors” > “Connect to Looker” > enter in the URL of a Looker instance, for example: https://example.looker.com. You will then need to authorize Sheets to access your Looker data. After you connect to an Explore, you can see the available data and continue your analysis in Google Sheets.
- Visit the Help Center to learn more about Connected Sheets for Looker.
- This feature is available now for all users.
- Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits
- Not available legacy G Suite Basic and Business customers
- Available to users with personal Google Accounts
- Google Workspace Admin Help: Use Connected Sheets in your organization
- Google Cloud: Connected Sheets for Looker is now generally available
- Google Workspace Updates Blog: Explore Google Cloud hosted Looker instances using Connected Sheets
- Google Help: Using Connected Sheets for Looker
- Google Help: Get started with Connected Sheets for Looker
- Google Cloud: Get started with Looker