community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Google Sheets Input Tool - Support for Team Drives

Google has recently introduced the concept of Team Drives.
 
 
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
1 Comment
Atom

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