How do I update the status of multiple JIRA tickets in one go through google sheets or code?

[Dixit Jain]

I have a list of 1000 tickets which I imported through google sheets in JIRA. Status of some of these tickets have changed and now I wish to update the status of these tickets through this sheet on JIRA in one go. Can you suggest how to do that?

[Jack Brickey]

If the issues are in Jira you can use bulk edit. Create a JQL filter to result in all issue you wish to update and click on the ellipses in the upper right and select bulk edit, follow screen prompts. Alternatively you can update tickets using a CSV file and include the JSD issue ID.