Skip to main content

We use Jira to log and track all of our current design projects, and an impediment in our workflow is having to leave Jira to go find the design files in Dropbox. We have an assistant that posts comments to Jira when new files are uploaded to Dropbox, along with a link to the DB folder, but she spends a good chunk of her day on that. If we had a way to have Zapier post the comment when the file is uploaded, that would be a huge boost for her, and the team as a result.

What I’m having trouble figuring out is how to get DB to find the name of the folder on the matching Jira task.

Hi @SgtSavage67 

For us to have more info, outline a specific example for us.


Certainly!

 

This is what we currently do:

  • Our assistant receives an email from an architect, and there is an attached file (a new architectural drawing we need to review).
  • She uploads the file into a dropbox folder called “ArchInfo”
    • In our use-case, all of our files of this type go into a sub-folder named “ArchInfo”, in a parent folder with a name that matches our Job-naming scheme for our company (this is relevant later). For this example, we’ll call it: 24-099-SMITH-RW
  • She then goes and copies a link to the “ArchInfo” folder and pastes it into a comment in the corresponding job’s task in Jira (24-099-SMITH-RW), usually along with the body of the email that came with the attachment.
  • Posting this comment will notify the Project Manager of the job in question, so they know new info has dropped.

What we want to do:

  • When our assistant uploads the file to Dropbox, we want Zapier to do the following:
    • See the upload in the 24-099-SMITH-RW > ArchInfo folder
    • Post a comment to the Jira task (24-099-SMITH-RW) with a link to that ArchInfo folder included.

I’m also open to other suggestions for a different workaround.


@SgtSavage67 

Try these Zap steps:

  1. Trigger: Dropbox - New File in Folder
  2. Action: Jira - Find Issue / Jira - Find Issue (via JQL)
  3. Action: Jira - Add Comment to Issue
    1. Map the ID of the Issue from Step 2

 

NOTES:

  • You’d need a separate Zap per ArchInfo subfolder to watch
  • OR
  • You’d need a main ArchInfo folder where all files are added, then the Zap would need logic to find the corresponding ArchInfo subfolder and move the File, as well as do the Jira Comment