Jira is a powerful and well established project management tool amoung small to enterprise businesses. Still we often end up using Google Sheets for some overview roadmaps, project dashboards and other purposes.
With this Google Sheet Add-on the, called "Jira Sheet Tools" available in the Google Add-On store from within Google Sheet, you can now take your sheets with Jira information to the next level.
Jira Sheet Tools allows you to visualize the status of any Jira ticket you mention in a sheet. You can directly import entire issue lists with your Jira filters just from within Google sheet. NEW! You can create time reports for any of your users based on the Jira worklogs.
Enter your Jira server domain and user details once, and be able to use the Jira features in any sheet at any time. No manual status update copy&paste anymore.
Tested with latest Jira Cloud (OnDemand) - compatibility with Jira Server not yet fully tested! Please provide feedback.
- Open up your chrome browser
- Find & Install the Add-on "Jira Sheet Tools"
- Authorize the Add-On when asked for
View and manage your spreadsheets in Google Drive
Required to change and add Jira issue information within the active sheet.
View and manage data associated with the application
The Add-on will store your Jira settings within the protected google sheet storage.
Allow this application to run when you are not present
Fault. This permission is actually not used at all, but triggered by yet unknown word within the code. Will hopefully be not necessary in a sonner release.
Connect to an external service
Required for establishing connection to the Jira RESTful API to fetch your Jira issue details when requested.
Once installed: Simply provide your individual Jira server settings before you use all features.
In any Google sheet, go in the menu to “Add-ons" > "Jira Sheet Tools" > "Settings”. Enter your "Jira Domain", "Username" and "Password".
It is recommended to use this Add-on only with an Jira Cloud/Server instance which runs via SSL (https). This Add-on is using simple Basic Auth mechanism to authenticate with Jira, which means, user credentials are transmitted unsecure when using without SSL.
You're all set and ready to go
Any Jira ticket Id in the form of "KEY-123" will be updated on the current active google sheet and extended with the current status of matching Jira ticket.
Sample Data:
| Before | After
| KEY-123 | KEY-123 [Done]
| KEY-456 | KEY-456 [In Progress]
| KEY-789 | KEY-789 [Closed]Even when used within text it will search for keys and add the status. If Jira issue key used in a single cell, the value will be linked automatically to the Jira issue page.
“Add-ons" > “Jira Sheet Tools” > "List Issues from Filter"
Allows you to add a table/list of all found Jira issues based on a Jira Filter. The dialog will let you choose from all your Jira filters and then insert all results into the active Google sheet. You can even decide which information to be shown in the resulting table. Most common Jira fields / columns are available to select from.
Note: This feature is currently limited to list a maximum of 1000 jira issues.
“Add-ons" > “Jira Sheet Tools” > "Time Sheet"
Lets you pick a user from Jira and a date period to filter for and generates a nice Time sheet report based on all worklogs for the filtered user and date period. Supports two different time report formats; "1d 7h 59m" for better readibility or "7.5" (work hours as decimal number) for better calculations in the sheet.
Careful when selecting to big date periods, can be slow and become a wide table. Start with 1 week and scale up.