Google Sheets for Jira

[manikanta ch]

Hello All,

How to export data from Jira and import it to Google sheets? 

how to extract data out of Jira into a Google sheet so that we can refresh it from the Google sheet. It would allow us to do some automation in Google sheets and have people see them with just refreshing?

Thanks in advance,

Manikanta

[Olga Rusnak]

hi @manikanta ch 

You can use Coupler.io Google Sheets add-on to do what you need - to export data from Jira and import it to Google Sheets. Here is a quick guide that explains how you can do it.

And yes, it is possible to automate data synchronization (data refresh). You will just need to set up data refresh frequency to 1 hour, for example. 

If you have any questions, please let me know!

[Johan Soetens _Dumblefy_]

Hi,

Jira Cloud for Sheets has all you need, it's great!

[Mani]

Thanks Johan!

For server how to integrate?

[Oleg Zverlin]

Apparently it does not work with servers at all