Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Google Sheets Data Sources

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi 

 

First time playing with data studio and so far it looks great. 

 

I am trying to add a google sheet I have in my Gdrive but when I go to add it, it says there isnt and spreadsheets for this user. When I use url or the open from google drive it shows the name of the sheet but it greyed out. Is there an allow setting I've missed?

 

TIA

 

Craig

Re: Google Sheets Data Sources

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭
Hi Greg.

I'm having trouble with this as well.
Hopefully someone can provide info that will help.

Google Sheets Data Sources

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I also showed "no spreadsheets" in my Drive folder, and "connect" was greyed out trying to manually add a sheet from Drive.


I switched data sources to "Google Analytics," it checked my credentials, and when I switched back to Google Sheets, it now saw the contents of my Drive, and I connected a sheet.


Hope this helps!

Google Sheets Data Sources

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Do you have read only access? Not sure if that would make a difference but worth looking in to if you haven't already.

Google Sheets Data Sources

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

I have full access.

Google Sheets Data Sources

Follower ✭ ✭ ☆
# 6
Follower ✭ ✭ ☆

If you cannot get your account to connect for some reason, you might want to try making a public link and copy-pasting that link in the Sheets URL connection option.