Learn how to use Google Sheets as a data source to make awesome PPC reports in Google Looker Studio.

In this article you can see how to connect your Dataslayer queries with Google Looker Studio in a few simple steps!

Once a query has been made in Google Sheets with Dataslayer.ai, go to Looker Studio to import the spreadsheet where the query is.

Make sure you have selected the option "Use format compatible with Looker Studio" to avoid errors when using your query in Looker. Learn more about query options in Google Sheets here.

How to connect Google Sheets with Looker Studio

Create a new dashboard on Looker Studio and add Google Sheet as a connector.

Google Sheets is a Google connector, for any error with the dashboard in Looker Studio you should contact Google Support.



Authorize the connector with the same account you have created your query in Google Sheets.



Selected the spreadsheet and the worksheet where the query is located and click on Add.

If you want to add more than one query to Looker, each query must be on a separate worksheet (you cannot put two queries on the same worksheet).



Done! Now you can work on Looker Studio and create a more visual PPC report with the data of your query on Google Sheets.



Google Sheets is a Google connector, for any error with the dashboard in Looker Studio you should contact Google Support.

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!

Updated on: 29/02/2024