Importing attachments stored in Google Drive into Jira Cloud using CSV External System Importer


Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.

Summary

To import attachments into Jira Cloud, the attachments can be located anywhere that your Jira Cloud site can access.

Solution


In order to make this work, the files need to be publicly accessible just before beginning import. Once the import is finished, remove public access to the files.

The Attachment column in the CSV file should follow this syntax :

Attachment
https://drive.google.com/uc?export=download&id=<file ID between the /d/ and /view from the original share link>


How to get this download Link of the attachment?

In Google Drive, Click on the file you want to attach to an issue in Jira Cloud, then click on "Open in a new window". The URL of the file will be something like this:

https://drive.google.com/file/d/1s1XQcrI8HdF51CeUxR3AiEAv6xyj779j/view


The CSV file to import an issue and attach test.png to the issue from Google Drive will be as follows:

Summary,Attachment
"Test issue",23/Feb/23 6:18 PM;test.png;https://drive.google.com/uc?export=download&id=1s1XQcrI8HdF51CeUxR3AiEAv6xyj779j


How to import multiple attachments from Google Drive into issues?

Summary,Attachment, Attachment 2
"Importing files stored on google drive using CSV import","file1.txt;https://drive.google.com/uc?export=download&id=1QU3PD6ywNuTtOIrjR_3-8YO3R48AV","file2.csv;https://drive.google.com/uc?export=download&id=1AW1r1Pt1erSd-QnGxpPL1bhf2xNS1x0P"


Related Documentation

Importing your CSV file
Importing attachments into Jira Cloud using CSV External System Importer



Last modified on Oct 17, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.