Jira Cloud for Sheet is not refreshing automatically

Question

Could you help me?

I have configurated Jira Cloud for sheet hourly but this never made a refesh automatically each hour, i need to do this in manual form

Thanks

MobilityStream · Answer

Hi @Daniela Tartabini ,

Disconnecting & reconnecting generally helps. However, usually this doesn't fix it permanently. Definitely worth checking occasionally that the refresh still works. There are many post on the Atlassian Community how to solve this and many similar issues.

If you need a more robust solution, you can try our Google Sheets Integration add-on from the Atlassian Marketplace. It works differently by exporting directly out of Jira via API calls. It is much more reliable and used by many large 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

Lígia Zanchet · Answer

Hello Daniela

Welcome to our community.
I performed a test and my sheet is auto-refreshing:

To ensure seamless functionality, please follow these steps to re-authorize your app:

* Open the Add-on: Launch Google Sheets and open the add-on.
* Access the Menu: Click on the Menu button located at the top-left of the add-on pop-up.
* Disconnect Site: Select "Disconnect Site" to log out of the add-on.
* Reconnect: Log back into the add-on to reconnect your account.
* Authorize Account: Navigate to the SCHEDULE section and select Edit. You will be prompted to authorize your account.
* Set Schedule: After authorization, set your desired hourly schedule. The app will begin polling every hour (or according to your selected schedule).

Thank you!