In this article, you can see how to connect your Dataslayer queries with Looker Studio in a few simple steps
Want to turn your marketing data into insightful dashboards?
With Dataslayer, you can easily create queries in Google Sheets or Microsoft Excel and connect them to Looker Studio for powerful, visual reporting.
In this guide, we’ll walk you through how to integrate your spreadsheet data with Looker Studio in just a few clicks!
When creating your Dataslayer queries, make sure to check the option "Use format compatible with Looker Studio" to avoid errors during integration.
Learn more about query options here.
If you prefer a faster method, you can try using Dataslayer’s connectors in Looker Studio to connect your data sources directly—no spreadsheets required!
To connect an Excel file to Looker Studio, you can easily follow these steps:
1. Create a new report in Looker Studio and select Microsoft Excel as the data source.
2. Upload your Excel file (.xlsx or .xls) when prompted.
3. Once uploaded, choose the worksheets you want to include and configure any necessary options. Click on "Add".
4. Done! You’ll now see the Setup section showing where your data is being pulled from.
Microsoft Excel is a native Google connector; for any error with the dashboard in Looker Studio, you should contact Google Support.
There are two methods to connect Google Sheets to Looker Studio:
3. Select the spreadsheet and the worksheet where the query is located. Review and check the options needed 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. That’s it! Now you can start building a visual PPC report using the data from your Google Sheets queries.
Google Sheets is a native Google connector; for any error with the dashboard in Looker Studio, you should contact Google Support.
1. After creating your query (don’t forget to enable the "Use format compatible with Looker Studio" option), go to the Google Sheets menu and click on Extensions > Looker Studio.
2. Once in Looker Studio option click on "Create a report".
3. A few options will be displayed on the right side, please select the ones you prefer and then click on the "Create" button.
4. Done! A new Looker Studio report will open, displaying the data pulled from your selected sheets in prebuilt charts.
Google Sheets is a native Google connector; for any error with the dashboard in Looker Studio, you should contact Google Support.
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!