How to integrate Jira and Google Sheets

0

Jira is a powerful agile project management tool. Google Sheets, which is a powerful spreadsheet tool, can be used with Jira to enhance project reporting. Learn how to start.

Image: sharafmaksumov/Adobe Stock

We all know how useful Google Sheets is. And anyone who works with issue tracking is probably very familiar with Jira. But did you know that you can combine these two elements to quickly export Jira data into Google Sheets spreadsheets?

SEE: Recruitment Kit: Project Manager (TechRepublic Premium)

This integration app also gives users the power of Jira and JQL filters in Google Sheets. I’ll show you how to achieve this, using the Jira Cloud for Google Sheets app in Jira.

What you’ll need to integrate Jira and Google Cloud

As you’ve probably guessed already, you’ll need both a Jira account and a Google account for this to work. Your Jira account must have permission to install apps and your Google account can be the non-paid version of Workspaces.

With these two accounts ready to go, let’s put them together.

How to integrate Jira and Google Sheets

Before adding the app to Jira, make sure you’re signed in to both accounts from the same web browser. Once you’ve done that, click the Jira tab in your browser, then click Apps | Explore more apps.

In the App Market, enter “Google Sheets” in the search field. Three different apps will appear, from which you need to click on Jira Cloud for Google Sheets (Figure A).

Figure A

The three different Google Sheets apps are available in Jira.

In the resulting window (Figure B), click Get App.

Figure B

Installing the Jira Cloud app for Google Sheets in Jira.

Oddly enough, you’ll then be prompted to go to Google Workspace Marketplace and install the Jira Cloud for Sheets app (Figure C), which means you could probably skip searching in Jira altogether. However, it’s good for you to see what’s available on the Jira App Market.

Figure C

Installing the Google Workspace Jira app.

Click Install and when prompted, click Continue. You will then be prompted to select the correct Google account and then authorize Jira to access Google Sheets. In the authorization window, click on Authorize, then, when the installation is complete, close the window.

How to use the integration

Open a Google Sheet spreadsheet you want to work with and click Extensions | Jira Cloud for Sheets | Open (Figure D).

Figure D

Jira Cloud for Spreadsheets has been integrated with Google Sheets.

A new sidebar will open in Google Sheets (Figure E), where you need to click Connect.

Figure E

The Google Sheets Jira sidebar.

A new page will open (Figure F), where you need to accept the connection.

Figure F

Acceptance of Sheets/Jira integration.

Click Accept, then return to Sheets, where you’ll see the sidebar now includes the Jira integration (G-figure).

G-figure

Jira and Sheets have been officially integrated from Sheets.

Click Get Issues from Jira, then select Basic from the Import Type drop-down list (H-figure).

H-figure

The Get Issues from Jira sidebar makes it easy to extract the information you need.

Complete the issue setup by selecting Project, Issue Type, Status, Contains Text, Sort By, and Maximum Issues, then click Get Issues Now.

The import will start and finish and you should then see that Jira issues have populated your spreadsheet. Depending on the number of issues you insert into the spreadsheet, this may take some time.

Lo and behold, Jira and Google Sheets are integrated so you can create Google Spreadsheets from Jira issues to better inform your stakeholders.

Subscribe to TechRepublic’s How To Make Tech Work on YouTube for all the latest tech tips for professionals from Jack Wallen.

Share.

Comments are closed.