What you need to know about Atlassian app Jira Cloud for Sheets
You need to integrate Google Sheets with Jira. Atlassian free Jira app might be enough for your needs, but before you decide be aware of its limitations.
In 2022 Atlassian put it’s app Jira Cloud for Sheets in maintenance mode. Improvements were discontinued (full details). As a result users have been reporting system reliability problems ranging from lost connectivity and 503 errors to duplication and missing data.
If you are looking for a more robust Google Sheets integration for Jira then considering a free trial of app Google Sheets Integration. The key difference is reliability. Also:
exports directly out of Jira via API calls
exports can be one-time, scheduled or real-time
export richer data for reports (Assets, Changelogs, Projects, Sprints, Users, etc.)
all directly controlled within Jira
Atlassian Community reports: Jira Cloud for Google Sheets integration
Installation and access issues
Problem: Users are unable to access or find the Jira Cloud for Sheets app after installation.
Solution: Ensure that the add-on is properly installed and that you are logged into the correct Google account. If multiple Google accounts are active, log out of all accounts and log in only with the account that installed the add-on. Additionally, verify that your G Suite admin has enabled access to Google Sheets add-ons for all users.
Authentication errors
Problem: Errors such as ‘no Jira auth’ or HTTP 403 appear when attempting to import issues.
Solution: Try disconnecting and reconnecting your Jira Cloud site through the add-on. If the issue persists, uninstall and reinstall the add-on to establish a new connection. Ensure that your Atlassian account has the necessary permissions to access the Jira data.
Data import limitations
Problem: The add-on fails or returns errors when importing a large number of issues.
Solution: The add-on supports queries of up to 10,000 issues. For larger datasets, use the =JIRA() custom function to paginate through results. For example, to return 20,000 issues, use the following formulas in separate cells:
=JIRA(“project = ProjA order by updated desc”, “”, 0, 10000)
=JIRA(“project = ProjA order by updated desc”, “”, 10000, 10000)
This approach helps manage large data imports effectively.
Empty cells for user data
Problem: Imported data shows empty cells for user-related fields like ‘assignee’ or ‘reporter’.
Solution: The add-on respects individual users’ privacy settings. If a user has made their profile information private, the add-on will return a blank value for that user in certain columns. This behavior is by design to comply with privacy preferences.
General errors during data import
Problem: Generic errors occur when importing issues, displaying messages like “Hmmm … looks like we stumbled a bit, please try again.”
Solution: This error may be due to attempting to import a large number of rows. Retry the import with a reduced number of rows (e.g., 1,000 to 2,000 rows in batches). If the problem persists, disconnect and reconnect your Jira Cloud site through the add-on, or consider reinstalling the add-on.
Tutorial on importing Jira issues into Google Sheets
Why use our app Google Sheets Integration app
- Use Google Sheets to collaborate with non-Jira users
- Share Jira data and reports securely directly from Jira
- Jira Google Sheets integration and exports without size limits
- Include additional data sets such as Jira Assets, Changelogs, Issue Types, Projects, Releases, Sprints, Statuses, Users, and Worklogs
Compare
Features
Jira Cloud for Sheets
Google Sheets Integration
(Cloud, Data Center)
Permissions within Jira
No
Yes
Administrator chooses directly in Jira who can see the exported data.
Users are able to view or edit only the sheets you allow them to. Options are by users, groups, domain users or anyone with link.
Native Jira marketplace app
No
Yes
Export from within Jira
No
Yes
Status counts available
No
Yes
Real time exports
No
Yes
Whenever a Jira issue is updated, the change is automatically shown in Google Sheets.
Exports can be audited
No
Yes
Administrators can see all exports created by any user in the system. Includes used filter, export type, last update, and link to exported sheet.
No
Yes
Bi-directional update
No
Yes
By installing the corresponding free Google Sheets add-on by MobilityStream, issue edits can be synced back to Jira automatically.
Reference data
No
Coming soon
Data such as projects, users, status, change history, releases and sprints will be exported to a separate tab.
Transfer to different Google account
No
Supported
Large exports (over 5,000 issues)
With complex workaround
Yes
Work log data
Aggregated per issue
Yes
Fine grained on separate tab
Export target
Personal Google Accounts
Personal and company Google Accounts
Credentials
User name and password
Installation
Google Workplace Marketplace
Atlassian Marketplace and optional Google Workplace Marketplace
Connections
Google Workplace app to Jira REST API
JQL and filters
Yes
Yes
Function in cell
Yes
No
Ad-hoc export
Yes
Yes
Scheduled export
Yes
Yes for Data Center, Cloud coming soon
Last feature update
June 2020
Ongoing
Need help migrating from Jira Cloud for Sheets to Google Sheets Integration? Contact us.
