Dropbox — Google Sheets scenario?

Questions
,
3

Hi @Javier_Martinez1 welcome to the Community!

We can definitely help here. There’s two things I think you need to change in your scenario …

  1. When you map the Name field from the Dropbox Watch Files module, that’s going to have the file extension (eg .jpg) at the end. The first column of your sheet doesn’t include the extension, so you’ll need to remove it from the Name when you include it in the filter of the Search Rows module.
  2. The Downloadable field isn’t a sharable link for a Dropbox file - it’s just a true or false value for whether or not it is downloadable. To get the link, you need an additional module.

To solve the first problem, you’ll need to use Make functions (you can find details on these in the help). There are several ways you could do this - I’d use the indexof() function to find the position of the “.” and then the substring() function to extract the part before the dot, like this:

image

For the second problem, you need to insert a Dropbox Create/Update a Share Link module after the Watch Files module. Set the Way of selecting files to Map a file/folder path and map the Path lower output field from the Watch Files module, like this:

image
image628×530 31 KB

Lastly, map the downloadUrl output field from the Create/Update a Share Link module as the Value field in your Google Sheets Update a Cell module.

Let us know how you get on!