Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Import from Spreadsheet
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]);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment