How might we...
- How might I reduce my experience of overwhelm and anxiety when dealing with big complex projects or too many projects?
- How might I better manage my email?
- How might I reinforce the habit of using checklists?
Hypothesis
Quickly and easily converting checklists into Trello tasks will get me into the habit of using them.
Design
Create a Google Spreadsheet app that converts a checklist into Trello items. Timebox development to one-day.
Use the checklist for one upcoming project.
Metrics
Was I able to create a working app in the time allotted?
How often did I use the app to create Trello items?
How often did I use the Trello items?
Learnings
I was more or less able to create the app in the time allotted, but I got stuck when trying to implement a generic authentication mechanism for Twitter. If I had hardcoded authentication, I probably would have had something working.
Because the app’s not done, haven’t gotten to test it yet!
I’ve felt on many occasions that I’d like to have an app like this, so I feel like the use case for me is strong. Not sure when I’ll be able to prioritize this, however.
Decisions
Questions
Comments
Leave a Reply
You must be logged in to post a comment.
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.
#trellocize