Create cards from Sheet

gistfile1.txt

function createCardsFromSheet()
{
  var data = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("My Data").getDataRange().getValues();
  var my_board = Board.findOrCreate("My Data");
  
  if(data.length)
  {
    var column_names = data[0];
    
    for(var i = 1;i < data.length;i++)
    {
      var card = Card
                 .create(my_board.findOrCreateList(data[i][0]),data[i][1])
                 .setDescription(data[i][2]);

      for(j = 3;j < data[i].length;j++)
      {
        if(data[i][j].trim())
          card.setCustomFieldValue(column_names[j],data[i][j]);
      }
    }
  }
}