Import from Spreadsheet

gistfile1.txt

function importFromSpreadsheet()
{
  var vals = SpreadsheetApp.openByUrl("your sheet").getSheets()[0].getDataRange().getValues();
  var target_list = new Trellinator().board("Your Board").list("Inbox");
  
  for(var i = 0;i < vals.length;i++)
  {
    Card.create(target_list,{name: vals[i][0],desc: vals[i][1]})
    .setDue(new Date(vals[i][2]))
    .setCustomFieldValue("Company Name",vals[i][3]);
  }
}