# PodFlow – Podcast Production Dashboard

## Overview
A single‑page hub that gives you instant visibility into every moving part of your podcast.  
- **Top‑level widgets** (to be added in Notion as linked views): Upcoming Episodes, Guest Outreach, Production Queue, Sponsor Pipeline, and a “Ready to Publish” board.  
- **Quick links** to each database and to the Show‑Notes Generator.

> 💡 Tip: Pin this page to your sidebar for one‑click access to the entire workflow.

---

## Episodes
Track each episode from concept to publication. Use the table below as a starter; convert it to a Notion database and add the indicated relations.

| Episode # | Title                              | Release Date | Status      | Guest(s) | Sponsor(s) | Notes                              |
|-----------|------------------------------------|--------------|-------------|----------|------------|------------------------------------|
| 001       | Launching the Podcast               | 2024‑09‑15   | Published   | Alice Lee| TechCo     | Intro episode, show‑notes auto‑gen |
| 002       | AI in Everyday Life                 | 2024‑09‑22   | In Editing  | Bob Kim  | DataBoost  | Interview scheduled 2024‑09‑10    |
| 003       | Monetising Your Hobby                | 2024‑09‑29   | Draft       | —        | —          | Outline ready, need guest outreach |

> 💡 Tip: Set the **Status** property to a Select with options — Draft, In Editing, Ready to Publish, Published — and filter a board view by “Ready to Publish”.

---

## Guests
Manage outreach, contracts, and episode assignments for every guest.

| Guest Name | Email                     | Role          | Episode(s) | Status      | Pitch Sent |
|------------|---------------------------|---------------|------------|-------------|------------|
| Alice Lee  | alice.lee@example.com     | Founder       | 001        | Confirmed   | 2024‑08‑01 |
| Bob Kim    | bob.kim@ai‑insights.com    | CTO           | 002        | Pending     | 2024‑08‑15 |
| Carla Ruiz | carla.ruiz@creativehub.org| Designer      | —          | Not Contacted| —          |

> 💡 Tip: Link the **Episode(s)** column to the Episodes database; this creates a two‑way relation so you can see all guests attached to an episode.

---

## Production Tasks
Break down each episode into actionable items and assign owners.

| Task                     | Episode # | Owner      | Due Date   | Status   | Type      |
|--------------------------|-----------|------------|------------|----------|-----------|
| Record interview         | 002       | Sam (Host) | 2024‑09‑10 | ✅ Done  | Recording |
| Edit audio               | 002       | Maya (Editor) | 2024‑09‑15 | ⏳ In Progress | Editing |
| Design cover art         | 003       | Leo (Designer) | 2024‑09‑20 | ❌ Not Started | Design |
| Draft show notes         | 003       | Sam (Host) | 2024‑09‑25 | ❌ Not Started | Writing |

> 💡 Tip: Create a Kanban board view grouped by **Status** to visualize the production pipeline at a glance.

---

## Sponsors
Keep track of sponsorship deals, contract dates, and episode placements.

| Sponsor Name | Contact               | Deal Value | Episode(s) | Status   | Contract Signed |
|--------------|-----------------------|------------|------------|----------|-----------------|
| TechCo       | jane@techco.com       | $2,000     | 001        | Active   | 2024‑07‑20      |
| DataBoost    | mark@databoost.io     | $1,500     | 002        | Negotiating | —               |
| CreativeHub  | nina@creativehub.org  | $1,000     | —          | Prospect | —               |

> 💡 Tip: Use a Formula property to calculate total sponsor revenue per month for quick financial reporting.

---

## Show Notes Automation
A step‑by‑step guide to generate polished show notes directly from your episode data.

1. **Create a template page** called “Show‑Notes Template” with placeholders: `{{Episode Title}}`, `{{Guest List}}`, `{{Key Topics}}`, `{{Sponsor Message}}`.
2. **Add a Formula** in the Episodes database:  
   ```markdown
   concat("## ", prop("Title"), "\n\n**Guests:** ", join(prop("Guest(s)").name, ", "), "\n\n**Key Topics:** ", prop("Notes"))
   ```
3. **Use Notion’s “Copy Link”** on an episode row, paste it into the template, and run the formula to populate the placeholders.
4. **Export to Markdown** (via the three‑dot menu) and paste into your publishing platform, or keep it in Notion for final edits.

> 💡 Tip: Duplicate the template for each episode and set the duplicate’s **Parent** to the corresponding episode page for automatic hierarchy.

---

## How to import into Notion
1. **Create a new page** in your Notion workspace where you want the dashboard.  
2. Click the **“Import”** button → choose **“Markdown & CSV”**.  
3. **Upload this .md file**. Notion will create a page with all headings and tables.  
4. For each table (Episodes, Guests, Production Tasks, Sponsors):  
   - Click the table → **“Turn into database”** → select **“Table – Full page”**.  
   - Rename the database as indicated by the heading.  
   - Adjust property types (Select, Multi‑select, Relation, Date, Formula) to match the column headers.  
5. **Create relations**:  
   - In Episodes, add a Relation to Guests and Sponsors.  
   - In Guests and Sponsors, add the reciprocal Relation back to Episodes.  
6. Build the **linked views** (Board, Calendar, Gallery) as described in the Overview section and embed them on the Overview page.  
7. Copy the **Show‑Notes Template** page into your workspace, set up the formula, and link it to the Episodes database.  

Your PodFlow dashboard is now live and ready to power every episode from idea to publication!