As you may know, I produce about a dozen different podcasts, most of them weekly, and keeping track of all the tasks of pre-production, recording, editing, distributing, and promoting them is challenging for a one-man operation like myself. Some shows I host, while others have their own hosts. Some shows I edit, while some have their own editors. It’s a lot of moving parts and if I don’t track every step, it could quickly fall apart.
I use Omnifocus, a Mac-based application, as my project management tool of choice and that’s where I keep all of the individual tasks that need to be checked off. Meanwhile, I use AirTable, a web-based database, to keep track of the shows, their episodes, who’s involved, and what stage of production they’re at, among other things. Since the steps to produce an episode of each podcast is pretty much the same every time, that means this process is ripe for automation. What was missing was a way to connect the AirTable and Omnifocus parts of the process because I was finding that I’d enter an upcoming episode of a show in AirTable and forget to setup the Omnifocus project. I needed some way to trigger the project creation from the first step of a new episode. Enter Zapier. Read More and Comment