Use Google Sheets with Jira
Better analyze Jira data with the ability to export Jira issues to Google Sheets, all updated in real-time
Share with both Jira and non-Jira users
End manual imports & out-of-sync spreadsheet data
Fully Configurable Google Sheets Jira integration
Features In Detail: Google Sheets Jira Integration
Gabor Braun, CTO
How to Connect Jira to Google Sheets
Obtain Google API key and then everybody will be ready to export any issue searches to Google Sheets with a few simple mouse clicks. Jira Google Sheets integration is updated in real-time.
If you repeatedly need to export data from Jira to your spreadsheets, our integration products are for you.
Once setup, exporting data becomes a breeze, always in-sync, everyone who you provide permissions can easily create their own exports. Our products are the most complete, most convenient, and provide the highest degree of automation.
Unlike other solutions, ours works straight out of Jira. No tinkering in the spreadsheet itself required.
First, install the add-on in Jira Cloud, Server or Datacenter. Then obtain the Google Sheets or Excel Online API keys. You may need to follow a few configuration steps:
After that, simply upload the obtained key on the Add-on configuration page and you are ready for your first export.
API calls to Google Sheets and Excel Online are free. There will not be any additional charges.
However, there are time-based API call limits. For example, if you have a large Jira instance with many real-time updates going to Google Sheets you may need to increase the API call limit. Increasing the API limit is free.
For more details see this documentation page.
Excel has a much higher API call limit, increasing it will rarely be necessary.