How to find and download latest file in Google drive

[Henson_Ibon]

Need help. Need to download the latest file from google drive which is always changing/updating daily with new folders but the filename always contains ALL STATUS

[anon87560229]

Hi Users,
we can use DOWNLOAD FILE activity from gsuite application package
and file id can be obtained from with FIND FILE AND FOLDERS ACTIVITY in the same gsuite package whose output is a FILE IDfrom property FEELINGLUCKY with a variable of type string

happy Automation…!!!

[Henson_Ibon]

When I try to use the find files/folder activity it will not output the file id of the latest version of the file.

[Rahul_S (Robot_L)]

Hi @Henson_Ibon

Please find attached solution. Provide GSuite configurations as per your requirement.

GetLastModifiedFile.xaml (12.2 KB)

GSuite version 1.11.0

Hope it will help you.

[Henson_Ibon]

thanks for this. downloaded the file but there was an error when I tried to debug the code.

here is the error encountered.

[Rahul_S (Robot_L)]

Hi @Henson_Ibon

Your datatable is empty.

Check in local panel if your datatable has got any values.

You need to provide folderID in search.

[Henson_Ibon]

Folder ID is already provided but still encountering error.

[Henson_Ibon]

Hi @Rahul_S ,

The code work but unfortunately it will only access a particular folder. I want to use the parent folder since the subfolders will update the next day. It will create a new folder daily.

[Parth_Doshi]

Here there multiple search expression that you could use try if it helps: Search for files and folders  |  Google Drive  |  Google Developers.