Jira Cloud for Sheets: Suddenly "no atlassian token available" and all service broken

[Michael Flores]

My organization has made good use of Jira Cloud for Sheets which has helpfully and successfully allowed us to connect our Jira Cloud software to Google Sheets for years. Today, that functionality appears no longer to work.

1. Open any existing instance of a Google Sheet loaded with a Jira Cloud for Sheets integration.
2. Navigate to "Extensions > Jira Cloud for Sheets > Open."
3. Choose "Get Issues from Jira" and either enter your query information or simply choose "Refresh Issues" if available.

I would expect that the connection between Google and Jira would finish just as it always has and for my sheet to become populated with the desired data from Jira.

Instead, I get a "no atlassian token available" message. After a while, a "Connect your Jira site to get started" message may appear along with a "Connect" button to push. Doing so opens up another Atlassian page asking for permission to connect. If I click accept, the page closes and nothing changes in the sheet. Further attempts to reconnect result in the same as described.

[Michael Flores]

A few minutes later, it seemed to come back. Temporary outage?

[Hannes Obweger - JXL for Jira]

Hi @Michael Flores

unfortunately, Jira's Google Sheets and Excel integrations appear to be quite brittle; if you search this community, you'll find countless posts complaining 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.

E.g., you may want to have a look at the app that my team and I are working on, JXL for Jira. It's 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. JXL 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,

Best,

Hannes

[MobilityStream]

Hi @Michael Flores ,

This one is hopefully only a temporary issue. However, Atlassian basically 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 is directly controlled within Jira. It is a paid marketplace app though but comes with a 30-day free trial.

Kind regards,
The Mobility Team