JIRA Cloud for Google Sheets extension gets overloaded. Any way to fix?

[Bryan Howard]

Hi all, I have a Google Sheets document that uses the JIRA Cloud to Google Sheets extension. I had it set so that certain cells would pull in certain fields from JIRA tickets, and it worked perfectly. It sped up my process quite a bit.

However, after more than a few rows, cells would hang at LOADING... indefinitely. I can only assume it was too many fields being pulled in at the same time (each row probably had a dozen fields being pulled in).

I'm revisiting this idea as inputting all this information manually is taking up way too much time. (And no an export is not feasible for my workflow.)

Any ideas on how to fix this issue, or is it just an inherent flaw with the system and nothing can be done about it?

--------

Alternatively, I would accept even a janky solution like JIRA itself creates a field or private comment that connects all the needed fields in a table that I can just copy+paste to my sheets document.

Any help is appreciated! Thank you.

[Hannes Obweger - JXL for Jira]

Hi @Bryan Howard

welcome to the community!

The Google Sheets integration is provided by Atlassian themselves, so you may want to try reaching out to Atlassian Support. From my experience, the integration is a bit brittle at times (you'll find a couple of related questions in this community), but perhaps they know a solution.

Not sure if this is helpful for your particular use case, but just to put it out there: If you're open to solutions from the Atlassian Marketplace, there's a number of apps available that bring Sheets-style capabilities directly into Jira. I'll provide more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on my last point: If you're open to solutions from the Atlassian Marketplace, this 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 long list of so-called smart columns and history columns that aren’t natively available, including e.g. time in status, and

• a range 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; all this happens directly in Jira, on live Jira data:

This is really just one of a virtually endless number of possible views and reports; you can also view and group by any other issue fields, configure different sum-up styles, etc. etc. Of course, you can also export your data to Google Sheets in just two clicks.

As said above, whether this is useful or not of course depends on your exact use case - just putting it out there in case it is interest.

Any questions just let me know!

[Bryan Howard]

Hey, thanks for the reply! Your app looks very cool but may not work for what I'm needing currently. I will try to reach out to Atlassian Support and see if they can help with anything. Thanks much!