downloading > 1000 rows on Google Sheets

[Satish Shankar]

I am trying to download > 1000 rows on Google Sheets. I was able to find an add on that sits on Google Sheets at https://gsuite.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016 that allows this capability. However it seems like this is only possible for Atlassian hosted JIRA instances. Has anyone figured out a way to download > 1000 rows on a client hosted JIRA instance?

[Olga Rusnak]

Hi @Satish Shankar 

You can try using Coupler.io google sheets add-on to download data from a client hoster Jira instance to Google Sheets (here is the guide https://blog.coupler.io/jira-server-to-google-sheets/), as well as configure for automatic data refreshes to happen every hour (or any other timeframe you pick). You will also be able to filter out the results using JQL.