If I make changes in Google Sheets, will the same updates reflect in Jira?

[ariharan m]

Hi team, 

I have export the issue's from jira to Google sheet. I am tracking the issue updates via google sheet. So I want to know if I make any changes in google sheet, it should reflect in jira also. For that any add-on available in Google sheet or in Jira itself. 

[Manoj Gangwar · Accepted solution]

Hi @ariharan m 

  Look at these posts, maybe they give you clues

   https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436

   https://community.atlassian.com/t5/Jira-Software-questions/Automation-export-issue-fields-to-Google-Sheet/qaq-p/1520948

[ariharan m]

@Manoj Gangwar 

Thank you much for your guidance. It helped me very well. 

[Hannes Obweger - JXL for Jira]

Hi @ariharan m

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This is how it looks in action:

This all happens directly in Jira, on live Jira data - so there's no need to sync back and forth between Jira and Excel.

Any questions just let me know,

Best,

Hannes

[MobilityStream]

Hi @ariharan m ,

Take a look at our Google Sheets Integration add-on from the Atlassian Marketplace. It supports bi-directional integration. Install the Jira add-on first and then its corresponding Google Workspace app. Create an export of Jira issues that you would like to send over to Google Sheets. Once configured, any change that you make in Google Sheets will be sync’d back to Jira.

We can guide you through the configuration if you need help. Reach out to support@mobilitystream.com.

 Hope that helps.

Kind regards,

The Mobility Team

[Jack Brickey]

Hi @ariharan m , Not unless you import the changes using a CSV save file with the changes that you made. The free app that I believe you are using here only post data from Jira. It does not push data to Jira.