It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Google Sheets for Jira

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

 

2 answers

Hi,

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

Thanks Johan!

For server how to integrate?

Apparently it does not work with servers at all

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!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you