Trouble connecting Jira Cloud for Sheets

[Robert Renner]

Has anyone ever encountered an issue when trying to connect Jira Cloud for Sheets? I'm attempting to set this up for the first time, but I'm not being offered an option to "connect" when I open the add-on (see copy of instructions below). Instead, I'm seeing a spinning wheel, and can open the sidebar menu, but everything is grayed out because I haven't connected my Jira account. Any ideas on ways to correct this would be much appreciated.

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.

[MobilityStream]

Hi @Robert Renner ,

I can't help you with this issue specifically but I would check the Atlassian Community. Someone certainly has come across that.

The underlying reason is that 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