Google Team Drive

Question

Hey community!

I haven't found this topic yet, so let me post it :)

We would like to manage our google sheets in the team drive and not couple our sheets to a personal account. So what I'd like to do is use a service account to manage all the google sheets written by Alteryx and put them in the appropriate team drive. Can anyone help me by telling me whether this is possible with Alteryx and so yes, how to set it up?

A clever workaround is also appreciated, as long as it doesn't require a personal account, the whole idea is to make it person independent.

If there is a post on this topic (team drive) somewhere on the forum, I would also appreciate a link to that post ;)

ak2018 · Answer

I understand that is a smart workaround. I am trying this out with a client ID and Client Secret that is assigned to me (so I don't have to verify every darn time), but when I swap out the FOLDER ID with the ID of the folder from google drive that I want to use and have access to, I do not see anything. It doesn't give any error but blank stuff. a nice guid would be awesome.

RichardB · Answer

If you activate the "Display XML in Properties Window" under Options > User Settings > Edit User Setting > Advanced (tab) it is possible to manually enter all the configuration parameters. If the credentials you're using has access to the spreadsheet in Team Drive, you can just paste the workbookID and you will be able to use it as input.

rpaugh · Answer

Hello everyone,

This is not the most elegant solution, but try wrapping your Google Input/Output (in the example below I'm using Input) in a macro and pass in the appropriate credentials, workbook ID, and worksheet name:

Even though the Google Sheets Input tool is specifically designed for Sheets only and not Drive (Drive is actually a completely different API), when you pass in the appropriate credentials and worksheet ID it can properly access a Google document located in a Team Drive (I've not tested this with non-Google documents).  And the credentials don't have to be specific Team Drive credentials - they can be any credentials associated with an account that has permission to the Team Drive.

Above is a current production example I'm using so I know it works.  However, I've not tried  it with a Google Sheets output so I'm not 100% positive it will write out the sheet correctly, but based on what I've seen it should work.  Any outputs would just have to include the appropriate write option for the workbook/worksheet.