I have set the schedule for "Jira Cloud for Sheet" for one hour. But JQL is not automatically executed every one hour. I have to manually refresh to execute JQL.
Need help to set the schedule for execute JQL automatically in "Jira Cloud for Sheet"
I did find at least one other support case where this was recently reported. In that particular situation we found that the Scheduled Auto-Refresh may not work/Fail because the Google Auth tokens we had for that account seem to have "Insufficient Scope".
In that case the solution was to disconnect the Jira Cloud site and then reconnect it.
Open the Add-on when inside Google Sheets.
Click on the Menu on the top-left of the add-on Pop-up.
Select Disconnect Site. (This will log you out)
You can connect back which will log you back into the add-on app.
At this time if you go SCHEDULE and Edit, it will ask to authorize your account.
Once done, set the Hourly Schedule and it should start polling every hour from then on. (or whatever schedule you desire)
The insufficient authentication scope is a Google side error that may be caused if the google account token has expired after being active for a long time.
However if this is not the solution to your problem here, please let me know. In some cases we have had to create a support ticket to be able to investigate this in more detail here.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.