Google Spreadsheet-通过脚本获取共享权限 [英] Google Spreadsheet -- get sharing permissions by script
问题描述
是否可以通过javascript从Google电子表格中获取用户和权限列表?
Is it possible to get list of users and permissions from google spreadsheet by javascript?
我在共享的Google驱动器上有几个电子表格,我想检查,如何通过脚本设置共享权限.我正在与20多个其他用户共享这些电子表格,因此很难手动检查每个电子表格.
I have several spreadsheets on shared google drive and I want to check , how are set sharing permissions by script. I am sharing these spreadsheets with more than 20 another users, so it is difficult to check every spreadsheet manually.
有可能吗?
是否可以在整个Google驱动器上方也运行一些脚本?例如,如果我想获取具有共享权限列表的驱动器上所有google spredsheets和文件夹的列表,我可以在google驱动器上方编写一些JavaScript吗?
And is it possible to run some script also above whole google drive? For example if I would like to get list of all google spredsheets and folders on drive with sharing permissions list, can I write some javascript above google drive?
非常感谢
推荐答案
免责声明-这是我的第一个Goolge Apps脚本,因此我不能100%地确定这就是您想要的
我使用了 DocsList
API列出所有者,编辑器和查看者 /reference/spreadsheet/spreadsheet"rel =" nofollow noreferrer>电子表格在给定的Google云端硬盘文件夹中:
I used the DocsList
API to list the owner, the editors and the viewers of every spreadsheet in a given Google Drive folder:
function start() {
var folder = DocsList.getFolderById("...put folder ID here..."),
files = folder.getFilesByType(DocsList.FileType.SPREADSHEET), file = null, spreadsheet = null,
owner = null, editors = null, editor = null, viewers = null, viewer = null,
i = 0, j = 0;
for (i = 0; i < files.length; i += 1) {
file = files[i];
Logger.log("===== Spreadsheet " + (i + 1) + "/" + files.length + ": " + file.getName() + " =====");
spreadsheet = SpreadsheetApp.openById(file.getId());
owner = spreadsheet.getOwner();
Logger.log("- Owner: " + owner.getEmail());
editors = spreadsheet.getEditors();
for (j = 0; j < editors.length; j += 1) {
editor = editors[j];
Logger.log("- Editor " + (j + 1) + "/" + editors.length + ": " + editor.getEmail());
}
viewers = spreadsheet.getViewers();
for (j = 0; j < viewers.length; j += 1) {
viewer = viewers[j];
Logger.log("- Viewer " + (j + 1) + "/" + viewers.length + ": " + viewer.getEmail());
}
}
}
请注意,查看者列表也包含评论者,这两个组没有被此API分隔.我测试了这段代码,它对我有用.您可以轻松地将其概括为遍历每个文件夹.
Note that the list of viewers contains the commenters too, these two groups are not seprated by this API. I tested this code, and it works for me. You can easily generalize it to iterate over every folder.
这篇关于Google Spreadsheet-通过脚本获取共享权限的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!