I am not able to use jira for sheets add on anymore

[JONATHAN RUBEN HERNADEZ GONZALEZ]

I am not able to use jira for sheets add on anymore, this happens when I try to open the jira for sheets.  

[Nicolas Grossi · Accepted solution]

@JONATHAN RUBEN HERNADEZ GONZALEZ Welcome! As you have a premium account, you might want to contact support @ support.atlassian.com

Also you have this add on documentation to check: https://support.atlassian.com/jira-software-cloud/docs/use-jira-cloud-for-sheets/

HTH

Nicolas

[MobilityStream]

Hi @JONATHAN RUBEN HERNADEZ GONZALEZ ,

Atlassian transitioned Jira Cloud for Sheets to maintenance mode, with enhancements discontinued, in summer of 2022 (background here). This has resulted in many user-reported issues and increased system unreliability. The user community is full of post by users that lose connectivity, see frequent errors (503 and others), experience various data issues (duplication, missing data, etc.) If reliable exports are important to your business, we recommend to try our Google Sheet Integration add-on. It works fundamentally different by exporting directly out of Jira via API calls. It is much more reliable and used by the largest organizations. Exports can be one-time, scheduled, or real-time You can also export much richer data to create more sophisticated reports (Assets, Changelogs, Projects, Sprints, Users, etc.). Everything directly controlled within Jira. Give it a try.

Kind regards,

The Mobility Team

[Hannes Obweger - JXL for Jira]

Hi @JONATHAN RUBEN HERNADEZ GONZALEZ

welcome to the community!

Does the issue still persist? Unfortunately, Jira's Google Sheets and Excel integrations appear to be brittle at times; if you search this community, you'll find a number of posts about various kinds of (sometimes temporary, sometimes permanent) problems.

Just as food for thought: If you are open to solutions from the Atlassian Marketplace, there are many alternatives available. Depending on your exact use case, you may even want to consider whether you need to sync back and forth between Jira and Google Sheets at all, or whether you could do all your work in one place, just Jira. I'll add more information below.

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on my last point: If you are open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. This is how it looks in action:

This all happens directly in Jira, using your Jira data - so whatever you chose to do in JXL, your view is always live and fully synchronised. 

Any questions just let me know!