无法向 Google App Scripts 授予授权或许可 [英] Google App Scripts cannot be given Authorization or Permission

问题描述

为什么我无法向同样使用同一 Google 帐户制作的 Google Apps 脚本授予许可/授权?

Why am I not able to give permission/authorization to a Google Apps Script that I also made using the same Google account?

似乎 Google 不信任自己将我自己的 Google Apps 脚本与我自己的电子表格一起使用.

It seems like Google doesnt trust myself to use my own Google Apps Script with my own Spreadsheet.

这是破坏一切的代码行.如果这条线不存在，我不需要许可.

Here is the line of code that breaks everything. If this line doesnt exist, I'm not asked for permission.

var sheet = SpreadsheetApp.getActiveSheet();

所以它试图访问创建此 Google Apps 脚本的电子表格，也是使用我的帐户制作的，但我无法授予权限.

So it's trying to access the spreadsheet that created this Google Apps Script, also made using my account but I cant grant permission.

当我运行上面的代码行时，我被告知我需要授予权限，所以我选择了我已经登录的帐户名.我受到这个错误的欢迎，

When I run the line of code above, I am told I need to give permissions, so I do by selecting the account name I am already logged into. I am greeted by this error,

此应用未经验证

不幸的是，它没有提供合适的文档来进行故障排除.

which unfortunately does not provide competent documentation to troubleshoot.

任何反馈或帮助将不胜感激！谢谢！

Any feedback or help would be much appreciated! Thanks!

推荐答案

点击高级"链接，您将能够授权您的脚本.

Click on the "Advanced" link and you'll be able to authorize your script.

这篇关于无法向 Google App Scripts 授予授权或许可的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！