gistfile1.txt

function triggerRegistration()
{
  var configs = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Configuration").getDataRange().getValues();
  var ss = SpreadsheetApp.openById("ACTUALIDHERE");
  var config_sheet = ss.insertSheet("Configuration");
  
  new IterableCollection(configs).each(function(row)
                                       {
                                         config_sheet.appendRow(row);
                                       });
  ScriptApp.newTrigger("updateCardFromSheetTrigger")
  .forSpreadsheet(ss)
  .onEdit()
  .create();
}

function updateCardFromSheetTrigger(event)
{
  var lock = LockService.getScriptLock();
  lock.waitLock(10000);
  var sheet_name = event.range.getSheet().getName();
  var values = event.source.getSheetByName(sheet_name).getRange(event.range.rowStart+":"+event.range.rowStart).getValues()[0];
  var board = Board.findOrCreate(sheet_name);
  
  try
  {
    board.addMember(new Member({username: "REALUSERNAME"}),"admin");
  }
  
  catch(e)
  {
  }
  
  if(values[1].trim() || values[0].trim())
  {
    if(values[0].trim())
      var card = new Card({link: values[0].trim()});
    else
    {
      var card = Card.create(board.findOrCreateList("SOMELIST"),values[1]);
      event.source.getSheetByName(sheet_name).getRange("A"+event.range.rowStart).setValue(card.link());
      SpreadsheetApp.flush();
    }
    
    card
    .setName(values[1])
    .setDescription(values[4]+" "+values[3])
    .setDue(new Date(values[6]));
    
    if(values[5])
      card.postComment(values[5]);
  }
  
  lock.releaseLock();
}