Use Jira Cloud for Sheets

Jira Cloud for Sheets enables you to import Jira data into your spreadsheets with Jira filters or JQL (Jira Query Language).

Your G Suite admin must enable access to Google Sheets add-ons for all users to use the integration. Learn more about turning on a G Suite marketplace app for all users.

Add the Jira Cloud add-on to Google Sheets

To add the Jira Cloud add-on to Google Sheets:

1. Go to a Google Sheets spreadsheet.

2. Select Add-ons > Get add-ons.

3. Search for Jira Cloud for Sheets.

4. Hover the app and then click +Free.

5. Follow the prompts to give add-on access to your Google Sheets spreadsheet.

Connect your Jira Cloud site with Google Sheets

To connect your Jira Cloud site with Google Sheets:

1. Go to a Google Sheets spreadsheet.

2. Select Add-ons > Jira Cloud for Sheets > Open….

3. Click CONNECT. This will open a new browser window.

4. Select the site you want to add from the list of available sites.

5. Click Accept.

Import data from Jira

Import issues to your spreadsheet with the following methods.

To import data from Jira using JQL

1. Go to a Google Sheets spreadsheet.

2. Click on Add-ons > Jira Cloud for Sheets > Open … > Get data from Jira.

3. Specify the JQL for the query you want to run. You can click on the OPEN IN JIRA link to open and test the JQL query in Jira. If you don’t write a specific JQL query the system will import all issues on your site.

4. Click GET DATA.
   
   

To import data from Jira using filters

Your filter must be a Starred Filter to import to a spreadsheet.

1. Go to a Google Sheets spreadsheet.

2. Click on Add-ons > Jira Cloud for Sheets > Open … > Get data from Jira.

3. Select the FILTERS tab.

4. Choose your filter from the list of available filters.

5. Click GET DATA. You can restrict the number of rows returned with Max Rows.

JIRA() custom function with JQL

Only owners of the document can enable the JIRA() custom function with JQL. When enabled, this function uses the document owner’s configured site and Jira account to query Jira.

To import data from Jira using the JIRA() custom function with JQL:

1. Go to a Google Sheets spreadsheet.

2. Click Add-ons → Jira Cloud for Sheets → Open… → Settings

3. Click Enable = JIRA() function for users of this sheet.

4. Read the warning and accept.

Troubleshooting and workarounds

I enabled the =JIRA() function and it's still showing me an error.

Clear the value of the cell where you are using the =JIRA() function, press enter. Enter the query again and it should now work. You will only need to do this once (we’re working on fixing a bug causing this behavior).

The add-on returns an error when I want to query a large number of issues.

The add-on should work fine with queries of up to 10,000 issues. If you need to return more issues, you should use the =JIRA() function which lets you paginate through results. Make sure to sort the results in the query.

For example, to return 20000 issues, put this on one cell to return the first 10,000 issues:

=JIRA("project = ProjA order by updated desc", "", 0, 10000)

And this in another cell to return the following 10,000 issues:

=JIRA("project = ProjA order by updated desc", "", 10000, 10000

The add-on returns a generic error when importing issues.

Hmmm ... looks like we stumbled a bit, please try again or contact Atlassian support if the issue persists.

If you encounter the above error when importing issues:

1. Review the log for any authentication failures. If there are failures, reattempt the import process using valid authentication credentials..

2. The error may be due to attempting to import a large number of rows. If this is the case, retry the import with a reduced number of rows (e.g. 1000 to 2000 rows in batches)

3. Disconnect and then reconnect your Jira Cloud site through the add-on.

4. If the above steps do not resolve the error, uninstall and then reinstall the add-on to establish a new connection.

The add-on returns a ‘no Jira auth’ error when importing issues.

If you’re receiving a Jira authentication error when trying to fetch issues into Sheets:

1. Uninstall and then reinstall the add-on to establish a new connection.

2. Disconnect and then reconnect your Jira Cloud site through the add-on.

3. Create a new Google Sheet, paste the function in this new sheet, and reattempt the import.

4. Create a copy of the Google Sheet, and reattempt the import.

If none of the above steps resolve the error, try revoking access in both your Atlassian account settings and on your Google account. Then, remove the add-on from Google Sheets, and try reauthorizing it again.

The add-on returns empty cells for user data.

The add-on respects individual users' privacy settings for profile data. If a user has made their profile information private then the add-on will return a blank value for this user in columns like  assignee  or  reporter.

What functionality does Jira Cloud for Sheets provide?

Jira Cloud for Sheets is an add-on you can use within Google spreadsheets to import data from Jira Cloud sites:

• based on a JQL (Jira Query Language)

• based on starred/pre-defined filters on Jira Cloud

How do I specify which columns are populated in the spreadsheet?

The add-on uses your column settings on Jira Cloud while importing data. You can have different column settings for your account and also for filters. If there are no user/filter specific columns configured on Jira Cloud, the add-on uses the default system columns.

You can specify different columns by using the =JIRA() function, for example:

=JIRA("project=MYP","issueType,reporter,another column")

How do I uninstall this add-on?

You can uninstall the add-on by click on Add-ons > Manage Add-ons > Manage >  Remove.

Can I use this add-on if I don't have a licensed Atlassian Product?

No, you need a license/subscription for Jira Cloud to use this add-on.

Can I use this add-on with Jira Server?

No, the add-on only works with Jira Cloud sites for Jira Work Management, Jira Software and Jira Service Management. Check with your Jira administrator if you are not sure about cloud vs server.

How do I disconnect the spreadsheet from any connected Jira Cloud instance(s)?

You can disconnect all your configured Jira Cloud sites from the add-on. From a spreadsheet:

1. Click on Add-ons → Jira Cloud for Sheets → Open…

2. Click on on the Disconnect site button

3. this will redirect you to your Atlassian Identity profile page where you can disconnect the add-on/app by clicking on ‘Remove access’.

Is this add-on GDPR compliant?

Yes. We also don't store any personal user information. Read more in our migration guide.