Content Calendar Creator

Purpose

Build a strategic content calendar by researching trending topics in your industry, identifying content opportunities, and organizing everything into a spreadsheet with dates, formats, and distribution plans. Perfect for marketers, creators, and business owners planning their content strategy.

When to Use

Use this Skill when you need to:

• Plan content for the next month or quarter
• Research trending topics in your industry
• Create an organized content schedule
• Align content with business goals
• Coordinate multi-channel content distribution

Step-by-Step Process

Step 1: Define Content Strategy

Understand your content goals and audience.

Ask guiding questions:

• "What industry or niche are you creating content for?"
• "Who is your target audience?"
• "What are your main content goals? (brand awareness, leads, engagement)"
• "What content formats do you use? (blog, video, social, podcast)"
• "How frequently do you want to publish?"
• "What time period should the calendar cover?"

Context to gather:

• Industry/niche focus
• Target audience description
• Business objectives
• Preferred content formats
• Publishing frequency
• Calendar timeframe (1 month, quarter, etc.)

Output Variable: content_strategy

Step 2: Research Trending Topics

Find relevant topics and content opportunities.

Use exa_search and exa_search_news to discover:

• Trending topics in the industry
• Popular content from competitors
• Emerging trends and news
• Seasonal or timely opportunities
• Frequently asked questions

Use perplexity_research for:

• Industry analysis
• Audience interests
• Content gap analysis
• Keyword opportunities

Compile a list of 15-30 potential topics with:

• Topic title/idea
• Why it is relevant
• Content angle or hook
• Suggested format
• Timeliness (evergreen vs timely)

Output Variable: topic_research

Step 3: Plan Content Calendar

Organize topics into a strategic schedule.

Create calendar structure:

• Date: Publication date
• Topic: Content topic/title
• Format: Blog, video, social post, etc.
• Channel: Where it will be published
• Status: Planned, In Progress, Published
• Notes: Key points, hooks, CTAs

Consider:

• Content pillars (mix of topics)
• Format variety
• Platform-specific timing
• Holidays and events
• Content dependencies

Distribute topics across the timeframe logically.

Output Variable: calendar_plan

Step 4: Create Spreadsheet

Build the content calendar in Google Sheets.

Use GOOGLESUPER_CREATE_GOOGLE_SHEET1 to create the spreadsheet with:

• Header row with columns: Date, Topic, Format, Channel, Status, Owner, Notes
• Formatted cells with colors for status
• Data validation for dropdowns
• Conditional formatting for visual clarity

Use GOOGLESUPER_CREATE_SPREADSHEET_ROW or GOOGLESUPER_BATCH_UPDATE to populate:

• All planned content items
• Proper date formatting
• Default status values

Alternatively, use basile_create_sheet for a Basile workspace spreadsheet.

Output Variable: created_spreadsheet

Step 5: Finalize and Share

Complete the calendar and provide next steps.

Deliver:

• Link to the content calendar spreadsheet
• Summary of content themes and distribution
• Recommendations for content creation workflow
• Tips for maintaining the calendar

Create a companion document with:

• Content strategy summary
• Topic research findings
• Best practices for each format
• Suggested tools and resources

Output Variable: calendar_summary

Best Practices

• Balance evergreen and timely content
• Plan around industry events and holidays
• Batch similar content for efficiency
• Leave buffer time for breaking news
• Review and adjust monthly