Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira Cloud for Sheets - getting no jira auth error


Hi all,

JIRA Cloud of Sheets was working normally previously for my Google sheet, but today when trying to extract data it shows me "no jira auth" error and a blank panel.

All functions are enabled

I even tried to disconnect and connect the site once again but without luck. All formulas look correct.

Interesting that when I made a copy of file and execute the same steps, everything works fine.

Could you please advise what can be an issue or what else should be checked on my side?


2 answers

Faced the same issue, and found out that Jira Cloud for Sheets works correctly only when authorized in Jira on the behalf of the owner of the google account. If you have editing rights and authorize in Jira, then that gizmo will show whatever error from jira no auth (though JQL works, and it fetches some data from jira) and syntax error to Jira - unkown function. Truly misleading.

Solution that worked for me - create a new google sheet in your google account, copy-paste the data (or simply the formula), revoke the Jira Cloud access (if any), give it again, disable and enable the JIRA function switch on the Get issues from Jira tab.

0 votes

Hello @Yuliia Levchenko ,

Thanks for reaching out, and the error "no jira auth" can have a few different causes but it is going to be tied to the google authentication token being interrupted or blocked in some way.

The first thing to check is for a local browser issue, check out the KB article "Browser Troubleshooting Guide" under the "Indispensable tests" section.   With a primary focus on the options to try logging into your Sheet from another browser and/or Incognito mode, as well as flushing cache.

Next, make sure the browser is up to date with the most recent version, and log out of the Browser, and then log back in to establish a new authentication token.

Then verify the document owner, and try changing the owner if there is a known issue with the current owner's account.  Alternatively, try creating a new document where you are the owner to verify if the issue exists in the specification sheet.

Let me know what you find while testing.


Hello @Earl McCutcheon  

I'm facing the same issue. Asked a few of my colleagues to refresh the sheet in which I'm having the problem and everyone got the same error. It had been working fine for a couple of months. Making a copy of the sheet works. I tried disconnecting, disabling and re-enabling JIRA() but didn't work. Also, tried by uninstalling and re-installing JIRA Addon. 



Hello Dinesh,

Thanks for reach out about this issue. From what you stated about Copying the sheet allows it to start working which leads me to believe the original sheet is having an issue with the 'owners' token and thus not working.

For the original sheet, could you verify or change the owner and let us know if that allows it to start working?

Stephen Sifers

Hi @Stephen Sifers 

Thanks for your response. I got ownership moved to me and still facing the same issue. After transferring ownership to me I even tried by disconnecting and then reconnecting. 



When I pull data in the same sheet through JQL (in place of JIRA()) it works but I need JIRA() to work in my sheet. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

143 views 1 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you