Connecting Google Sheets to Looker Studio

Before we dive into the tutorial, let's understand what Google Sheets and Looker Studio are and why you might want to connect them.

Click here to access the tutorial showing the ways to share reports in Looker Studio.

What is Google Sheets?

Google Sheets is an online spreadsheet tool that allows you to create, edit, and store spreadsheets directly in the cloud. It's a popular alternative to Microsoft Excel and is widely used for data management, analysis, and real-time collaboration.

What is Looker Studio?

Looker Studio is a data analysis platform that offers a variety of tools for visualization, exploration, and sharing of data-based insights. It is a robust solution for businesses seeking to make data-driven decisions.

Why Connect the Two?

Connecting Google Sheets to Looker Studio allows you to take advantage of the best of both worlds: the ease of data manipulation in Google Sheets and the powerful visualization and analysis capabilities of Looker Studio. This is particularly useful for teams that collect data in spreadsheets but need a more advanced tool for analysis and reporting.

Now that we have a clear understanding of what each platform offers, let's move on to the tutorial!

This tutorial will consist of two steps, the first being about how to bring data from the tools to Google Sheets and the final part showing how to connect it to Looker Studio.

Sending data from your tools to Google Sheets with Kondado

1. Registering Your Google Sheets as a Destination in Kondado: First, you need to login to Kondado and register your database as a destination to receive data from your tools. To register your Google Sheets as a destination, follow the step-by-step shown in our documentation.

2. Creating Your Data Sources: Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit our wiki and follow the respective step-by-step instructions.

3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps.

Connecting Google Sheets to Looker Studio

4. Entering Looker Studio: To connect your Google Sheets, which has already received data from Kondado, to Looker Studio, go to https://lookerstudio.google.com/navigation/reporting .

Connecting Google Sheets with Looker Studio:

Click on “Create” in the upper left corner, and choose the “Data Source” option:

Select Google Sheets from the list:

Click on “Authorize” to authorize access to Google Sheets:

Select the spreadsheet created by the Kondado integration, which you want to connect to Looker Studio

Click on “Connect” in the upper right corner:

Done! Now your table will be connected to Looker Studio, where you can create reports and visualizations.