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; } } }

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.

Accepted answers

Manoj Kumar Gangwar

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

All comments

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.

Manoj Kumar Gangwar

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 Kumar Gangwar

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

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud