Export Issues to Google Sheets

[Foxcliffe Hickory]

Basic Question:

Is there a way to have an exported Google Sheet stay dynamically up-to-date with its related Jira Issues?

So for instance, if I've already exported the Google Sheet from the Jira Issue Manager, and the issues are fixed, how can I make the exported sheet update automatically if someone changes an issue?

Thanks.

[Alex Ortiz · Accepted solution]

Hello,

This should be possible, but you do not want to export the issues.

Instead, you are going to want to use the extension Jira Cloud for Sheets.  You should be able to find this in the Google Extension marketplace.  It should be free and this will allow you to SYNC your issues between Jira and Google Sheets.  

Then, whenever you want, you just click a button and the latest data from Jira will be brought into your sheet.

Hope that helps.

For a visual answer check out the 25:00 minute mark in my video:

https://www.youtube.com/watch?v=hwRUJMvbL2M

[Foxcliffe Hickory]

Thank you!!!!