Get Spreadsheet Comments

getSpreadsheetComments.js

var apiKey = "Your API KEY";
function myFunction() {
  var option = googleOAuth_();
  
  option.method = "get";
  
  //Spreadsheet.getActive().getId()をそのまま使うと、エラーになるので一回DriveのFileにかえてからIDを取得
  var res = UrlFetchApp.fetch("https://www.googleapis.com/drive/v2/files/"+ DriveApp.getFileById(SpreadsheetApp.getActive().getId()).getId()  +"/comments?key=" + apiKey , option);
  var json = JSON.parse(res.getContentText());
  Logger.log(json)
}
function googleOAuth_() {
  var oAuthConfig = UrlFetchApp.addOAuthService('drive');
  oAuthConfig.setRequestTokenUrl("https://www.google.com/accounts/"+
             "OAuthGetRequestToken?scope=https://www.googleapis.com/auth/drive+https://www.googleapis.com/auth/drive.file");
  oAuthConfig.setAuthorizationUrl("https://www.google.com/accounts/OAuthAuthorizeToken");
  oAuthConfig.setAccessTokenUrl("https://www.google.com/accounts/OAuthGetAccessToken");
  oAuthConfig.setConsumerKey('anonymous');
  oAuthConfig.setConsumerSecret('anonymous');
  return {oAuthServiceName:'drive', oAuthUseToken:"always"};
}