Google Spreadsheet. read / write test.

io.gs

/*
   App -> SpreadsheetFile -> aSheet -> Range -> Cell/Value
*/

function readObject() {
  objectPool = SpreadsheetApp.openById(read_sheet_id).getSheetByName('sheet1').getRange(1,1,20,20).getValues();
}

function writeObject(){
  SpreadsheetApp.openById(write_sheet_id).getSheetByName('sheet3').getRange(1,1,20,20).setValues(objectPool);
}

main.gs

read_sheet_id = 'xx';
write_sheet_id = 'yy';
objectPool = {}; // not reauired.

function main(){
  var lockf = LockService.getPublicLock();
  if(lockf.hasLock()){
    Browser.msgBox("lock 済みです。だれかがスクリプトを実行中。");
    return;
  }
  try{
  lockf.waitLock(10000);
  }catch(e){
    SpreadsheetApp.openById(read_sheet_id).getSheetByName('sheet1').getRange(21,i++).setValue("lock 失敗");
    Browser.msgBox(e);
    return;
  }
  readObject();
  writeObject();
  lockf.releaseLock();
}

add lock sys.