Easy Tech TutsHow to Connect Jira to Google Sheets & Create Reports With Live Data Easily 2026
By Impran M N
Manually exporting Jira data every time you need a fresh sprint report is inefficient when a direct integration exists. The Jira Cloud for Sheets add-on connects your Atlassian workspace to Google Sheets, letting you pull live issue data and run custom queries. This guide covers installation through setting up automated refreshes.
01Install the Jira Cloud for Sheets add-on
Add the official extension from the Google Workspace Marketplace to your spreadsheet.
02Connect your Atlassian account
Authenticate and link your Atlassian workspace site to the add-on.
03Run an initial data import
Import project fields and issues from scratch to populate your spreadsheet.
04Use starred filters for faster pulls
Reference your saved Jira filters to speed up future data imports.
05Write a custom JQL query
Use the sidebar to filter issues by status, assignee, or other criteria with a custom JQL query.
06Set up automated refreshes
Activate a daily or hourly refresh schedule so your report stays current with live Jira data.
Frequently asked questions
Do I need to know JQL to use this integration?
Basic familiarity with JQL helps for advanced filtering, but you can also rely on starred filters from Jira to pull data without writing custom queries.
Will my report update automatically?
Yes, you can configure automated hourly or daily refresh schedules so your Google Sheets report reflects the latest Jira data.
Is this add-on official or third-party?
The tutorial refers to the official Jira Cloud for Sheets extension available through the Google Workspace Marketplace.
Can I filter by assignee or issue status?
Yes, custom JQL queries let you filter imported issues by status, assignee, or other Jira fields.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
