Use =jira custom functions in cells to get data via JIRA api, combine with sheet formulas and build graphs.
Listing updated:September 14, 2023
Works with:
3K+
Overview
Use jiraGet custom functions to get data via JIRA api, combine with sheet formulas and build graphs.

Generate reports from templates using Templates option in the add-on menu, update your project keys, team members, sprint & board IDs to start it up.

Use constructor functions:
getJiraIssueFieldsValuesForJQL(searchQueue, searchFor) gets 1-dimensional array of issues fields values  returned for the specified JIRA search query.
e.g.: =getJiraIssueFieldsValuesForJQL( "project in (QAE) and issuetype in (bug)","status")

Enjoy!

Sincerely yours,
QAEXPERTS.
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
Jira Reporting In Sheets will ask for the permissions shown below. Learn more
Jira Reporting In Sheets will need access to your Google account
This will allow Jira Reporting In Sheets to :
View and manage documents that this application has been installed in
View and manage forms that this application has been installed in
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
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
George S.
April 6, 2021
Great plugin, very useful for ad hoc reporting.
Is this review helpful?
Yes
No
Profile Picture
A User of Jira Reporting In Sheets
June 1, 2020
Great add-on to automate data gathering from Jira and work with it directly in Google Sheets. Great job from QA Experts!
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu