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 „Project Aid for Jira“ 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.

Project Aid for Jira 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 „Project Aid for Jira„
• Authorize the Add-On when asked for

Read the full guide here: https://github.com/ljay79/jira-tools/