Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below.

We recently updated our Terms and Conditions for TechRepublic Premium. By clicking continue, you agree to these updated terms.

Invalid email/username and password combination supplied.

An email has been sent to you with instructions on how to reset your password.

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

How to set up Jira and Google Sheets integration

Your email has been sent

Jira is a powerful tool for agile project management. Google Sheets, which is a powerful spreadsheet tool, can be used with Jira for enhanced project reporting. Learn how to get started.

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 you can combine these two such that you can quickly export Jira data into Google Sheets spreadsheets?

SEE: Hiring kit: Project manager (TechRepublic Premium)

This integration app also gives users the power of Jira filters and JQL within Google Sheets. I’m going to show you how to make this happen, with the help of the Jira Cloud for Google Sheets app in Jira.

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

With those two accounts ready to go, let’s piece them together.

Before you add the app to Jira, make sure you’ve logged into both accounts from the same web browser. Once you’ve done that, click on the Jira tab in your browser and then click Apps | Explore More Apps.

In the App Market, type “google sheets” in the search field. Three different apps will appear, from which you should click Jira Cloud for Google Sheets (Figure A).

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

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

Click Install and, when prompted, click Continue. You will then be prompted to select the correct Google account and then permit Jira to access Google Sheets. In the permission window, click Allow, and then, once the installation completes, close the window.

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

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

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

Click Accept and then go back to Sheets, where you’ll see the sidebar now includes the Jira integration (Figure G).

Click Get Issues from Jira and then select Basic from the Import Type drop-down (Figure H).

Complete the configuration for the issues, selecting the Project, Issue Type, Status, Contains Text, Order By, and Max Issues, and then click Get Issues Now.

The import will start and finish and you should then see the Jira Issues have populated your spreadsheet. Depending on how many issues you pull into the spreadsheet, this could take some time.

And there you go, Jira and Google Sheets are integrated such that you can create Google spreadsheets from Jira issues to help keep your stakeholders better informed.

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

We deliver the top business tech news stories about the companies, the people, and the products revolutionizing the planet.

How to set up Jira and Google Sheets integration

Your email has been sent

Your message has been sent

TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.

The technologies could enable immersive experiences, accelerated AI automation and optimized technologist delivery in the next two to 10 years, according to the firm.

Are you an IT manager or executive trying to make the case for a new ERP vendor? Compare the top ERP software solutions with our list today.

Learn about the new features available with macOS 13 and how to download and install the latest version of Apple’s flagship operating system.

Get great deals on developer and Linux training courses, Microsoft Office licenses and more through these TechRepublic Academy offerings.

This comprehensive guide covers the use of services from multiple cloud vendors, including the benefits businesses gain and the challenges IT teams face when using multicloud.

Recruiting a Scrum Master with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit provides a customizable framework your business can use to find, recruit and ultimately hire the right person for the job. This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

Knowing the terminology associated with Web 3.0 is going to be vital to every IT administrator, developer, network engineer, manager and decision maker in business. This quick glossary will introduce and explain concepts and terms vital to understanding Web 3.0 and the technology that drives and supports it.

While the perfect color palette or the most sublime button shading or myriad of other design features play an important role in any product’s success, user interface design is not enough. Customer engagement and retention requires a strategic plan that attempts to measure, quantify and ultimately create a complete satisfying user experience on both an ...

IIoT software assists manufacturers and other industrial operations with configuring, managing and monitoring connected devices. A good IoT solution requires capabilities ranging from designing and delivering connected products to collecting and analyzing system data once in the field. Each IIoT use case has its own diverse set of requirements, but there are key capabilities and ...