nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Clouds for Sheets not working (December 2021)

mateus.santos

Hi,

I have a recent issue that started at the beginning of this last week of November, 2021.

I use Jira (Jira Clouds for Sheets) integration in Google Sheets to extract data and do automations. This search always worked normally, but now it's showing this "no site selected" error (picture attached below) in the cell of the spreadsheet that the search is being done on.

Can anyone tell if there has been any change in permissions? Any new updates that prevent Google Sheets from working the API?

I haven't found anything about it anywhere!

Screenshot from 2021-11-29 09-18-31.png

Accepted answers

Earl McCutcheon

Hello @mateus.santos ,

It looks like Google Sheets is having an issue reconnecting after an auth token expiration.

To correct this open the Jira Cloud for sheets Extension in the sidebar of your sheet by going to Extensions >> Jira Cloud For Sheets >> Open and select the "Disconnect site" option towards the bottom of the sidebar:

Screen Shot 2021-12-01 at 1.53.06 PM.png

This should disable that app in the sheet and then redirect you to the following link on the Atlassian Identity platform where you will want to select the Disconnect option for the "Jira Cloud for Spreadsheets" app, located under the "Apps with access to your accounts" section:

https://id.atlassian.com/manage-profile/apps

Screen Shot 2021-12-01 at 2.11.06 PM.png

After the site is disconnected go back to your sheet and go to Extensions >> Jira Cloud For Sheets >> Open then go through the steps to authenticate to the site and you should be all set with a manually refreshed authentication token for the connection.

Let me know how it goes.

Regards,
Earl

All comments

guilherme.boaviagem

Same error here. We don't run automations, but we use the API to fetch data and speed up our sprint planning/review. I'd really appreciate some guidance on this. Thanks for bringing this up, Mateus.

Alessio_156fq0

Same here! How can I fix this?

Earl McCutcheon

Hello @mateus.santos ,

It looks like Google Sheets is having an issue reconnecting after an auth token expiration.

Screen Shot 2021-12-01 at 1.53.06 PM.png

https://id.atlassian.com/manage-profile/apps

Screen Shot 2021-12-01 at 2.11.06 PM.png

Let me know how it goes.

Regards,
Earl

Dave Thompson_o9r733

@Earl McCutcheon We are having the same error, the steps you provided didn't fix the issue.

It seems to only happy with the JIRA function. I can successfully use the sidebar to pull in issues with JQL.

This started on 30th November for us.

Alessio_156fq0

Followed the instructions, still doesn’t work. I still get 'no site selected'. Please advise

mateus.santos

Thanks for the support, I followed exactly these steps and managed to solve! There really should be something wrong with the expired access token!

For those of you who still haven't managed to resolve this issue, please update your status on this issue here! My theory is that it could be something related to the creator/owner of the spreadsheet that needs to do this for the token reset to work, but I believe that only with tests it is possible to know.

Alessio_156fq0

No, I am the creator of the sheet in this case

Earl McCutcheon

Hello @Alessio @Dave Thompson & @guilherme.boaviagem

I've been in contact with the Jira cloud for sheets Dev team and they just pushed an update on the backend that should help out here and fix the Deauthorization issue causing the sheet to disconnect from Jira.

At most, any affected user should only have to re-auth to Jira once as defined in the steps listed in my comment earlier (if you were deauthed before this new release was pushed out), but you should not lose auth subsequently.

Please retry the manual reload process I noted earlier and I would also recommend a cache flush on the browser before doing so as well just in case something is getting held onto in the cache that is causing additional failures in the background. let me know if you see any issues with repeated deauthorizations from here on out and we'll take a closer look.

Regards,
Earl

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

google-sheets