Google Drive Input - Connect to Latest File within a folder

Question

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!

filbram · Answer

Unfortunately, yes that is correct.

apathetichell · Answer

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-windows

They need to get out of their own way.

filbram · Answer

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.