Visualizing Google Sheets in Looker Studio Using These Tips

JJ teaches you how to visualize Google Sheets Data using Looker Studio. Are you asking the right questions?

👇 Grab The Dashboard Cheat Sheet 👇

👇Start Exploring Your Marketing Teams Data👇

0:00 - Intro
0:24 - Download the LookerStudio.VIP CheatSsheet
0:37 - What Are You Trying To Accomplish?
1:56 - Adding Data to Looker Studio
6:06 - What Questions Are We Trying to Answer?
10:50 - Trends Over Time
11:37 - Utilizing Filters and Controls
13:05 - Calculated Fields
14:49 - Stacked Column Charts
17:25 - Wrap Up
Learn On Your Own!

[ses-ub]

I watched several videos on this topic and yours was the best by far. I finally made some progress! Thank you!

[eliasgomez]

Recently i started working with looker studio and spreadsheet, this is awesome thank you :)

[emilharden]

Great info...thanks for digging into the "optional range" feature of connecting to the data source.

[iancarr]

Thanks. Very helpful. How would I sort the "Transaction Date" column in your example, please?

[startplo]

Great video, very good explanation. Thanks a lot 👍

[circlepitt]

thank you so much for the introduction 🔥

[Anomander_Fake]

Very helpful video, thanks for making it

[DianeWhitehouseCoach]

Great Video, thank you so much. My question is, I'm creating a report for each grade level. I want the same information and just change the filter to change grade levels. what I am doing re connecting the same google sheet data for each page. Then I have to Drag and drop the fields to recreate my table and charts. Am I missing something? Each page needs a new set of data? Thank you so much..

[sarasalgado]

Can I create scorecards with the amount of the current year and then use the comparison value feature to compare it with the previous year?

I've been trying to create this by using the data in the same table, but it doesn't work. If I create the scorecard, it sums everything from every year, and if I filter the scorecard, then I can't compare it with the previous year as it's excluding that data. What do to there? Or which other widget can I use to visualize the % increase between one year and the other?

[joshuaogudu]

I updated my google sheet but the Looker Studio dashboard is not updating. what could be wrong?

[brittanitaylor]

I am trying to create a searchable company directory. I tried different controls but can't figure out how to allow the user to search without case sensitivity. Any suggestions?

[ATULRAI]

Hey JJ, thank you for the explanation. It was quite easy to understand. I am having trouble with a Google Sheet with several worksheets and formula behind it. The worksheets header does not start from 1st row of the sheet. The header of one table starts from 4th row and after 9th row there is some text and then another table and its respective header. Both tables are in same sheet. Similar tables in other worksheets as well. All the cells have different formula behind it. How can I import import such sheets in Looker studio along with its formula. Could you please help me?
Thank you.

[cintyadewi]

Hey thanks for the video, I have created a dynamic database in google sheet, which everyday user input data to it. It also contain formula that I used to give label each row. Can I connect a dynamic and formula contained google sheet to looker studio?

[valeria-flexfire]

Hey! Great video. I am having toubles adding data from my Sheets, since those have the data transposed, and have not found the way to make Looker Studio to take them. Any suggestions? 😅

[franciscomonterroso]

Cool video. I like Looker Studio but have an annoying problem with Google Sheets. Why can't I upload Excel files (which automatically convert to Google Sheets with that option in Settings) to the folder where my Google Sheets reside without any changes to the report? People at Google recommend making changes directly in the Google Sheets, but this is not convenient when a report is based on several of these sheets. I thought it would be so easy to just replace the Google Sheets and reconnect, but no, it is not that simple. Any recommendations?

[milimann]

Hi JJ! maybe you can help me with this situation. I have problems with the data sources. I have a report for company A that pulls data from their Analytics account and a googlesheet for company-A. Today, I have "made a copy" this report (using that feature) to make a similar for company B but with the data of company B (of course ;) using a different analytics and a different googlesheet. The problem that I have now is that the report A is using the data sources of company B. Have you had this problem? How do I "unlink" this situation so they are independent regarless of the changes I do in each of them? Or how should I do this duplication process correctly? I hope my explanation was clear. thanks in advance!

[ChotaMusonda]

Hey man, failed to access my google sheets docs from my drive? Any help

[barrenwuffethq]

Hey! Can you create a video where you show. How to take google sheets and send it looker studio and recreate the type of visual presentation you are showcasing in your cheatsheets. A step by step tutorial. Just something simple so the workflow becomes clear.

[marketingplanformula]

Hey love it, you have a 404 on your leadmagnet tho

[rajeshpatil]

Hi I have 3 lakh record how can I load that google sheet in gds