Extract all the Files From Drive Folder path

Hello Team,

How do we extract the Files Present in Google Drive

Example =
1)There is a Folder Automation_Drive
2)Automation Drive Contains HRDept.xlsx , SalesDept.xlsx

How do we extract file HRDept.xlsx , SalesDept.xlsx for reading the sheets present in them

At the moment have tried below approach
1)Used Find file/Folder and provided id of Automation_Drive
2)Then used For each activity but that just extracted file id for one file(HRDept.xlsx)

Kindly provide your suggestions to perform the activity

Thanks Team in advance

  1. Get File/Folder List
  2. Iterate through this List and use “Download File”-Activity
  3. with currentItem.LocalPath you can locate your file, open and search for your needed sheets.

if you dont want to delete the files afterwards, just download them into temporary folder.
it will delete those files automatically later.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.