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
精彩评论