Connect Google Sheets with 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, we are ready to import the spreadsheet into Looker Studio.

Ensure 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.

There are two options to connect Google Sheets with Looker Studio:

1-Aug-19-2024-12-01-42-1945-PM

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



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




3. Select 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).




4. 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.




2-Aug-19-2024-12-01-42-1945-PM

1. Once you've created a query with any of our connectors (remember to select the checkbox "Use format compatible with Looker Studio"!), at the Google Sheets menu, click on Extensions > Looker Studio.

1-Aug-19-2024-12-11-24-6261-PM

2. Once in Looker Studio click on "Create a report".

Connect Google Sheets with Looker Studio


3. A few options will be displayed on the right side, please select the ones you prefer and then click on the "Create" button.

3-Aug-19-2024-12-12-35-4677-PM

4. Done! The connection between Looker Studio and Google Sheets has been established.
You'll be redirected to a new window, where a new report in Looker Studio will be created and it will display the information extracted from the sheets selected in the example graphics.

4-Aug-19-2024-12-13-18-1284-PM

For any error with the Looker Studio dashboard, please contact Google Support as Google Sheets is a Google connector.


As always, please do not hesitate to contact us via our live chat on our website or via e-mail if you still have any doubts or questions. We are happy to help!