How To Connect To The Teachable API With Apps Script

This post explores how to connect to the Teachable API using Apps Script. You can use this setup to return data about your online courses and show it in Google Sheets.

For example, here’s a running 30-day window into the enrollment, engagement, and completion rates of my online courses:

Teachable Data In A Google Sheet

As a creator, it’s super useful to see these sorts of insights. They inform your future strategy and help identify areas of the business to improve. The standard Teachable dashboard is very limited and doesn’t show you this kind of information.

So let’s see how to connect to the Teachable API and create custom data reports.
Continue reading How To Connect To The Teachable API With Apps Script

A Behind The Scenes Look At How I Create A Technical Video Course

Last week I launched a new Google Sheets course — The QUERY Function In Google Sheets — so I thought it would be interesting and helpful to share how such a course comes about.

It’s my 14th online course and my 19th launch. Along the way, I’ve made just about every mistake in the book, but I’ve now settled on a reliable framework for online course creation, the outline of which I share below.

Online Course Screenshot

I think about technical video course creation in six distinct phases:

  1. Ideation
  2. Research
  3. Planning
  4. Course Creation
  5. Launch
  6. Post-launch

Continue reading A Behind The Scenes Look At How I Create A Technical Video Course