How to get data of Sprint into the Google spread sheet

[Mohsin Ijaz]

How to get data from Jira to a customfield_10701 on the Google sheet like giving the heading which is basically the name of that customfield and get the Data i currently getting the data of other labels like Tasks , Team but when i put Sprint it is a Blank row what changes i need to do in Script files so it fetch data of Sprint as well

[Mani_Vannan · Accepted solution]

Hello,

You can easily and automatically import Jira Cloud data directly into Google Spreadsheet by following these steps:

1. Create a filter view in Jira with all of your desired columns(sprint view), save it, and make a note of the path.  Example: https://mycompany.atlassian.net/issues/?filter=01

2. Change the path to https://mycompany.atlassian.net/sr/jira.issueviews:searchrequest-csv-current-fields/11940/SearchRequest-01.csv

Note that going to this URL in your browser returns a CSV file.

3. Start Google Spreadsheet, and select Data menu, New query, From Other Sources, From Web

4. A dialog will appear asking you for the URL. Paste in your CSV URL from step 2, and click OK

5. You will be prompted with a permissions dialog.  Select Basic authentication, enter your Jira username and password, and click Connect.

6. After Excel connects, you will see a dialog with a preview of the table.  Click Load to load it into the current worksheet.

From this point forward, your Jira credentials will be cached, and you can update the query at any time by clicking Data/Refresh all.

Note: This is applicable only if your JIRA is in cloud. For server (on Premise) based  JIRA will restrict access.

If this helps, please accept this as answer:) Cheers.

[Mohsin Ijaz]

Forget to Add Jira is on the company server not on Cloud

[Olga Rusnak]

Hi @Mohsin Ijaz 

You can try using Coupler.io Google Sheets add-on to pull data from Jira server issues to Google Sheets.

So, how it basically works:

- You set up an importer as part of the add-on

- Pick data refresh frequency (starts from an hourly basis)

- Specify the data you want to pull from Jira (by using JQL)

- And you will see how your data gets updated every hour

If you have any questions, feel free to let me know!