Skip to main content

Hello! I’m hoping someone has some solves for the workflow I’m trying to create.

I need to pull the shared links from a Box folder (that will change depending on the project that initiates the automation) into a Google Sheet. Whether it’s 2 files in the folder or 50, each shared link should be given a line, and ideally the information on the other lines automatically fills in with the same information as the first line (so that the only thing different for each row is the shared link for the different files).

Also, is there a way to find a folder based on the Folder ID from the URL? After testing, Zapier still gives me an error in finding the folder.

I’m fairly new to Zapier, and I’m not finding this functionality anywhere, but I’m hoping there’s some kind of way.

Hi @LynzD3nik, welcome to the Community! 🎉 

I need to pull the shared links from a Box folder (that will change depending on the project that initiates the automation) into a Google Sheet. Whether it’s 2 files in the folder or 50, each shared link should be given a line, and ideally the information on the other lines automatically fills in with the same information as the first line (so that the only thing different for each row is the shared link for the different files).

The current Find a Folder action would not list the files it contains, it only returns the details of the folder. I’m not seeing any such action available so I’d suggest contacting our Support team to submit a new feature request for that to be added. You can do that here: https://zapier.com/app/get-help

That said, looking at Box’s API documentation the List items in folder endpoint provides a list of the files within it as well as the share links. It looks like their API supports basic authentication methods so you could potentially use Webhooks to make a request to that List items in folder endpoint to retrieve the shared file links for each file. It’s a bit more advanced but we have a general guide on how to set up a webhooks action that you might find useful on that: Send webhooks in Zaps

 

Also, is there a way to find a folder based on the Folder ID from the URL? After testing, Zapier still gives me an error in finding the folder.

The Find a Folder action can only search by name but, the List items in folder endpoint I mentioned above requires the ID of the folder not it’s name so if you used that endpoint to find the folder it would indeed be possible to search for the folder by it’s ID.

Hope that helps to get you pointed in the right direction. If I’ve misunderstood what you’re looking to do or you run into any trouble setting up that webhook just let us know and we’ll be happy to advise further! 🙂