Skip to main content
All CollectionsFeaturesAPI
Integrate JIRA with Google Sheets

Integrate JIRA with Google Sheets

Automate your project tracking

Luciano Marzoni avatar
Written by Luciano Marzoni
Updated this week

Integrating JIRA with Google Sheets opens new possibilities for managing and analyzing your project data. You can automatically pull tasks, issues, and key data from JIRA into a spreadsheet.

Whether tracking sprint progress or creating custom reports, this connection helps you make better decisions with real-time project insights.

Before starting, make sure you have the following:

  • A JIRA API token

  • Your JIRA project or browser URL

Step 1: Generate a JIRA API token

  1. Click Create API token

  2. Add a label to identify the token

  3. Click Create, then Copy

  4. Store it securely—you’ll need it in the next step

Step 2: Find your project and team name

Here’s an example JIRA project URL:

https://team-name.atlassian.net/jira/software/projects/PROJECTNAME/boards/1

From this:

  • team-name is your JIRA team.

  • PROJECTNAME is your JIRA project.

You’ll use these in your API URL.

Step 3: Choose your JIRA API endpoint

Pick an endpoint based on your data needs from the JIRA API documentation.

For example, to get all tasks in a project, use:

/rest/api/3/search?jql=project=PROJECTNAME

Step 4: Encode your credentials

Combine your email and API token in Base64 for authentication.

Use this Google Apps Script:

function encodeCredentials() {
var email = "USER_EMAIL"; // your JIRA email
var apiToken = "API_TOKEN"; // your API token
var credentials = email + ":" + apiToken;
var encodedCredentials = Utilities.base64Encode(credentials);
Logger.log(encodedCredentials);
}

Replace USER_EMAIL and API_TOKEN with your own values.

Step 5: Set up your API request in Sheetgo

Example URL to get issues from the SCRUM project:

https://sneha-team.atlassian.net/rest/api/3/search?jql=project=SCRUM

Headers for the request:

{
"@auth": {
"auth_method": "Basic"
},
"@flags": {
"data_root": "issues"
},
"@pagination": {
"limit_param": "maxResults",
"offset_param": "startAt",
"type": "offset"
},
"Accept": "application/json",
"Authorization": "Basic ENCODED_CREDENTIAL_LOGGED"
}

Choose the destination Google Sheet and run your Sheetgo workflow to import JIRA data!

Did this answer your question?