Content Calendar Planner

Overview

Creates practical, executable content calendars that drive traffic, build authority, and generate leads, calibrated to the business owner's actual available time. Balances SEO-driven evergreen content with timely trend-responsive posts across all relevant channels. Delivers to Google Sheets (if connected) or as an Excel spreadsheet.

Workflow

<Definition - Capacity Guide>

<Definition - Content Pillar Matrix>

<Definition - Repurposing Waterfall>

1. Long-form blog post → Pillar piece
2. → Email newsletter teasing key takeaways
3. → LinkedIn post with key framework
4. → Twitter/X thread in bite-sized insights
5. → Instagram carousel visualizing the framework
6. → Short video (60s) covering #1 insight
7. → Quote graphics from best lines </Definition - Repurposing Waterfall>

<Definition - Delivery Cascade> Auto-select delivery format (do not ask):

1. Google Sheets connected (default) → Create a "Content Calendar for [Month/Quarter]" spreadsheet in the connected sheets tool with tabs: Monthly Calendar, Content Briefs, Ideas Backlog, Performance Tracker.
2. Google Sheets not connected → Generate Excel via run_python + open_in_session_tab.
3. Either way → Also display this week's priorities in chat. </Definition - Delivery Cascade>

<Definition - Content Brief Template>

## Content Brief: [Title]
- **Channel:** [Platform]
- **Format:** [Post type, word count, visual needs]
- **Target audience:** [Who specifically]
- **Key message:** [1 sentence]
- **Hook:** [Opening line/visual that stops the scroll]
- **CTA:** [Specific action]
- **SEO keywords:** [If blog/YouTube]
- **Assets needed:** [Images, graphics, video clips]
- **Success metric:** [Views, clicks, signups, comments]
- **Due date:** [Creation deadline]

</Definition - Content Brief Template>

<Definition - Time Period Defaults>

• Week plan = 5-7 posts
• Month plan = 20-30 posts (default if unspecified)
• Quarter plan = High-level themes with monthly breakdown </Definition - Time Period Defaults>

<Workflow - Content Calendar Planning description="Full content calendar planning workflow from audit to delivery." tools=[web_search, run_python, file_write, open_in_session_tab] triggers=["plan my content", "create a content calendar", "what should I post this month", "content strategy", "editorial calendar", "quarterly content plan", "social media schedule"]

1. [Decide] Is sufficient context available (business_type, active channels, hours_per_week)?

   • Yes: proceed to step 3.
   • No: proceed to step 2. Validate: At minimum, business type and channels are known. If fails: Proceed to step 2.

2. [Ask user] Gather missing context: What is your business and what do you sell? Which channels are you active on (Blog, LinkedIn, Instagram, TikTok, YouTube, Email, etc.)? How many hours per week do you have for content creation? What has worked well before? Any existing content that can be repurposed? Validate: User provides business type, active channels, and hours/week. If fails: Default to conservative plan (2-3 hours/week capacity) and note assumption.

3. [Agent] Audit current state. Map hours_per_week to <Definition - Capacity Guide> to determine realistic output volume. Determine time_period scope per <Definition - Time Period Defaults>. Assess what the user can realistically produce. Validate: Recommended output matches available hours. Volume matches time period. If fails: Default to conservative capacity tier (2-3 hours/week).

4. [Agent] Define 3-5 content pillars using <Definition - Content Pillar Matrix>. Use web_search to find topic ideas by searching "[target audience] questions about [topic]", customer FAQs, competitor content, and seasonal/industry events. Generate 10-20 topic ideas per pillar. Validate: Pillars cover full funnel (awareness + consideration + decision). At least 3 pillars defined. If fails: Use default pillar framework (Expertise, Stories, Proof, Culture, Trending).

5. [Agent] Build the calendar. Create complete schedule with columns: Week, Date, Channel, Content Type, Topic/Title, Pillar, CTA, Status. Apply planning rules: alternate between pillars, front-load evergreen content, include reactive slots, match content types to platform strengths. Validate: Calendar matches capacity. Pillars alternate. Reactive slots included. Entry count matches time period. If fails: Reduce volume to match capacity. Display as markdown table.

6. [Agent] Generate content briefs using <Definition - Content Brief Template> for each planned piece. Each brief must have enough detail to execute without additional research. Validate: Each brief has audience, key message, hook, CTA, and assets needed. If fails: Provide abbreviated briefs (title + key message + CTA only).

7. [Agent] Build repurposing plan using <Definition - Repurposing Waterfall>. For each long-form piece (blog/pillar content), map derivative content across platforms. Validate: Each long-form piece generates 5+ derivative pieces. Each derivative is adapted to its platform (not copy-pasted). If fails: Provide repurposing suggestions for top 3 pieces only.

8. [Agent] Deliver calendar per <Definition - Delivery Cascade>. If Google Sheets connected: create spreadsheet with tabs (Monthly Calendar, Content Briefs, Ideas Backlog, Performance Tracker). If not connected: generate Excel via run_python + open_in_session_tab. Display this week's priorities in chat regardless. Validate: All tabs/sections populated correctly. Delivery format auto-selected without asking. If fails: Deliver as markdown in chat.

</Workflow - Content Calendar Planning>

<Workflow - Content Repurposing description="Generate derivative content plan from an existing piece." tools=[web_search, run_python, file_write, open_in_session_tab] triggers=["repurpose this post", "derivative content from", "what else can I make from this"]

1. [Decide] Did the user provide a specific existing content piece to repurpose?

   • Yes: proceed to step 2.
   • No: ask user which piece they want to repurpose. Validate: A specific content piece is identified. If fails: Ask user to share the content or link.

2. [Agent] Apply <Definition - Repurposing Waterfall> to the provided content. Generate specific, platform-adapted derivative pieces with concrete suggestions (not generic "make a carousel"). Validate: At least 5 derivative pieces generated. Each adapted to its platform format. If fails: Generate at least 3 derivatives with specific content suggestions.

3. [Agent] Deliver repurposing plan with timeline and brief for each derivative piece. Validate: Each derivative has a brief with format, key message, and platform-specific hook. If fails: Deliver as bullet list with title + platform + key angle.

</Workflow - Content Repurposing>

Note: For individual post creation, use social-post-creator. For blog writing, use seo-content-writer. This skill handles STRATEGY; those handle EXECUTION.

<Template - Calendar Output>

Content Calendar: [Month/Quarter] for [Business Name]

Capacity: [X] hours/week → [output level from capacity guide] Channels: [list] Pillars: [list with emoji markers]

This Week's Priorities

1. [Most important piece to create first]
2. [Second priority]
3. [Third priority] </Template - Calendar Output>

<Template - Repurposing Plan>

Repurposing Waterfall: [Original Title]

Source: [Original piece type and platform]