Import attachments located in Google Drive to Jira through CSV
Platform Notice: Cloud Only - This article only applies to Atlassian apps on the cloud platform.
Summary
To import attachments into Jira Cloud, the attachments can be located anywhere that your Jira Cloud site can access, including Google Drive. To make this work, the files need to be publicly accessible just before beginning the import. Once the import is finished, you can remove public access to the files.
Solution
Format the CSV
You'll need to retrieve and include Google Drive attachment links into the CSV file directly.
How to get the Google Drive download link
In Google Drive, select the attachment file, then "Open in a new window." The URL of the file will be something like this:
https://drive.google.com/file/d/<file_ID>/view
The Attachment column in the CSV file should follow this syntax:
| Attachment |
| https://drive.google.com/uc?export=download&id=<file_ID> |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=<file_ID>Import multiple attachments to a single work item
The process is the same as for a single attachment, and the sample syntax is below:
Summary,Attachment, Attachment 2
"Work item with two files","file1.txt;https://drive.google.com/uc?export=download&id=<file_ID1>","file2.csv;https://drive.google.com/uc?export=download&id=<file_ID2>"Related Documentation
Was this helpful?