Hi, I am trying to sort this flow. On a Google Sheet, I want to get the following information from 3 of my JIRA boards. From the active sprints from 3 JIRA boards, I want the below fields * Summary * Issue Key * Issue Type * Priority * Assignee * Status to be pulled into Google Sheet. Also, I want to ensure if a JIRA is closed, the status is updated in the Google Sheet. Is such an automation possible. Please help as it would help me streamline my Project Management. Thanks, Gaurav

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA Google Sheet Integration Flow

Gaurav Mehta_n9rpjv

Hi,

I am trying to sort this flow. On a Google Sheet, I want to get the following information from 3 of my JIRA boards.

From the active sprints from 3 JIRA boards, I want the below fields

Summary
Issue Key
Issue Type
Priority
Assignee
Status

to be pulled into Google Sheet. Also, I want to ensure if a JIRA is closed, the status is updated in the Google Sheet.

Is such an automation possible. Please help as it would help me streamline my Project Management.

Thanks,

Gaurav

Accepted answers

Tanguy Crusson

Hi there, if you are using Jira Cloud (so not Jira Server, the hosted version of Jira), you can use the Jira for Google Sheets add-on: https://community.atlassian.com/t5/Agile-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

We hope that helps!

All comments

Troy Spetz_46oct3

I think you will need to license an add-on such as:

https://marketplace.atlassian.com/apps/1216313/google-sheets-integration?hosting=server&tab=overview

Tanguy Crusson

We hope that helps!

Lisa Curnow

Hi Gaurav Mehta

Wondering about the second piece of your question. Did you find a way to have the status of the Jira ticket update?

I have been able to import my Jira board, but on testing by changing a status, I have not seen that status update reflected in the Jira sheet.

Ideally I would like to see the google sheet in synch with Jira after my import query has been set up, so that I dont have to redownload Jira each time - as there will be sheet formatting that I dont want affected.