Infrastructure Modernization

Analyze Looker-modeled data through Google Sheets

Data Summit 2022

At Google Cloud, we believe that democratizing access to fresh, consistent, enterprise data is the key to driving digital and cultural transformation. This means empowering everyone to leverage rich, governed data sets and harness the power of data -- without learning new tools or building specialized skills. This is why we are excited to provide broader access to Looker’s new integration with Google Sheets. Connected Sheets for Looker brings modeled, trusted data into the familiar spreadsheet interface, enabling users to work in a way that is comfortable and convenient. And now, we’re making this integration more broadly available to eligible Looker customers with an Enterprise Workspace license on an opt in basis.

Better Together: Looker + Google Sheets

Looker’s platform offers a unified semantic modeling layer that works within Looker and through Google Sheets to enable collaborative, ad-hoc analysis of cloud data sources. This means that you can centrally define the metrics needed to understand your business, and take advantage of the scale and freshness of data in the cloud, while still empowering users to access that governed, trusted data. And leveraging Looker’s authentication and access mechanisms means data availability doesn’t come at the expense of security.

Connected Sheets for Looker brings connectivity between Google Sheets and  the 60+ data sources available within Looker’s open ecosystem. This integration creates a live connection between Looker and Sheets, so that 1) your data is always up to date, and 2) access is secured based on the user exploring the data. Users can flexibly analyze consistent data from a single source of truth using pivot tables, charts, and formulas, and even integrate other data sources for deeper analysis.

Connected Sheets.gif

Whether using the Looker UI or accessing data through Google Sheets, everyone throughout your organization can quickly derive consistent, governed insights with no specialized SQL skills required. Exploring data, obtaining valuable insights, and sharing those findings has never been easier.

Several customers have already experienced the benefits of using Connected Sheets for Looker. Mercado Libre, the largest online commerce and payments ecosystem in Latin America, is using this integration as part of their efforts to build an inclusive and impactful data culture across many locations. Jorge Vidaurre, Sr. Digital Analytics Engineer at Mercado Libre says, “All the use cases you can solve with Looker and different Google products like Firebase, BigQuery, Cloud SQL… and now Google Sheets. It blows my mind. We can offer this to someone that doesn’t know anything about data and they will have the same power as analysts and that’s awesome.”

Building a Data Culture

Because Looker’s semantic model standardizes common metrics and definitions for business users, data teams can remove silos and safely democratize access to governed and secure data. Connected Sheets for Looker creates a familiar data access point for users through the Google Sheets interface that has a low barrier for entry into the data ecosystem.  This means putting usable, reliable information into the hands of more people. 

Connected Sheets for Looker aims to make it as easy as possible for everyone in an organization to confidently use data in their day-to-day work. Data is most helpful when people have the ability to derive insights and take action that make it valuable. With Connected Sheets for Looker, more people in your organization can use data to make decisions that drive efficiency, innovation, and growth. This ability to easily access and operationalize data is what fuels digital and cultural transformation. Opt in to confirm your eligibility and start using Connected Sheets for Looker to help drive your own digital transformation.