Synch spreadsheet

gistfile1.txt

function addOrUpdateSpreadsheetRow(notification)
{
  var moved = new Notification(notification).movedCard();
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Card Data");
  var values = sheet.getDataRange().getValues();
  var link = moved.link();
  var existing_row = false;
  
  for(var i = 0;i < values.length;i++)
  {
    if(values[i][0] == link)
    {
      existing_row = i+1;
    }
  }
  
  if(!existing_row)
  {
    sheet.appendRow([link,moved.name(),moved.description(),Trellinator.now().toLocaleString()]);
  }
  
  else
  {
    sheet.getRange(existing_row+":"+existing_row).setValues([link,moved.name(),moved.description(),Trellinator.now().toLocaleString()]);
  }
}