A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards. Sync with a Google Apps Script or serverless function on Google Cloud.

Now that gyms are closed, I’m using Peloton more and I love how Peloton tracks everything. But I always found it difficult to browse through previous workouts with the user interface on the tablet on the bike. What if I wanted to see summary stats just for 20-minute classes? What are my personal records for a given time period? I know they exist on the app somewhere, but I just want one place to visualize and analyze the data that matters to me.

I looked into how to get my Peloton data to do some custom sorting, filtering, and analysis…

This tutorial shows how Google Sheets, ClickUp, Monday.com, Wrike, Smartsheet, Notion, and Coda handle task dependencies for a project.

This post originally appeared here.

Your project may contain tasks that depend on each other. Sometimes a task cannot start until its dependent (predecessor) task finishes, or maybe the task can start when its dependent task starts as well. As you manage tasks with these more complex dependency types (FS, SF, SS, FF), you may find more specialized software or SaaS tool to help you plan and visualize these tasks.

Goal of this post

This post doesn’t show the pros and cons of each platform, nor does it pick a “winner” that can handle this use case perfectly. Every team and project manager has…

Tutorial on exporting your Jira issues into Google Sheets and Coda, and comparing the two different platforms for analyzing and syncing Jira issues.

Once your Jira backlog of issues grows to a certain point, you may want to view all your issues in another format like a spreadsheet to figure out what your team should focus on. In a spreadsheet, you can quickly filter, sort, and organize issues by multiple dimensions like priority, due date, and status. The issue is that the spreadsheet is only a snapshot of your Jira issues. As your team makes updates in Jira, those updates to sync to your spreadsheet unless you use an add-on like Jira Cloud for Sheets. …

Recap of the Coda August 2020 meetup with Kevin Levine, Associate Director of Colleague Relations @ Hyatt Hotels in NYC

A hospitality veteran

For August 2020’s virtual NYC meetup, I had a chance to speak with Kevin Levine, Associate Director of Colleague Relations for New York City at Hyatt Hotels.

Kevin joined Hyatt 16 years ago and started in an operations role supporting Hyatt Hotels in Rhode Island supporting housekeeping operations. He eventually made his way to New York and calls the Grand Hyatt NYC his home base. Kevin needs to stay in contact with his distributed staff across the five hotels: Andaz 5th Avenue, Andaz Wall Street, Grant Hyatt New York, Hyatt Centric Times Square, and Park Hyatt New York.

Kevin discussed…

This tutorial walks you through how you can extract the data from tables in multiple Google Docs and combine into one structured table in Coda to sort, filter, and organize

If your organization creates multiple Google Docs every day and you want a better way to sort, filter, and organize all these Google Docs, this solution may be useful for you. This tutorial walks you through how to extract the important metadata from a table in a Google Doc and sync that data into a table in Coda.

I often see templates for project briefs, meeting notes, or candidate interview as Google Docs at other organizations which are duplicated over and over again. These Google Docs are then stored in Google Drive which can get very unwieldy to manage unless…

Recap of the Coda July 2020 meetup with Ariana Cofone, VP of Operations at Decoded

This post is also a published doc, which you can explore here.

For July 2020’s virtual NYC meetup, I had a chance to speak with Ariana Cofone, VP of Operations at Decoded. Ariana found her way into technology (full-stack web development) after careers in the arts and operations. She dubs herself as a “creative technologist” and enjoys building tools that solve real problems.

As the VP of Operations at Decoded, a technology education company, she oversees many processes from coordinating technologists to facilitate workshops to helping the client team improve their processes. …

A project management template based on MasterClass’ process for launching classes with task dependencies.

See the original post and template here. This post was originally written by Rachel Williams at MasterClass.

MasterClass allows anyone to learn from the best in the world. Step into Anna Wintour’s office, Timbaland’s recording studio, and Neil Gaiman’s writing retreat. Improve your serve with Serena Williams, perfect your pitch with Shonda Rhimes, and leave the atmosphere with Chris Hadfield. Launching new classes impacts all aspects of the business and every team is involved in some shape or form.

In 2018, a small team was created to investigate the “state of class launch” with the aim of simplifying and centralizing…

Recap of the Coda May 2020 meetup with Matt Galligan, VP of Design at Earnest Research

This post is also a published doc, which you can see here.

For May 2020’s virtual NYC meetup, I had a chance to speak with Matt Galligan, VP of Design at Earnest Research about the various startups he’s co-founded, his passion for distributed teams, Coda docs he’s built for work and personal use, and his membership in the two-letter Twitter club. When I first learned about Matt’s personal use case, I was particularly excited to see what he had to show (spoiler: it involves Clubhouse and Naval Ravikant).

Watch the full replay of the meetup here (Crowdcast replay here):

Employee competency framework

Keep your data synced across your Coda docs and Google Sheets so you don’t have to copy and paste anymore.

Two new scripts

Last year I published a tutorial on how to sync data between two Coda docs and data between two Google Sheets. What was missing from the tutorial was how to sync data between a Coda doc and a Google Sheet. Writing these scripts was definitely more challenging than the original script I wrote for syncing two Coda docs since the data model for Coda is different from Google Sheets. Please read the caveats below about these scripts to learn about some of the roadblocks I encountered when writing these scripts.

If you are reading this, chances are you have a…

For some of us, work is moving bits and pixels from one side of your computer screen to another. Moving your mouse and plugging in your laptop might be the most physical task you do during the workday. No matter how you define work, you are participating in skilled labor — you have developed an asset that others find valuable.

When I think of traditional examples of skilled labor, the blacksmith comes to mind — a man heating iron in a forge, pounding on iron with a hammer, and toiling away in his shop. Something like this:

Al Chen

Coda evangelist (coda.io) | Excel user (thekeycuts.com)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store