Our company has been having an issue for over a month in which no one is able to add any Google Sheets as a data source in Looker Studio.
Initially we couldn't even see our sheets, however, we've since found that setting a filter does get our sheets to display and be selectable, but then we are never given the option to select a Worksheet and therefore cannot complete the Connect/Add function.
I can share screenshots or link a video of the fault if that would be of any help.
Any help would be greatly appreciated as this matter has become urgent for us.
Many thanks,
Stefan