Google Spreadsheet -- Get Sharing Permissions By Script

Is it possible to get list of users and permissions from google spreadsheet by javascript? I have several spreadsheets on shared google drive and I want to check , how are set shar

Solution 1:

Disclaimer - This is my first Goolge Apps script, so I'm not 100% sure this is what you want.

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());
    }
  }
}

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.