Google Drive Workflow

Question

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?

ak2018 · Answer

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.

all-tricks · Answer

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

echuong1 · Answer

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