My Google Sheet is not auto populating the JIRAs, I tried many times but only a manual refresh works

[Nehal Majithia]

Only a manual refresh when triggered works auto populates the JIRAs, I want this to be automatically refreshed / populated. Also not being the owner of the sheet I am unable to trigger manual refresh also. 

[Gor Greyan · Accepted solution]

Hi @Nehal Majithia

Welcome to the Atlassina Community!

Can you provide more detailed information about the issue?

Are you using a custom App Script or add-on to fetch Jira data?

[Nehal Majithia]

Thank you this helps 

[Nehal Majithia]

It should auto populate since it is scheduled for hourly refresh 

[Gor Greyan]

@Nehal Majithia

Thanks for the provided information.

There can be different reasons why the update is not being done.

1. It can be run only for the owner, or when the owner is logged out, unverified, or the token has expired -> no refresh happens.
2. If the data is protected, it can be the reason for the refresh. Check if there is a set protection or not.

Please check the above mentioned reasons and let me know.