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

Data Studio not seeing worksheets in GoogleSheets

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

A report we are using via Data Studio has completely broken this last week and I've been unable to resolve. I assumed since all fields broke it was an issue connecting to the data source (which is a Google Spreadsheet). When I went to edit the connection, when selecting the spreadsheet, it says that "There are no worksheets available in this spreadsheet." when in fact there are multiple.

 

What may have happened to cause Data Studio to not see the worksheets in the spreadsheet?

Data Studio not seeing worksheets in GoogleSheets

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Brett,

 

I am having the same issue. Can someone please help?

Data Studio not seeing worksheets in GoogleSheets

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Same Here, Is there any valid reason for that !

Data Studio not seeing worksheets in GoogleSheets

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I am also having this problem.

Re: Data Studio not seeing worksheets in GoogleSheets

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

I'm experiencing the same problem, Data studio will not recognise my Google Sheets even though I've authorised it several times. Would love any help with resolving this issue.  Thanks! 

Data Studio not seeing worksheets in GoogleSheets

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

+1

 

- A Google Sheet connects fine with all its worksheets.

- I make a copy of the Sheet and modify a few calculations inside

 

When I try to add a data source the COPY of the connected sheet, then none of its worksheets are shown.

 

What's the solution?