Use =jira custom functions in cells to get data via JIRA api, combine with sheet formulas and build graphs.
Listing updated:September 14, 2024
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
Loading
Search
Clear search
Close search
Google apps
Main menu