开发者

Google Sheets Add-On - Show Side Bar Error

We recently published a google sheet add-on(Reviewed and approved by Google OAuthTeam & Workspace Team).

The add-on upon user action from a menu item - fetches data from a REST API. When the response from the REST API is 200 OK - launches the side bar.

This seems to be working at the time of development. But NOT working as add-on. The error that I see in the cloud logs is as follows.

Exception: You do not have access to perform that action. Please ask the owner of this item to grant access to you.

  var html = HtmlService.createTemplateFromFile('dashboard').evaluate()
   .setTitle("Dashboard").setSandboxMode(HtmlService.SandboxMode.IFRAME);

    var ss =  SpreadsheetApp.getUi(); // Or DocumentApp or SlidesApp or FormApp.
    ss.showSidebar(html);

It fails in the line ss.showSidebar(html);

"Test Deployment" as "Installed for current user", "Enabled in current document", "Installed and Enabled" DID NOT throw any errors

I have seen an issue of similar kind reported in Issue Tracker here but that's pretty old. So not sure if that's still valid.

Any help/guidance on this subject would be very much appreciated.

  • This add-on is working on a Windows machine/Chrome browser
  • This add-on is working on 开发者_运维知识库a MacOS Catalina/Chrome browser
  • This add-on is NOT WORKING on a MacOS Monterey M1 Chip/Chrome browser
  • This add-on is working on a MacOS Monterey M1 Chip/Safari Browser with a strange behavoiur - Every Google Script that you call opens a new tab on the browser
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