3K members online now
Ask questions about Data Studio
Guide Me
favorite_border
Reply

Data Studio and Google Sheets

Level 5
# 1
Level 5

Importing data from Google Sheets, is it only certain data that can be pulled into data studio?

 

I would like to add just text to the page but it's not recognizing the content from the table. The headers are appearing in GDS. Can anyone help on how I can do that? TIA

1 Expert replyverified_user

Data Studio and Google Sheets

Google Employee
# 2
Google Employee

Hi Beth -- you should be able to pull just about any type of data from a Google Sheet into a Data Studio report.

 

Would you be able to share the Sheet with data-studio-help@google.com? We'd be able to troubleshoot from there. You can anonymize or truncate the data if it is sensitive. Thanks!

Data Studio and Google Sheets

Level 5
# 3
Level 5

Hi Alon, I am also having some issues with importing data from Google Sheets. Any chance you have an example of a sheet, which I can copy? My issue is about not finding the dimensions / metrics I have. 

Data Studio and Google Sheets

Google Employee
# 4
Google Employee

@Dick R: I'm not sure I fully understand your question, but can you use this template? It's a super Sheet -- save it to your drive and create a Data Studio report off of it. If you are having problems here please share screenshots and I'll troubleshoot. Thanks!

Data Studio and Google Sheets

Level 5
# 5
Level 5

When starting the creation of a new data source in Data Studio and Google Sheets, I do not see the Create report button.
Would appreciate if there are limitations to the BETA version.

Best regards @andabi

Re: Data Studio and Google Sheets

Level 5
# 6
Level 5

 Data Studio and Google Sheets andabi.jpg

Create Report Botton does not appear???

Data Studio and Google Sheets

Google Employee
# 7
Google Employee

@Nicolas Julio V and @Dick R: we fixed a handful of related issues last night. Can you please let me know if you are still seeing problems? Thanks!

Data Studio and Google Sheets

Level 5
# 8
Level 5

Hi Alon, thanks! Just a quick follow up question. I am using the table below. 

So I have 1 dimension (week) and 7 metrics. I dont succeed in getting all the metrics in a graph. I can only put in max 5. How would you solve this to get this for example in a Pie chart? To make it concrete: a pie chart for week 43 with the different contact methods. 

 

Week Chat Whatsapp Email Facebook Outbound Email Phone Total
43 1 0 15 0 10 33 59
44 12 2 22 0 7 44 87
45 9 3 22 2 5 45 86
46 10 0 22 0 9 48 89
47 12 1 14 0 7 72 106
48 10 1 14 0 8 67 100
49 14 1 40 0 5 85 145
50 315 1 85 0 27 67 495
51 164 0 84 0 26 98 372
52 74 2 65 0 4 41 186
1 153 6 86 0 10 69 324
2 242 4 60 2 16 74 398
3 266 2 54 0 18 77 417
4 266 2 54 0 18 77 417

Data Studio and Google Sheets

Google Employee
# 9
Google Employee

@Dick R: to make sure I answer this correctly could you please share the report you are working on with data-studio-help@google.com? I'll be able to better understand the issue once I see the actual data and report. Thanks!

Data Studio and Google Sheets

Level 5
# 10
Level 5

Thanks Alon. Shared it with you. Also have some issues with the dimension (week), you will see in the dashboard. Thanks for your help! 

 

Experts in the Topic
Alon G