Jira is a powerful and well established project management tool among small to enterprise businesses. Still we often end up using Google Sheets for some overview roadmaps, project dashboards and other purposes.
With this little 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 sheet based reports 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. Or create time reports for any of your users based on the Jira worklogs.
Check it out:
- Open up your chrome browser
- Open or create a Google Sheet
- Find & Install the Add-on „Jira Sheet Tools„
- Authorize the Add-On when asked for
Read the full guide here: https://github.com/ljay79/jira-tools/