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
Click Create API token
Add a label to identify the token
Click Create, then Copy
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-nameis your JIRA team.PROJECTNAMEis 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!