Learn how to make the most out of the Dropbox Community here 💙.
Forum Discussion
Solved
Dropbox File shared links bulk export
I have a folder which contains over 400 images, is there any tool to copy all these images' Dropbox links in Excel one time instead of one by one?
I suggest you enable your PUBLIC folder, then load the files into a subfolder say \dropbox\public\images\example.jpg
Once done you can get your NEVER CHANGING public folder link for \dropbox\public ( looks something like https://dl.dropboxusercontent.com/u/12345678 )
And simply append the subfolder and filenames to it https://dl.dropboxusercontent.com/u/12345678/images/example.jpg
.
Only thing to be careful of is if the subfolder or the filenames require web path conversions (spaces and od characters in the names etc)
I've been looking for this with folders (not individual images, although it works with that), and THERE IS AN EASIER WAY!!
Zapier is an if this than that type automation program.
Make a zap and connect your dropbox account and excel
Step 1: Dropbox trigger: Either trigger for when a directory is created or a file is created.
---> there are multiple ways to handle the rest, I have a specific need to distribute to others so I did it like this:
Step 2: Find Row: In the linked excel document, we wanted all folders to be named/distributed by e-mail address so all our folders were named by their e-mail address and we found that row
Step 3: Update Row: One of the fields you can populate to excel is Dropbox link... I had a column that I named "Dropbox link" and populated it there.
Hope this helped!
