Jira cloud for google sheets showing message 'no jira auth'

[Pierre Perez]

I have a google spreadsheet that I've been using to view Jira issues using the Jira() function.

And today it stopped working and it just outputting the text 'no jira auth'

I tried to disconnect and reconnect the plugin but it not working.

any idea ?

[Nikola Perisic · Accepted solution]

Welcome to the community @Pierre Perez ,

Can you tell what is the name of this plugin so I can test it?

Br,

Nikola

[Nikola Perisic]

I assume that this is Google Sheets Integration app. I'd suggest generating a new Jira API key and then reconnecting the plugin again. 

If it doesn't work again, contact their support here: support@mobilitystream.com

[Pierre Perez]

Hi ! 
Thanks for your response, 
it's Jira Cloud for sheet : 
https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?tab=overview&hosting=cloud

[Nikola Perisic]

Hello @Pierre Perez ,

This is where people had the exact issue: https://community.atlassian.com/t5/Jira-Content-Archive-questions/Jira-cloud-for-sheets-connection-issues/qaq-p/1861945

Solution: Raise a ticket for the Atlassian so the developers can take a look at it.

[Pierre Perez]

Thanks @Nikola Perisic

How can I raise a ticket ? (I thinked it's here)

[Nikola Perisic]

This is more related to the specific questions that community can solve. Also, you can raise it here: https://support.atlassian.com/contact/#/

If you liked my answer, please mark it as accepted. Thanks!

BR,

Nikola

[MobilityStream]

Hi @Pierre Perez , @Vivian Lima ,

Atlassian transitioned Jira Cloud for Sheets to maintenance mode, with enhancements discontinued, in summer of 2022 (background here). This has resulted in many user-reported issues and increased system unreliability. The user community is full of post by users that lose connectivity, see frequent errors (503 and others), experience various data issues (duplication, missing data, etc.) If reliable exports are important to your business, 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, etc.). Everything directly controlled within Jira. Give it a try.

Kind regards,

The Mobility Team

[Vivian Lima]

There is a ticket about it.

https://jira.atlassian.com/browse/API-712 

you can click on "This affect my team"