Google Sheets integration - missing issue

[Adolfo Mendez]

Hello,

I have created several Google Sheets reports based on the Jira Cloud for Sheets extension/add-on for a while, without any trouble.

Today, I found that one of the reports failed to import one of the records/issues. It basically skipped that particular issue for unknown reasons.

I tried to build the report again, from scratch, using the Basic, JQL and Filter import types, and all of them failed to import that particular record. In the Jira filter it does show correctly. I have also examined the issue and found nothing that makes it different from others.

Could it be that the issue is corrupted somehow? What else could be causing this inconsistency?

[MobilityStream]

Hi @Adolfo Mendez ,

Unfortunately I don't have an answer for you. Jira Cloud for Sheets is notoriously unreliable. The user community is full of post by users that lose connectivity, see frequent errors, experience various data issues (duplication, missing data, etc.). At this point it is basically unsupported (background here). 

If reliable exports are important to you, 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, Time-in-Status, etc.). Everything directly controlled within Jira. Give it a try.

Kind regards,

The Mobility Team