Jira Cloud for Sheets — Extension to get Issues from Jira

Hi Techies,

Here I am to share my quick hack this time to make the agile workflow less chaotic. After all, as the saying goes — “80% of Agile workflow is Jira Ticket management” :)

You can schedule the sync-up between the GSheet and Jira Cloud and customize the fields that you want to fetch.

Keep Jira as your source of truth. Every time there is a sync-up, the data is refreshed, so this makes the sheet read-only and the edits that you make will be lost. So, always update information in Jira and your GSheet will reflect your changes at the next refresh.

Prerequisite: Connect to Jira Site

1. Go to GSheet > Extensions > Jira Cloud for Sheets > Open, and select Connect.

3. Authorize for site from the drop-down and select Accept.

Get Issues from Jira: Enter the JQL Query

1. Go to GSheet > Extensions > Jira Cloud for Sheets > Open.

2. Select Get issues from Jira.