Refresh Files on time trigger for new File Cabinet Add-on
When using the new File Cabinet add-on, have a way to update the files in the file cabinet automatically, (time based e.g. every X hours).
Andrew Brown commented
Due to the time limitation of Google script. Is it possible to perform one step at a time then have a trigger for each step. This way it breaks down the task.
Step 1 - Get list of folders - store in a sheet
Step 2 - Get list of files in each folder - store in a sheet
Step 3 - Update main spreadsheet etc