Google Sheets for Jira

Question

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

unknown · Answer

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!

Oleg Zverlin · Answer

Apparently it does not work with servers at all

Mani_e6g2kp · Answer

Thanks Johan!

For server how to integrate?