How can I INSERT into my JIRA cloud sheet instead of overriding my current data?

Question

I'm trying to create and maintain a live document for a priority list of JIRA tickets. Whenever I use the "Get issues from JIRA" feature, it rewrites all the custom columns and data I've already added and I'm left with a clean list from my filtered view that I've just import. Any way to just add the new issues created to my list rather than redoing the whole list each time?

I've tried to use the JQL query "=JIRA..." but when I add a priority to each row and then filter view, it doesn't affect the data. nothing filters.

Then I tried using the "Open in google sheets" function from the JIRA filtered view UI. It allows me to import the data, add priority, then filter the view, but again, when I try to retrieve new issues from JIRA, it overrides any work I've already done and I'm left with a clean sheet of the issues I just imported. =/

Earl McCutcheon · Answer

Hello @Steven Quintanilla ,

The data pull into sheets from Jira is a live data view, so any time you import the data it is intended to be overwritten as a full refresh of the source items, and there is not an option to append data from the data pull.

So as a workaround here you should look at the functionality in google sheets, and I would recommend setting up multiple sheets to do data comparisons and modifications as needed, by looking into writing up an App Script to automate the conversions.

On your first sheet you could have this set up as the default import page where you refresh the Jira data as the only action here then have the app script take data from sheet 1 and copy it to sheet 2 with an append function to add in new lines, as well as a compare function for field values that are necessary to update,  this way you have sheet 1 as your live data and sheet two as the modified data using the app script to align data points for customization.

there is an example app script in the following Stack Overflow post that looks like it would be a good starting point for appending sheets based on cell criteria:

* https://stackoverflow.com/questions/60932777/how-can-i-append-rows-from-a-sheet-to-another-sheet-in-googlesheets-based-on-a

Regards,
Earl