Closed epoger closed 3 years ago
Here are some error messages I see in the Javascript console when opening the sidebar:
Jo {message: "There was an error during the transport or process…this request. Error code = 10, Path = /wardeninit", name: "TransportError", stack: "TransportError: There was an error during the tran…/js/4285718584-warden_bin_i18n_warden.js:194:247)"}message: "There was an error during the transport or processing of this request. Error code = 10, Path = /wardeninit"name: "TransportError"stack: "TransportError: There was an error during the transport or processing of this request. Error code = 10, Path = /wardeninit↵ at new Jo (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:194:334)↵ at Oo.v.ad (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:202:350)↵ at Qi (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:89:228)↵ at Pi (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:86:472)↵ at Li.D (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:86:419)↵ at Qi (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:89:228)↵ at Pi (https://docs.google.com/static/macros/client/js/4285718584-warden_bin_i18n_warden.js:86:472)↵ at Oo.
ue @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:56 wf @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:70 (anonymous) @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:11 ig.K @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:97 de @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:49 $d @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:50 Yd.b @ 2495449455-mae_html_user_bin_i18n_mae_html_user.js:46
Hmm... Are you signed into multiple accounts?
Yes, definitely signed into multiple accounts. Seems like I am having this problem more with my company work (Google Apps for Domain), less with spreadsheets opened with my gmail account. But that could just be because the spreadsheets at work are bigger!
Can you sign out of all but your primary account? There's a known bug with add-ons involving multiple accounts being signed in and I'm betting that is the problem.
You can see more info about the bug here: https://sites.google.com/site/scriptsexamples/home/announcements/multiple-accounts-issue-with-google-apps-script
Can you sign out of all but your primary account? There's a known bug with add-ons involving multiple accounts being signed in and I'm betting that is the problem.
I've experienced same issue and by having just one account connected it works normally.
I opened up a browser I don't usually use (Firefox 78.1.0esr), where I am not signed into any Google accounts, and tried the following (which I will call "ATTEMPT 1"):
Then tried ATTEMPT 2:
CONCLUSION: It is indeed a matter of being signed into multiple Google accounts, similar to what is described in https://sites.google.com/site/scriptsexamples/home/announcements/multiple-accounts-issue-with-google-apps-script , but with these caveats:
At any rate, I have my workaround: make sure my default account is the account that has access to the Google Sheet in question.
Thanks to all!
Unfortunately this is a sprawling bug created by the add-on backend so only Google can actually fix it. It's even more frustrating because it can work for months only to randomly fail, like you experienced. In any case, glad the issue was resolved!
Everything was working fine for me as of Aug 28... but today, when I try to open the Export Sheet Data sidebar (on certain spreadsheets), the sidebar is blank inside. (see screenshot)
It seems like the add-on was updated from v59 to v60 since Aug 28, so I am guessing it's something with this version update...
I have seen this on some spreadsheets but not all of them... I have not yet figured out what exactly causes it to fail.