Ways to automate CSV export?

Question

We would like more analytics on our Jira Service Management (Cloud) data than the current dashboards can handle - calculated fields, real-time filtering, etc. To that end, we are trying to move the data into an platform (Tableau CRM / Salesforce Einstein).

We can get the data passed in through CSV files, but we'd like to automate a nightly export and I'm having a rough time finding any solution that works for the cloud. I'm assuming that we could write an API routine somewhere to do this, but we are trying to avoid that at this point. Are there any other options out there that folks have used successfully?

Jack Brickey · Accepted Answer

Have a look at using Google Sheets and leverage jira-cloud-for-google-sheets-official

unlike the version for excel, my understanding is that you can set up a scheduled query. There are some posts in the community on this but should be pretty straightforward.