Your JIRA issues to Google spreadsheet

I was wondering how could I get my all unresolved JIRA issues to my spreadsheet. I made a research and find this simple way to get all my issues.I used JIRA REST API. 

Here, In my JIRA I have this in progress issue;

jirra-open-issues
Unresolved JIRA Issues

I wanted to get this open issue data to my spreadsheet as this;

spreadsheet
Final Result

I opened script editor and wrote this code;

Have fun !

Advertisements

3 thoughts on “Your JIRA issues to Google spreadsheet

  1. Rich March 3, 2017 / 9:25 pm

    This was perfect for generating a report to show outside users where the form collector issues were in the process. Thanks for this!

    Liked by 1 person

  2. Isabela July 29, 2017 / 2:07 am

    thank you! Super helpful and straightforward

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s