How to get data of Sprint into the Google spread sheet

Mohsin Ijaz_ua9qyh

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

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.