In this article:

Connect Jira to Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Connect Jira to Google Sheets

Follow the steps below to connect Jira to Google Sheets. 

1. Install Your Chosen Jira Add-on to Google Sheets from the Marketplace

Navigate to Google Sheets and from the menu, select 'Extensions' > 'Add-ons' > 'Get add-ons'.

jira to google sheets

This will open the Google Workspace Marketplace. Look for options such as "Jira Cloud for Sheets" by browsing or using the marketplace search function. Once you find it, click on the add-on, then select 'Install'. Follow the prompts to give the necessary permissions, allowing the add-on to integrate with your Google Sheets.

connect jira to google sheets

2. Open the Installed Jira Add-on in Google Sheets and Start Configuration

With the add-on installed, it should now be accessible from within Google Sheets. Select Extensions and look for a new menu item "Jira Cloud for Sheets". Select "Open".

Clicking on this will prompt you to connect to your Jira account. This step is crucial as it allows the add-on to access your Jira data.

Log in with your Jira credentials. This step gives the add-on permission to access your Jira data. Ensure you have the necessary Jira permissions for this.

3. Choose Specific Jira Projects and Data to Import into Google Sheets

After authorization, the add-on will offer options to select which data from Jira you want to import into Google Sheets. Select "Get issues from Jira".

Select which specific projects, issue types, statuses, or custom fields. Some add-ons offer a query builder or a selection checklist to help you filter exactly what you need. Take your time to configure these settings to match your requirements, as this will determine the data presented in Google Sheets.

4. Import the Selected Jira Data into Your Google Sheet

Once you've configured your data selection, look for an 'Get Issues Now', 'Import', 'Fetch', or 'Sync' button within the add-on menu or sidebar. Clicking this button will start the process of importing your selected Jira data into your Google Sheet. Depending on the amount of data and your internet speed, this might take a few moments.

After the import is complete, you'll see your Jira data laid out in the spreadsheet, where you can start analyzing and organizing it as needed.

We hope that you now have a better understanding of how to connect Jira to Google Sheets. If you enjoyed this article, you might also like our article on how to set up Google Sheets MROUND or our article on how to use square root in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->