Spreadsheetに編集権限を追加
function addEditors() {
const ss = SpreadsheetApp.openById('')
const listSheet = ss.getSheetByName('')
const lastRow = listSheet.getLastRow()
const arr = listSheet.getRange(2,1,lastRow-1,4).getValues()
let sId,editors,address
//代理店一覧シートに順番に最新のデータを貼り付けする処理
for (i=0; i<arr.length ;i++){
sId = arr[i][2]
editors = arr[i][3]
Logger.log(editors)
address = editors.split(",")
spreadSheet = SpreadsheetApp.openById(sId)
for (j=0;j<address.length;j++){
spreadSheet.addEditor(address[j])
}
}
Browser.msgBox('処理が完了しました')
}