Create Folder List from Box.com to Google Sheet

How To
,
1

Hi,

I am trying to create a list in Google Sheets where I need to document all the folder names that are already created within my Box.com account.

For example - I have 26 main folders (A, B, …, Z) in Box.com, and within each of these folders, I have 100s of Folders. Now, I can manually document each of the Folder names and check what is created and what is not, but this will take too much of my time as there might be 1000+ folders.

Hence, I need to create a Make.com scenario that will fetch folder names and store them in Google Sheets.

2

You might not even need a Make scenario for this one-time operation.

If your Box is synced to your computer,

If you are on MS Windows:

  1. Go to your Box folder in Explorer

  2. Right-click inside the folder and select the context menu option “Open command prompt here”

  3. Type or paste this to list all subfolders recursively:

    dir /s /b /o:gn

(taken from Command to list all files in a folder as well as sub-folders in windows - Stack Overflow)

Hope this helps! Let me know if there are any further questions or issues.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

3

Thanks, @samliew. This works, but my operation is not one time. I have to keep checking the new folder creation and further make decisions on top of that.

That is the reason I wanted to create a Make scenario so that I don’t have to manually do all this.

4

Then the only way is to recursively iterate through each sub-folder and get the list of folders within each folder.

I only have Google Drive examples for the recursive method, feel free to adapt to Box:

Hope this helps! Let me know if there are any further questions or issues.

You can also join us in the Make Fans Discord server to chat with other makers!