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?

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.

Connect Google Sheets to Looker Studio

Send data into a Google Sheet via Kondado and visualize it in Looker Studio.

Register Google Sheets as a Kondado destination

Create pipelines from your sources

Add the data sources you need (ads, CRM, e-commerce, etc.) and build pipelines that send their data into the Google Sheets destination at the frequency you choose.

Open Looker Studio and add a Google Sheets source

Go to <a href="https://lookerstudio.google.com/">Looker Studio, click Create > Data source, select Google Sheets, and authorize access.

Pick the spreadsheet and worksheet

Select the spreadsheet Kondado is updating and the specific worksheet/tab you want to use, confirm the field types, and click Connect.

Build the report

Drag fields onto the Looker Studio canvas to create charts, tables, and filters. Share the report with stakeholders — see more data-to-dashboard options.

Frequently asked questions

What is Google Sheets and why is it commonly used for data management?▼

Google Sheets is an online spreadsheet tool that allows you to create, edit, and store spreadsheets directly in the cloud. It is a popular alternative to Microsoft Excel and is widely used for data management, analysis, and real-time collaboration, making it ideal for teams that need flexible data manipulation before connecting to data visualization platforms.

What is Looker Studio and what does it offer for business intelligence?▼

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, and you can explore more about how it fits into your analytics workflow on our data-to-dashboards page.

Why should I connect Google Sheets to Looker Studio instead of using them separately?▼

How do I register Google Sheets as a destination in Kondado to receive data from my tools?▼

First, you need to login to Kondado and register your Google Sheets as a destination to receive data from your tools. Follow the step-by-step shown in Kondado's documentation to complete this registration before creating your data sources and integrations.

What are the exact steps to connect a Google Sheets spreadsheet to Looker Studio after it has received Kondado data?▼

Go to https://lookerstudio.google.com/navigation/reporting, click on 'Create' in the upper left corner and choose 'Data Source', select Google Sheets from the list, click 'Authorize' to grant access, select the spreadsheet created by the Kondado integration, and click 'Connect' in the upper right corner. Your table will then be connected to Looker Studio for reporting and visualizations.

Can I use Kondado to send data from multiple tools into the same Google Sheets destination before visualizing in Looker Studio?▼

Yes. In Kondado, you can register multiple data sources (such as CRM, ads, e-commerce, or databases) and create integrations that centralize all that data into your registered Google Sheets destination. Once centralized, you can connect that single spreadsheet to Looker Studio for unified reporting and analysis.

Written by

Thassyo Pereira·Published 2023-11-13·Updated 2026-04-26