Hello @Mohammed Malubhoy ,
This is a known Google Sheets conflict, and stems from multiple account log in order priority causing the app to not know which account to authenticate against due to the browser security protocols to prevent cross site scripting attacks.
The recommendation to solve this is to do one of the following options:
Hello @Earl McCutcheon ,
Thank you for getting back to me.
I log in the browser using only one account, the same one used to authorize the add-on. I disconnected the add-on from our site and re-connected too, with the hope it will resolve the issue. However, the issue still persists.
Thanks for looking into this one, our Google sheets dev team has been looking into the error you noted and have been able to reproduce it and found the cause.
We do not have a workaround at this time, but they narrowed it down to the hourly scheduling timeStyle API endpoint triggering the error:
TypeError: Invalid option : timeStyle
The "timeStyle" API is for "datetime" formatting, and the API call stopped working google side. They are in the process of fixing this one currently and it should be rolled out really soon, however as it's tied to the Google API we do not have a public-facing bug report on this one in our system for this one. So I will make sure to circle back and update you guys when a fix is rolled out.
I just got word from the dev team and we just 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.
Still having the same issue as well. I have followed the suggestions advised, but with no success. Looking forward to a fix, this has been a great add-on!
[Edit] This is working fine now, thank you very much for sorting it!
We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan. &nb...
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