Google Drive Input - Connect to Latest File within a folder

[filbram]

Hello Community,

I am connecting to xlsx files within a google drive folder that is replaced each day with a new file with the same name (previous days file is removed). Unfortunately, when I connect to the xlsx file the Google Drive Input tool keeps that unique connection and doesn't connect to the new file since it would technically have a new google path. Does anyone know if the Google Drive Input tool has the ability to connect to the latest file on Google Drive within a folder? 

Appreciate any feedback!

[apathetichell]

If this is local/Designer -> map your gdrive to g:. use a standard directory tool to pull in the latest file. use a batch macro to input your file

[filbram]

Thank you for this option. Unfortunately our IT does not allow mapping the google drive to our desktop in order to use the directory tool.

[apathetichell]

I get that there are shops which don't allow Google Drive -> but your team allows Google Drive but won't allow the Windows app? https://support.google.com/drive/answer/10838124?hl=en#zippy=%2Cinstall-set-up-drive-for-desktop-for...

They need to get out of their own way.

[filbram]

Unfortunately, yes that is correct.