coopersimson96/ai-content-system/notion-setup

Notion Content Pipeline Setup

Creates the full content production infrastructure in Notion using the Notion MCP tools.

Pre-flight Check

Before anything, verify the Notion MCP is connected:

1. Use notion-get-teams to check which workspace is connected
2. If it returns a workspace → proceed
3. If it fails or returns an error → STOP and tell the user:

The Notion MCP isn't connected. To fix this:

1. Go to claude.ai/settings

2. Find Integrations > Notion

3. Click Connect and authorize with your Notion account

4. Then run /notion-setup again.

Step 1: Create Parent Page

Use notion-search to check if a "Content Production Hub" page already exists.

If not, use notion-create-pages to create a new page:

• Title: "Content Production Hub"
• Content: Brief description: "Central hub for all content production — scripts, pipeline, analytics."

Save the page ID — the database will be created inside this page.

Step 2: Create Script Library Database

Use notion-create-database to create a database inside the Content Production Hub page with these properties:

Database title: "Script Library"

Properties:

Step 3: Save Configuration

After creating the database, save the IDs for other skills to use:

mkdir -p ~/.config/notion-content

Write ~/.config/notion-content/config.json:

{
  "workspace": "YOUR_WORKSPACE_NAME",
  "hub_page_id": "{THE_HUB_PAGE_ID}",
  "script_library_db_id": "{THE_DATABASE_ID}"
}

Replace YOUR_WORKSPACE_NAME with the actual workspace name returned from the pre-flight check.

Also run notion-update-data-source with the database ID so the MCP can query it efficiently.

Step 4: Explain Manual View Setup

Tell the user:

The Script Library database is created! Now set up these views in Notion for the best experience:

### Board View (Production Pipeline)

1. Open the Script Library database in Notion

2. Click + Add a view → Board

3. Group by: Status

4. This gives you a kanban board: Ideas/Topics → Scripts → Filming → Filmed → Editing → Ready To Post → Posted

### Calendar View (Content Calendar)

1. Click + Add a view → Calendar

2. Date property: Post Date

3. Now you can see your posting schedule visually

### Table View (Performance Dashboard)

1. Click + Add a view → Table

2. Filter: Status is Posted

3. Show columns: Script Title, Platform, Views, 3s Retention, Likes, Comments, Shares, Saves

4. Sort by: Views (descending)

These views are best set up manually in Notion since the API doesn't support creating views directly.

Step 5: Verify

Confirm everything worked:

1. Use notion-search to find the "Script Library" database
2. Verify the config file exists at ~/.config/notion-content/config.json
3. Tell the user:

Notion pipeline is ready! Your Script Library database is set up with all properties.

When you run /content-master, scripts will automatically flow into Notion as individual entries with status tracking.

Use /content-pipeline to manage your production pipeline — update statuses, log metrics, manage your posting calendar.