Export Issue History into google sheets

[Adonias Mulugeta]

I am working with over a 1000 issues on a project and i want to be able to export the transitions history for every one of the issues and may be the time spent on a specific status. in addition to that, how much days did it take to resolve an issue with out counting the days it was in BLOCKED state.

[Tanguy Crusson · Accepted solution]

Hi there, I know it's a bit late but... if you are using Jira Cloud (Cloud, not Jira Server the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

We hope that helps!