Organization is key when it comes to consistently producing podcast episodes. There are multiple moving parts, schedules to adhere to, and everything must be kept in sync. It’s crucial to have a central place for you and your team members to reference and collaborate on, so you can see at a glance the status of episodes in your pipeline.
This is most commonly done in a spreadsheet, such as Airtable or Google Sheets.
Common things to track within the sheet are:
- Episode Number
- Episode Title
- Guest Name, Bio, Photo, Contact Info (if applicable)
- Record Date
- Publish Date
- Notes
- Recording Link
- Edited Assets Link
- Topics Covered
- Status
- Pre-Production
- Recorded
- Sent for Editing
- Approved
- Scheduled/Published
Of course, the customization possibilities are endless here. Depending on your podcast you may wish to also include other fields such as sponsorship info, social media content, keywords for indexing, season, and more.
You can even build automations so that when guests schedule their interview and submit their info, it auto-populates in your sheet. What about creating a Google Doc from a template that you can then use to prepare your for the interview? Yep, that’s possible, too.
Our guide is just a starting point. If you’d like to discuss a custom solution, please get in touch. Or have a chat with my friend Joe at Podcast Workflows.
Google Sheets Template
We’ve created an episode organization template that you can copy to your own files and customize!
To access it, click here. Then click ‘File’ and ‘Make a copy’
