How to know when fail to download all JIRA issues to the google sheet?

Manjunatha K March 11, 2024

This is regarding Get issues from JIRA to the Google spread sheets:

I have set auto refresh at every hour. Some times once in a while it does not download all JIRA issues. It stops midway.  How to know any such errors?



We have built automation sending out executive reports to the management teams. It is really embarrassing as we do not get the right report sometimes. 

Best way is if not complete then you trigger refresh again so that should bet all issues as per the filter. Otherwise let us know how to catch this exception in the google sheet and take necessary action. 

Thank you 

1 answer

0 votes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2024

Hi @Manjunatha K ,

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

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events