Before we get started with today’s episode, I wanted to mention that the second annual Profitable Podcast Summit is happening soon and I’d love it if you snagged your free ticket now.
You can grab your free ticket to the event by going here.
In today’s episode, we’re going to be diving into how to use Airtable to manage your podcast process.
Airtable is one of my all-time favorite tools so while you definitely can use something like Google Sheets, Excel, or another tool, I figured I would share my process with Airtable today.
For the full experience, I recommend you download my free Airtable podcast content calendar template by going here.
Whenever you get the template in your inbox and open it, make sure to hit the “copy base” button in the top right corner so that you can have your own copy of it instead of writing on the template itself.
So pause this episode and go grab the template, and then come back when you have it open because we’re going to talk through each tab.
If you’re driving or running errands or doing housework, definitely come back to this episode and listen when you have time to sit down and walk through the content calendar with me because that will be the most beneficial.
Okay, now that you’ve got the template in front of you, let’s dig in.
The first tab on the spreadsheet is the content calendar tab. This is where you’ll put all of your episode titles, episode type, their launch dates, the status of the episode (ie. planned, recorded, scheduled, published), the CTA(s) you’re going to mention, etc.
First, I want you to fill this out with all of your upcoming episodes for the season. You can certainly add in past episodes here if you have time but your upcoming episodes are more important.
If you haven’t planned out your episodes for the quarter or the full year yet, don’t fret. You’ll just plan out your episode content first and then come back to this step. So if that’s you, take 15-20 minutes and write out all of your episode ideas and add dates to them before filling out the other details like CTAs and the episode status fields.
Airtable is super versatile and you can create so many different views of the data like in a calendar form, a grid form (which is the default for this template), gallery view, and kanban view.
The next tab is the podcast outreach tab. This is where you can keep track of the potential guests you want to have on your show.
There’s a spot for their name, contact email, potential topics, outreach status, outreach date, check-in dates, and more so that anytime a new potential guest and topic idea comes to mind you can just write it down here so you don’t forget.
The third and final tab I’m going to discuss is the guest submission form. This is super handy if you have a show that has guests and want to give people a way to apply to be a guest on your show so that you can properly vet them.
Using Airtable for your guest submission form is a great way to eliminate having to use Google Forms for things like this. You can just have the link to the guest submission form on your website and check it once a month or so (or however often you’re recording new guest episodes) and then reach out to whoever you think is a good fit for your show.
Having it all within this one spreadsheet or as Airtable calls it a “base” makes it easier for you to keep track of everything for your podcast and access all the information in one place instead of having to use Google Sheets, Google Forms, and a bunch of other tools in tandem.
So I’d love to know your thoughts if you listened to this entire episode and set up your content calendar via Airtable using my template. Hit me up in my DMs at jenny.suneson. I’d love to hear from you.
Having this template for both of my podcasts and for my client’s podcasts has helped me save so much time and I hope it does for you too.