Create reports, manage and update Jira issues directly in Google Sheet.
Listing updated:July 19, 2022
Works with:
232K+
Overview
Project Aid for Jira v1.4.10

This Spreadsheet Add-On allows you to connect to a Jira instance.
Pull entire Jira issue lists into Google Sheets using your own Jira filters, calculate results with Jira JQL queries and even create Time Reports for Jira users based on their worklogs.

Features:
- Refresh Ticket Data; update Jira status within regular cell content or entire lists
- Bulk update Jira Issues from Google Sheet
- List Issues From Filter; insert Jira ticket list based on Jira Filters
- Create Time Reports for specific Jira users based on their worklogs
- Create changelog report
- supports multiple JIRA custom field formats/types
- Perform JQL searches and show results in your sheet
- Configure Custom Fields
- ...
Additional information
PricingNot available
Developer
Non-trader
Privacy policy
Terms of service
Project Aid for Jira will ask for the permissions shown below. Learn more
Project Aid for Jira will need access to your Google account
This will allow Project Aid for Jira to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Publish this application as a web app or a service that may share your data
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Project Aid for Jira
July 2, 2020
Hi I am using JST_Search function to fetch some ticket ID along with description on the basis of some filters. Then I am using JST_getTotalForSearchResult function to get the count of issues linked with the tickets which I got as a result from JST_Search. It was working fine but now its not. Every formula shows error with this description: Error: Suspension of custom functions for about 14 seconds because of to many errors! Please correct all your custom function calls in this document and wait before re-trying. (line 271). Can anyone help with this?
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
June 4, 2020
I've used this tool for several years and it has been a huge time saver. Support has been extremely responsive with a few bugs I've reported. They turned around one fix within a day of it being submitted.
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
November 29, 2018
This is the "BEST" tool to use if you need Jira data on your Google Sheets! Easy to setup and use. It simply works! The developer is devoted to this add-in. Very quick with bug fix! Thank you Jens R!
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
June 25, 2020
Support is fantastic! I had a bug that prevented me from creating an issue table and it was fixed in a day. It's a great tool to manage tickets with.
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
May 30, 2021
i'm only able to extract 10000 row out of jira, even though i have more than 10000. did someone had the same problem ?
Is this review helpful?
Yes
No
Profile Picture
Lea-Anne Gaffney
September 7, 2020
Great tool and really good support if any issues!
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
March 5, 2019
Awesome add-on. Does save me a lot of time for creating reports and overviews for upper management. Could not find anything similar for Jira integration.
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
February 27, 2020
Is there a way to trigger updates in a automated fashion, say every hour for instance? Great tool.
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
October 1, 2018
seems it works with atlassian domain and doesn't work with jira embedded into company domain when I'm trying to connect I'm getting 'Could not connect to Jira Server![500]'
Is this review helpful?
Yes
No
Profile Picture
A User of Project Aid for Jira
October 26, 2019
Great way to bulk update tasks (or even create new ones fast)! Thanks for making this!
Is this review helpful?
Yes
No
1-10 of 17
Search
Clear search
Close search
Google apps
Main menu