I have tried to pull the Issues to Google Sheets using JQL and scheduled to pull the data every 4 hours. It worked fine without any issues.
After a day I am unable to get the Auto Schedule to work. I am getting an error that "
Multiple Google accounts?Google Sheets add-ons may encounter unexpected errors if you are using multiple Google accounts. Please try again while only logged into Google Sheets with the account used to install this add-on.
I do not have any other google accounts set in my computer but unable to resolve this error. Tried Uninstalling the addon and re-installed still no go.
I would really need this to be fixed to run reports for ease of use.
Hello @Shyam Sunder Reddy Gade ,
My unconfirmed guess here is that something changed google side recently relating to user sessions being refreshed in mass as you are not the only one to experience this error recently. However I am unable to find anything in Google support noting any changes were applied and could be related to a security update in the background that has not been made public.
Check out the following thread where I discussed this error with another user yesterday:
But ultimately this is a known conflict in multiple user session with Google sheets, and the recommendations to get around the error as noted on the other thread is to either:
Let me know how it goes, or if you still see the error afterwards so we can take a closer look.
Hello @Shyam Sunder Reddy Gade ,
I just updated the other thread as well, but I am reiterating the info here too to make sure you see it, Our Dev team dug into this error a bit further with me and it looks like this was a deprecated API on google sheets that caused a communications issue between Jira and Google.
I just got word from the dev team and we pushed out v2.3.3 of the google sheets add-on to production that removes the deprecated API check and you should be good to go.
If any error persists uninstall / re-install google sheets to get the latest version and let me know if you are still seeing any additional errors so we can take get you in touch with our support team to take a closer look at your environment to verify this is the same cause.
Same problem occurs on my instance and I was able to narrow the issue further down: It only appears after you switch in the Schedule to "Hourly".
I was able to setup a new GSheet, connected it with Jira and setup a daily schedule. After opening again the Schedule tab and changing it to "Hourly" the known error message appeared immediately in the new GSheet.
Based on that observation I would assume it's maybe an issue in Jira.
Just as mentioned by @Earl McCutcheon, we identified that this error is caused by a global issue that is currently affecting several customers using Google sheets.
We received an update about an hour ago from our internal support team that the problem was properly addressed and the fix is currently being deployed to the Atlassian Cloud sites.
That being said, can you please confirm if you're still facing this error today?
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. In this video, I'll share my favorite Trello templates. Templates mentioned in ...
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