尝试访问Google Apps脚本编辑器时没有此类用户

问题描述:

在我的Google电子表格中,当我转到工具->脚本编辑器.."时,出现一个页面,显示没有这样的用户"错误.任何想法如何解决这个问题? 我认为这可能是权限问题,但不确定是否需要更改权限.

In my Google spreadsheet, when I go to "Tools->Script Editor..", I get a page saying "No Such User" Error. Any idea how to fix this? I figure this could be a permissions issue, but not sure how to change permissions if required.

最后,我偶然发现了解决方案. 通过在驱动器中启用GoogleAppsScript,可以解决此问题.

Finally i found the solution accidentally. The issue is resolved by enabling GoogleAppsScript as part of your drive.

在网络浏览器中打开Goog​​le云端硬盘. 单击新建>更多> +连接更多应用 然后选择GoogleAppsScript.

Open Google Drive in your web browser. Click New > More > + Connect more Apps and then select GoogleAppsScript.

一旦完成此操作,返回电子表格的脚本编辑器,就不会再出现任何错误了.

Once i did this going back to script editor of my spreadsheet, no more gives any error.

这是包含此步骤的链接: https://developers.google.com/drive/v2/web/quickstart/apps-script

Here is the link which contained this step:- https://developers.google.com/drive/v2/web/quickstart/apps-script

在尝试运行脚本时,还有关于Invalid OAuth Client的其他问题.由于每个应用程序脚本都必须附加到Google Cloud Project,因此我面临着这一问题.只有最初创建文件的人才能访问此文件,即使文件已在团队驱动器中也是如此.在这种情况下,您需要进入文件"->制作副本",以使应用脚本的副本可用.然后在资源"下拉列表中,您将看到Cloud Platform Project,单击它之后,您现在可以提供您在console.cloud.google.com上创建的Google Cloud Platform项目的项目编号.

Also there is additional problem about Invalid OAuth Client when trying to run the script. which i faced since each apps script has to be attached to a Google Cloud Project. This is accessible only to the person who originally created the file even after its in the team drive. In which case, you need to make a copy of the apps script available by going into File->Make a copy. And then in the Resources drop down , you will see Cloud Platform Project, upon clicking it you can now give the project number of the Google Cloud Platform project you created on console.cloud.google.com.