You love Jira, you use Jira, but still, you want more than Jira can provide. For example, to build a project roadmap or a custom dashboard. In this case, you can export issues to Google Sheets and play with your source data as needed. Is it possible to pull data from Jira Software Server? Sure! Check out how to do so using Coupler.io.
Why pull data from Jira Server?
Depending on the infrastructure, clients use either Jira Server or Jira Cloud. The Cloud option means that your Jira Software site will be hosted and set up in the cloud for you. With Jira Software Server and Data Center, you can customize your setup, and the site will be hosted on your dedicated hardware. In specific cases, clients may opt for both options. For example, Jira Cloud can serve as a test environment, while Server is used as a production one.
Whichever option you choose, you may want to export raw data from it. Why? Google Sheets gives the power to visualize and process your data in many ways. Some do accounting and reporting in spreadsheets, others build custom dashboards and so on. Tech-savvy Jira users pull data using APIs. But who would want to mess with coding when there is a much simpler way to get data from Jira Server?
How do you export data from Jira Server to Google Sheets?
Install Coupler.io from the G Suite Marketplace.
Once done, you need to launch Coupler.io, click on the +Add Importer button and choose CSV.
Note: To export data from Jira Server, you need to set up a CSV importer not Jira importer, which is used to pull data from Jira Cloud.
Set up a CSV importer for Jira Server
To set up the importer, you need to fill in the required fields. In the blog post “Import CSV into Google Sheets”, we described the flow of setting up the CSV importer. You can also check out a dedicated knowledge base for details. To export data from Jira Server, focus on the following fields:
- Title – add the name of your importer.
- Sheet Name – add the name of the sheet which will be receiving data.
- CSV URL – insert the CSV URL of issues to be imported. Where do you get it? Here is a hack. Update the following pattern with your Jira Server instance.
For example, if your instance is
https://mycompany.com/jira, the URL will look as follows:
Automatic data refresh – choose the frequency of automatic resync of data. If you don’t need this feature, disable it by clicking on the toggle.
- HTTP method – select the GET request method
- Request headers – insert the following headers:
Authorization: Basic SmlyYTpTZXJ2ZXI= Content-Type: "text/csv;charset=UTF-8"
SmlyYTpTZXJ2ZXI= is a base64-encoded string of
Jira is the Jira username,
Server is the Jira password). For encoding, you can use a dedicated service, such as base64encode.net.
- URL query string – assign values to specified parameters. For example:
project = TJP AND status = "In Progress" AND component = "bug fixing activity"
With all the required fields filled in, click Add Importer and run it afterwards.
Use case: how you can use Jira Server integrated with Google Sheets
What can you do with all this raw data imported from Jira Server? Some product teams build interactive roadmaps based on it. We suggest you tailor a simple performance monitor, which will let you track productivity of certain issue holders. Here is how it may look:
Here you can see a breakdown by assignees and the values associated with each of them. So, you can track how many issues each assignee closed and how much time he or she spent on average. If you’d like to see the performance in detail, you can choose a certain team member and get a specified report as follows:
For your convenience, you can download this ready-to-use report template and adjust for your specific project.
To wrap up: should you import data from Jira Cloud or Jira Server?
The answer is both! You can even pull project-level from Jira Cloud using the JSON Client importer. With Coupler.io you can set up multiple importers and schedule them to import data automatically. So, you won’t even need to run importers manually each time you want to update your source data. The add-on will do this based on the chosen schedule. This feature is crucial for real-time monitors and sales trackers. Enjoy your data in Google Sheets and discover more importers with Coupler.io. Good luck!Back to Blog