Create reports, manage and update Jira issues directly in Google Sheet.
By:
Listing updated:July 19, 2022
Works with:
193K+
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
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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
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
Ibrahim Quffa
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
June 24, 2020
Great tool that saved me a lot of time! The support was very responsive at fixing a bug I reported, I really appreciate it.
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 16
Search
Clear search
Close search
Google apps
Main menu