Jira Cloud for Google Sheets is not working

[Orly Dahan]

Hi,

For some reason, I cannot use the "Jira Cloud for Sheets".
I can see that it is installed, but it is not available - see print screen
Did someone else encounter this issue?

[Becky Brooks - Visor for Jira · Accepted solution]

Hi @Orly Dahan ,

Did you mean to attach an image? I don't see one. 

Looking at old community posts, there seems to sometimes be some snafus that later resolve themselves. You can view that here: https://community.atlassian.com/t5/Jira-questions/Jira-Cloud-For-Sheets-Outage-March-2022/qaq-p/1960391

Here's another thread where users encountered issues and altered JQL to fix it: https://community.atlassian.com/t5/Jira-questions/Failing-to-fetch-issues-using-JIRA-Cloud-for-Sheets/qaq-p/1817346

If you continue to run into issues or can't solve this one, an alternative to connecting Jira with Google Sheets with Jira Cloud for Sheets is using a spreadsheet that is designed to sync with Jira. Visor is one such spreadsheet. You can also export data as a CSV and import to Google Sheets that way. Or, just share in Visor: https://marketplace.atlassian.com/apps/1226209/visor-flexible-spreadsheet-for-jira-roadmapping-bulk-edits?hosting=cloud&tab=overview

I hope that helps! 

- Becky @ Visor

[Orly Dahan]

Hi Becky,

The issue comes from Google sheet - the option is not available:

[Peter Milburn]

Any known or reported issues in Feb 2025? I'm getting errors but I'm not sure if its me, localized or something bigger. 

[MobilityStream]

Hi @Orly Dahan ,

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