Irantha Jayasekara
Irantha Jayasekara
Digital Products & Solution Provider

Drink A Coffee With Me Today


Follow Me On Instagram

alt text alt text alt text alt text alt text alt text
Available For Freelance
September 15, 2016

How To Get JIRA issues to Google sheet

By Irantha
Google Apps Scripts

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

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

JIRA to Google Sheet
I wanted to get this issue data to my spreadsheet as this;

JIRA to Google Sheet
I opened google apps script editor and wrote this code; Please change your credentials accordingly.

Hope this helps you. Please comment your thoughts and like the post.

Author Details
Irantha Jayasekara
Irantha Jayasekara

Software Developer, Web Developer, Freelancer, Project Manager & Google Apps Scripts and API expert

Share Post