I spent about two hours the past two days playing with Google Apps Script and researching the Trello API. I’ve got something basic that parses the spreadsheet. Now I need to create Trello cards.
I tried using this library, but the authorization code went into an infinite loop. I think the easier thing to do is to just hard code the authorization for now, at least to get this working. I can play with a more elegant solution later.