Google Apps Script Adventures

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.


First Attempt at Using Duende’s Clarity Toolkit



  • This was pretty easy to fill in, because I use Trello pretty extensively. But simply adding the additional discipline of using the Eisenhower Matrix is oh so valuable!
  • I like the day labels! They add a useful dimension to the matrix, and they’re also fun.


  • The different headers on the left side versus right side of the page are confusing me. Are you testing two different designs? I’m assuming each page is one week?
  • Wish I had a slash between month and day on the headers.
  • I know what the legend (with the dot, star, etc.) is for, because you explained these to me the other day, but without that explanation, I would have been completely disoriented and would have probably ignored these. I kept these empty at first, then just ended up filling in the days. I suppose this would make more sense if I were using this in a chunk larger than weekly (which I suppose I have the option for on the left side), but you’re making me think pretty hard to understand this, and I’m not sure I’m getting the requisite amount of value for that.
  • Not sure what the dotted lines above the quadrant are for.
  • I just realized that I put things in the wrong quadrant. Because of where the labels are, I assumed that the Urgent-Important quadrant was on the upper left rather than the upper right.
  • Or maybe I did put it in the right place? I noticed the lower right is shaded, perhaps implying that I should de-prioritize those items because they’re less urgent and less important?


WhatsApp for Collisions

Alexa’s team created a WhatsApp group for our #collision experiment. This, in itself, is a bit of an experiment; we’ll see if it encourages sharing / checkin accountability. Jake and Eric said hello on the group, but so far, no other pair other than Rob and me have shared a checkin takeaway.

Biorhythms Background

I was inspired to try this experiment after reading this personal productivity article. For the most part, there was nothing new for me in this article, but I was intrigued by the section on tracking your biorhythms. I decided to basically try his experiment almost exactly — same frequency, same time period, same dimensions (i.e. Energy, Focus, Mood). The only difference is that I chose a five point scale rather than three. (I noticed he was using decimal points, which to me defeats the benefits of using a three point scale.)

A few things I’ve noticed after a few days of tracking:

  • It’s challenging to answer these questions consistently. What’s the difference between Energy and Focus?
  • My mood doesn’t really fluctuate based on time of day.
  • I’m not noticing any cycles, and I’m not sure that any of these dimensions are strongly correlated to time of day (other than I have more energy in the beginning of the day than the end). All three dimensions also seem related to type of activity (e.g. exercise, meetings, writing, eating, etc.).


Social Media Experiments Updates

I published, “Invisibility Doesn’t Serve the Work,” on June 20, 2017. I simultaneously shared a copy of it on Medium and a link to it on LinkedIn.

On LinkedIn, I got 197 “views of post in the feed.” Previously, I had gotten 33 and 65 views of the full articles I had shared there. However, clicks are probably a better comparison, because the feed view only contains a few sentences and the link. According to Google Analytics, I got 7 clicks from LinkedIn.

Engagement-wise, my sharing received 4 likes and 0 comments (compared to 5 likes and 0 comments and 25 likes and 5 comments previously).

There were two views on Medium after the first day, but no reads. Then I asked Kate to click on Recommend. Since then, the post had 11 views, 5 reads, and 2 recommends (vs 2, 0, 0 and 2, 1, 0 previously).

In both cases, I shared in the morning, which may have had something to do with the engagement numbers.

#linkedinrepublishingvslinking #mediumcrickets

Lessons from our second Colearning Retreat

Reflections / Next Steps for Colearning:

  • Brooking:
    • Was so tired. Now energized again, partially because of brownie bits, partially because of conversation with Eugene. Didn’t know what I wanted to do, made up goals, appreciated that every conversation I had with all of you I learned. Open Space seemed like right approach.
  • Anya:
    • What a gift to have all of you in this house, time together. Brought love and light to this place that will continue after you leave.
    • Appreciated everyone’s support
    • Didn’t check off fully anything. Half checks. Feedback: You already did it, so freakin’ finish it. The stuff that I defined for myself is done, just have to complete it.
    • Next time, want to be more clear with self and what I want to do. Just being a part of conversations I learn so much. Got a lot, and really appreciated that. Hard for me to ask for stuff. Still want to know what everyone else is working on.
      Realizing how amazing it is to ask for help, have someone else ask to jam on things. Now feeling like might reach out and ask if anyone wants to talk, know that people will be honest with me. Feel like wasn’t there for me on Slack.
  • Shirley
    • Hesitant to come. “I’m not ready for this. I need to spend time in my own cave and be ready with questions.” Eugene: “This is our cave.” Perfectionist in me, not prepared to interact with people. Internal struggle.
    • Worked on personal vision statement yesterday. Appreciated and accomplished some of the other things
    • Great opportunity to be present with you all
  • Renee
    • Like that we set out Solo time and Peer time on second day. Appreciated that little bit of structure. Knew that could have quiet time during Solo time.
    • Haven’t done full Open Space before, so neat to see that take shape.
    • Loved the peer exchanges. In beginning, checkins were rich and wanted to have conceptual conversations. That idea wasn’t as interesting as real peer support. Glad switched gears in my head.
    • Hard to ask for peer support unless it’s reciprocal. Maybe there’s a way to frame it to encourage it?
  • Odin
    • Really appreciated this space
    • Practice of taking the space. How do you structure it? Really good at it in some ways, bad at others. Get leaky and lazy.
    • Liked the Open Space. Jump in and say, “Here’s how it could look.” Liked serendipitous solidarity. Like anchors of group checkin time as well.
    • Checked all boxes. Not complete, but enough work for set of nested maps guiding me moving forward.
  • Kate
    • Second Renee’s comment about getting estimates in advance for private vs peer work. Coming in for second day felt a bit out of sync. Have to own that, but if knew that this group really needed solo time would have helped.
    • January was much smaller group. Doing peer stuff easier. As we add a few people, having more knowledge helps. Doing short WYDWYD videos in advance, and committing to watch.

