Import data from Jira Server to Google Sheets

Connect Jira Server to Google Sheets using the CSV importer to automate data export.

The 4 steps to complete the setup

  1. Fill out the Title field
  2. Set up your data source
  3. Set up your data destination
  4. Configure importer's settings

1. Fill out the "Title" field

Name your importer. We recommend you pick a name that will enable easy in-app navigation for you and your team.

2. Set up your data source

2.1. Fill out the "CSV URL" field.

Enter the following CSV URL:

https://[your-jira-instance]/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.csv
  • [your-jira-instance] - replace with your Jira Server instance

Example:

If your Jira Server instance is https://mycompany.com/jira, the CSV URL will look as follows:

https://mycompany.com/jira/sr/jira.issueviews:searchrequest-csv-all-fields/temp/SearchRequest.csv<br>
Click Show advanced

2.2. Select an HTTP Method.

Pick the GET request method from the drop-down list. Read more about HTTP methods.

2.3. Fill out the "Request headers" field.

Specify the following Request headers:

Authorization: Basic {encoded-string}
Content-Type: "text/csv;charset=UTF-8"

{encoded-string}

To create {encoded-string}, put your Jira Server username and Jira Server password in the following pattern:

username:password

Encode the resulting string to Base64 using a dedicated service, such as base64encode.net.

2.4. Fill out the "URL query string" field (optional).

Enter a query string (a part of the CSV URL), which assigns values to specified parameters.

Example:

project = TJP AND status = "In Progress" AND component = "bug fixing activity"

2.5. Fill out the "Fields" field (optional).

You may specify the names of the columns in the CSV file to import to your spreadsheet, as well as their order. Separate column names by commas. The default behavior: select all columns.

Example:

Title, Status

2.6. Fill out the "Skip rows" field (optional).

You may specify the number of rows to skip from the top of the CSV document. The default behavior: select all rows.

3. Set up your data destination

3.1. Connect a Google Account you want to import data to.

  • Pick an account you want to connect to.
  • Sign in to the chosen account.
  • Review the contents of access rights which you are granting to Coupler.io and press Allow.
  • Confirm your choices.
  • Read the "Close this window" message and close the pop-up.

3.2. Fill out the "Sheet name" field.

Name the sheet, which will be receiving data. If the sheet with this name does not exist, Coupler.io will generate a new one for you.

Click Show advanced to set up optional parameters for your data destination.

3.3. Fill out the "Cell address" field.

Type in the address of the first cell where the data range will be imported. The default value is A1.

4. Configure importer's settings

4.1. Enable the "Automatic data refresh".

  • Specify import Frequency.

Check out more about Automatic data refresh.

Click Show advanced to set up optional settings for your importer.

4.2. Pick the Import Mode.

Follow this link to read more about choosing a data import mode.

4.3. Add the "Last Update" column.

If you want to add a column specifying the date of the last data refresh, toggle on the Last Update parameter.

4.4. Save the changes.

Click Save to save the parameters or Save & Import to save the parameters and run the initial import right away.

Book a free onboarding call! 
For any questions, feel free to email our team at  coupler@railsware.com