Reading a Google sheet from a Shared Drive

[ChadTibbets]

I cannot see my shared sheets from a my shared drives. Any thoughts? I tried the Google Drive Connector and File Reader, but the File reader cannot read a google sheet. Also, I cannot connect the google sheets reader to the google drive connector output. Thanks for your help!!

[ScottF]

Hi @ChadTibbets -

There is a workaround posted in the end of this thread that you might try:

Connecting to Google Sheets in Shared Drives

Problem: Unable to access Google sheets in Shared drives This has been posted multiple times in the forum before but all closed without a proper resolution. One of the main issues not understood in the previous topics raised is the confusion of what a Shared drive is, hence also confusion on how to address it. This is what it looks like: [Screen Shot 2023-05-10 at 1.42.19 PM] As you can see the files under Shared drives are not exactly the same as the files that are shared directly by one …

[marcellusmontilla]

Hi @ScottF,

That post was more than 2 years ago.
Any updates on this issue? (AP-11391)

[ScottF]

This is a popular topic lately - someone just asked a few days back:

Google Drive Shared Folders

Hello @BorovikDI and welcome to the forum. I just checked the ticket and don’t have anything new to report, sorry about that. I’ve added you as a +1 on that ticket though.

Sorry to not have a more satisfying response, but the more people ask, the more likely the devs are to make room for it. I’ll add a +1 from you on the ticket as well.