Next time:

  • More breaks
  • More clarity on timing. A lot of things that were planned didn’t happen because flowy. Time, but more clarity helps.
  • In advance: What percentage do we want for Solo vs Peer support?
  • More of a push to have it structured in advance.
  • Do another in January. January and June works well.
  • Experiment: Monthly call to check in on each other’s work. Virtual brown bag? Peer assist? Turn it into video blog? Record on Zoom. Anya will organize. Odin can offer Zoom account. Lunch time? Odin will help. Design week of? Can nudge each other.
  • Experiment: Odin hosting lessons learned summit. Possible quarterly complement. Anya, Brooking.
  • Process for on-boarding, off-boarding. Kate and Eugene and Brooking.

Thank Yous and Checkouts

  • Eugene for fiat
  • Anya for hosting
  • Snacks
  • Talking about my feelings
  • Helped my dog feel comfortable and heal
  • Context in which I feel like I can help. Pleasure of feeling support and mutuality of it
  • Appreciating Kate for going with flow. Didn’t fully give her space to get into the schedule
  • Learned something from every one of you
  • Beginning of colearning, wanted more than online watercooler, but wasn’t able to swing with the checkin. Becoming more of what I wanted it to be initially. Interesting reflection.
  • “If you meet a man of great intellect, you should ask him what books he reads.” This group has expertise in rare space. Couldn’t take on current and potential work if didn’t have something like this behind me. If there’s something I don’t know, know that I can ask you all. Huge. Amazing to think of all of us doing that.
  • Eugene printing out stuff. Enjoyed being off duty in that way.
  • Welcoming me into this. Generosity with which you shared your own experiences. Reading Radical Hope. Kind of feeling this is a group that inspires.
  • Amazing to be in community that recognizes each other’s strengths and sees power in that. Mutual recognition that everyone has knowledge, power.
  • Practice of setting day aside
  • Not coming at collaboration directly. Group that believes and practices and sees power in individual work and collaboration. How do we make space for those collaborations to build? Learn so much by being in conversation about it.
  • Never experienced a group so expert and so easy to be a part of it. Everyone approaches it as, “We’re all learning.”
  • Collective leadership! It’s awesome!


Just shared a link to…

Just shared a link to my latest Faster Than 20 blog post on LinkedIn. Looking forward to tracking engagement with posting a link vs writing a LinkedIn article.


Spire Weekly Report

Another cool feature of #spire: Sending weekly reports that compares your aggregates to others similar to you. Here’s mine from last week:


Final Martian Takeaway

It was fun! I actually looked forward to doing it today!


Muscles for Lightweight Sharing

As I said in yesterday’s #themartian takeaway, I felt like I had something significant to share after each chunk of the day. The experiment was to share just one short takeaway at the end of the day, which actually wasn’t supposed to be an exercise in constraint, but of abundance.

Of course, if I had more to share, there was no reason for me not to do a longer takeaway (which is something I might experiment with later) or to share multiple takeaways. If I felt shy about occupying extra screen time (which I do), I could have found other ways to share — a note on the E3 WhatsApp channel or on my Colearning Slack, even a tweet or *gasp* a blog post!

In a lot of ways, I did this experiment as a way to see if I could encourage others to start sharing. I feel like my muscles for sharing are strong, and they are, especially in comparison to others in my community. At the same time, I’ve been generally unhappy with the low frequency of my sharing over the past year. I’m trying to correct it by investing in higher-level narrative and storytelling and by writing more blogs, but there are lighter-weight things I could be doing that might be tremendously beneficial.

Of course, I already knew that, but I haven’t been acting into it. I confused muscle tone with strength, when the reality is that my sharing muscles have atrophied. Even though I do a lot of internal sharing on my different projects and in my different communities, I can be doing more and a better job of it. This experiment has been a surprising reminder in that.

Possible ideas?

  • Ever since Genentech in 2010, I’ve experimented with video as a way of reporting out after and even during meetings.
    It’s always worked well, and has even become a signature in some projects, but it’s never been a discipline, especially a personal one. I could try it on for a few weeks. Because these would involve other people, it might naturally help build other people’s muscles (and mindsets) around this as well, which is one of my goals.
  • I could do an experiment around sharing a tweeted takeaway after every meeting or chunk of my day.
  • I want to create an external guide for following / stalking me. There needs to be channels for different frequencies and levels of communication. Crafting a guide would not only help my engagement with others, but it would force me to develop an actual strategy. This would have ramifications for my projects as well, because this kind of thinking is useful for community engagement in general.

As I also mentioned on my video yesterday, this experiment has also been a surprising reminder to me of the importance of pausing, which was not the intent, but which I clearly need to strengthen.