Hi Atlassian community,
I work on the product integration team at Atlassian and I am very excited to announce the early access program for the Jira Cloud add-on for Google Sheets. This add-on gives any Jira user the power of JQL in Google Sheets. The add-on is available today on the G-Suite marketplace (detailed installation instructions below), and I would love to hear about your experience using it.
We've all been there: it's Friday afternoon and management asks you for a last minute report. What's the status of your projects, and which ones matter most to our key customers? You have your regular reports configured in Jira, but none of them cover that angle. You'll need to whip something up quickly using data from Jira and Salesforce. This report is the last thing standing between you and your weekend, so what do you do? We all know the answer: spreadsheets to the rescue! But merging Jira and Salesforce data in spreadsheets is no easy task, fixing dozens of CSV exports is just one of the complications. Does it need to be that hard?
It turns out it doesn't anymore. We've heard you loud and clear, you want a better way to work with Jira data in your favorite spreadsheet app so that's what we just shipped: a Jira add-on for Google Sheet.
Get your Jira data in Google Sheets in just a few clicks
You can import Jira issue data from any number of Jira sites into a spreadsheet using either your saved filters or a custom JQL query. To customize the output format simply configure your saved filter or change your default columns in Jira.
There are two ways to import Jira data in a spreadsheet:
Using the “Jira Cloud for Sheets” sidebar as shown in the above screenshot, or
Using the =JIRA() custom function. The Jira function gives you the option to specify the list of columns you want the query to return.
Using the Jira function gives you a powerful way to return Jira data in Sheets
Return the issues in project ProjA that have been created in the last week, using your default set of columns.
=JIRA("project = ProjA and createdDate >= -7d")
Return all the issues in ProjA but only the issue key, summary text, the created time, and the reporter.
=JIRA("project = ProjA", "issuekey,summary,created,reporter")
Return the first 10 issues in ProjA but only the issue key and the internal id of the status.
=JIRA("project = ProjA order by createdDate desc", "issuekey,status.id", 0, 10)
Return the third page of issues, considering 10 issues in a page
=JIRA("project = ProjA",, 20, 10)
Using this is pretty simple and does not require any help from your friendly Jira administrator. From any Google Sheet:
Click on Add-ons > Get new add-ons
Search for “Jira Cloud for Sheets”
Click the “+Free” button and follow the prompts
G Suite administrators might need to enable access to Google spreadsheets add-ons for all users. Read more
Once enabled on G Suite, follow the steps below to install the add-on:
Go to the G Suite Marketplace
Search for “Jira Cloud for Sheets”
Click Install and follow the prompts
Note that we only support Jira Cloud today, if you are on Jira Server or Data Center you'll need to use one of the Google Sheets or Excel apps available in the Atlassian Marketplace.
We've done a lot of work to test this, but since this is the first version we put out in the wild you might hit a couple of rough spots. If so let us know and we'll fix this for you!
Please get in touch with Atlassian Support, we’re here to help.
Yes, please! We have plans for additional features, and we'd love to hear from you how we can make the add-on even better.
You can send us feedback using the “Jira Cloud for Sheets” sidebar
If you tick the "Yes, you may contact me about feedback" box we might get in touch to understand your needs a bit more. Help us shape the future of this add-on!
Nice! The team would love to hear that their hard work has paid off: if you could drop us a comment in the feedback form we'd really appreciate it, that's what keeps us going! If you would like to give us a little quote we could use when we announce the feature more widely we'd be eternally grateful.
Have you ever noticed that fixing specific problems might be a door opener for a bigger challenge, affecting a wider audience? This was exactly the case when we, as a service company working with mul...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs