Google Drive Workflow

[cmholls84]

I have a Google Drive folder where monthly reconciliation files are stored. Right now I'm manually pulling the new monthly file each month into the workflow. I was wondering if there was a way for Alteryx to look in the Google Drive folder for the newest file and automatically pull it in? 

[Qiu]

@cmholls84 
Dont have any expirience with Google Drive, but I think this will help.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Google-Drive-Sheets-API-Setup/td-p/671...

[echuong1]

If you download Google Drive File Stream, you can essentially map your Google Drive to your network folders. Then, you can connect to it just as you would any other folder on your computer.

https://support.google.com/drive/answer/7329379?hl=en 

[all-tricks]

Hi there,

thanks for this idea.
Likely working well on a private computer.

I can not think of being able to install this tool in an enterprise environment.

Usually this tool is considered to be a security concern.

Best

rp

[ak2018]

so here is my challenge. This will work awesome on the desktop. However, when I move it to the server, the OS profile used to log into that server will not have access to the drives and hence the Google Drive connector installed will not have those folders. How can we work around that? So far I see only My Drive possibility from Google Drive Tool in Alteryx. Using my own credentials or with a client ID and client secret linked to my ID still has issues even getting to the Shared Drives that I get as part of a team. Any help is appreciated.