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;

Unresolved JIRA Issues

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

Final Result

I opened script editor and wrote this code;

Have fun !


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: Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s