Google Sheets Input Tool - Support for Team Drives

[chilito]

Google has recently introduced the concept of Team Drives.

https://gsuite.google.com/learning-center/products/drive/get-started-team-drive/#!/

Team Drives are shared spaces where teams can easily store, search, and access their files anywhere, from any device.

Unlike files in My Drive, files in a Team Drive belong to the team instead of an individual. Even if members leave, the files stay exactly where they are so your team can continue to share information and get work done.

I cannot see the files through the Google Sheets Input tool. I only see files in My Drive.

How do I access Google Sheets placed into Team Drives? Thanks in advance.

Response from Alteryx Support:

Hi Chris,

This is not supported with the current tool. The way that we pull the list of sheets only will pull the personal sheets that the user owns, even if a user creates a sheet in the Team Drive, the owner is not that user but the Team Drive. There are additional parameters that need to be added in order to pull the team drive sheets a user has access to, and we would need to use a different api (Drive API vs Sheets API) for the pull.

Please add this as a suggestion for a future enhancement on our idea center.
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas

Thank you.

--
Angela Ogle | Customer Support Engineer

[nalin]

Has this idea been revisited at all? Would love to finally have support for team drives.

[gregddowns]

Is there an update on this?

This would be a great feature to have available.

[erikpuzon]

Yes, I have the same problem. Any update on this?

[melissa_m]

Anybody knows if this has been addressed?

[VojtechT]

Hi @chilito , there is a new Beta version of the Google Drive tools, which now support Shared Drives as well. Just pick the Shared Drive item in Files to Display option. 

[VojtechT]

The support for Shared Drives has been implemented in Google Drive 1.1.0.