Before we dive into the tutorial, let's understand what Google Sheets and Looker Studio are and why you might want to connect them.
What is Google Sheets?
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
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
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.