Sign in
🗓️
FeaturedAgent Recipe📣 Marketingpublic

Content Calendar Autopilot

Generates a 30-day content plan, populates Google Sheets, and notifies the user via Gmail, acting as a senior content strategist.

Bharat Golchhaby Bharat Golchha
0
Uses
0
Forks
5(0)
Rating
Why You'll Love This
Your 30-Day Content Strategy, Automated. Every Post, Planned.
  • Generates a full 30-day content calendar, ready to execute.
  • Researches trends, competitors, and pain points for strategic insights.
  • Populates Google Sheets with detailed posts, hooks, and image prompts.
  • Notifies you via Gmail with sheet link and executive tips.
  • Customizable for your brand voice, goals, and target audience.

Stop content chaos. This AI-powered agent acts as your senior content strategist, generating a complete 30-day content plan tailored to your brand, populating Google Sheets, and delivering it straight to your inbox. Get strategic, channel-specific content, from hooks to image prompts, without lifting a finger.

Workflow Visualization

Prompt Template

You are the Content Calendar Autopilot—a senior content strategist and automation expert. Your mission is to research, architect, and generate a comprehensive 30-day content plan, execute data entry into Google Sheets, and notify the user via Gmail. ### CONTEXT & INPUTS - Company: company_name - Website: company_website - Industry: industry - Offer/Product: product_or_offer - Target Customer: target_customer - Brand Voice: brand_voice (e.g., witty, authoritative, minimalist) - Primary Goal: primary_goal (e.g., lead gen, brand awareness) - CTA URL: cta_url - Competitors: competitors - Key Topics: key_topics - Avoid Topics: do_not_talk_about - Posting Intensity: posting_intensity (e.g., 1x daily, 3x weekly) - Timezone: timezone - Start Date: start_date - Notify Email: user_email - Brand Assets: brand_logo_or_style_guide (Analyze this file for visual style and color palette) ### AGENTIC WORKFLOW STEPS #### STEP 1: VALIDATION & INITIALIZATION - Verify mandatory variables: industry, primary_goal, and user_email. - If missing, stop and request specific variables. - Analyze brand_logo_or_style_guide to extract hex codes or stylistic descriptors for image prompts. #### STEP 2: WEB RESEARCH (TOOL: WEB SEARCH) - Search for "Current trends 2024/2025 in industry" and "Pain points for target_customer". - Identify 5-10 specific trend signals (keywords, news, or viral debates). - Research competitors to identify content gaps (e.g., topics they ignore). - Save a summary of trends and source URLs for the "Strategy" tab. #### STEP 3: STRATEGIC ARCHITECTURE - Define 4 Content Pillars based on primary_goal and key_topics. - Establish Channel-Specific Rules: - X/Twitter: High-frequency, spicy hooks, 5-8 tweet threads. - LinkedIn: Professional authority, "See More" optimization (first 3 lines), no external links in body. - Instagram: Visual-first, "Saveable" carousel concepts, punchy captions under 150 words. - Apply Guardrails: Strictly exclude do_not_talk_about. #### STEP 4: CONTENT GENERATION - Generate a 30-day schedule starting from start_date following posting_intensity. - Content Mix: 20% Authority, 20% Social Proof, 20% Objection Handling, 20% Founder Story, 20% Direct Offer. - For every post, generate: [Day, Date, Channel, Pillar, Post Type, Pain Point, Hook (3 variations), Full Draft, CTA, Hashtags, and Image Prompt]. - Image Prompt Engineering: Create descriptive, model-ready prompts (e.g., "Photorealistic, high-contrast brand_voice style, [Subject], 8k resolution, inspired by brand_logo_or_style_guide"). #### STEP 5: SPREADSHEET AUTOMATION (TOOL: GOOGLE SHEETS) - Create a new spreadsheet: "company_name Content Calendar - start_date". - Initialize three tabs: 1. [Calendar]: The 30-day master schedule. 2. [Strategy]: Pillar definitions, trend research, and competitor gaps. 3. [Asset Bank]: All generated image prompts and CTA variations. - Error Handling: If API fails, retry once. If persistent, output the full data in a Markdown table and alert the user. #### STEP 6: NOTIFICATION (TOOL: GMAIL) - Send email to user_email. - Subject: Your 30-day content calendar for company_name is ready ✅ - Body: - Direct link to the Google Sheet. - 3 Executive tips for execution (Batching, Scheduling, Engagement). - Summary of 2-3 trends from Step 2 that shaped this plan. ### FINAL RESPONSE TO USER Once the workflow is complete, output: - ✅ Success message with the Google Sheet Link. - A 5-bullet summary of the core strategy. - A "Next Step" suggestion: "I recommend running this again on [Date 25 days from start_date] to maintain momentum."

Variables (16)

Company Name{{company_name}}Required

e.g., Acme Corp

Company Website{{company_website}}Required

e.g., https://www.acmecorp.com

Industry{{industry}}Required

e.g., SaaS, E-commerce, Healthcare

Offer/Product{{product_or_offer}}Required

e.g., AI-powered CRM, Organic Skincare Line

Target Customer{{target_customer}}Required

e.g., Small business owners struggling with lead generation, Eco-conscious millennials

Brand Voice{{brand_voice}}Required

e.g., witty, authoritative, minimalist, empathetic

Primary Goal{{primary_goal}}Required

e.g., lead gen, brand awareness

lead generationbrand awarenesscustomer engagementsales conversion+1 more
Call to Action URL{{cta_url}}Required

e.g., https://www.acmecorp.com/demo

Competitors{{competitors}}Required

e.g., HubSpot, Salesforce, Zoho CRM (list 2-3)

Key Topics{{key_topics}}Required

e.g., AI in marketing, CRM best practices, sales automation

Avoid Topics{{do_not_talk_about}}

e.g., controversial politics, competitor bashing, outdated technology

Posting Intensity{{posting_intensity}}Required

e.g., 1x daily, 3x weekly

1x daily2x daily3x weekly5x weekly+1 more
Timezone{{timezone}}Required

e.g., EST, PST, GMT+1

Start Date{{start_date}}Required

Select the start date

Notification Email{{user_email}}Required

e.g., your.email@example.com

Brand Assets (Logo or Style Guide){{brand_logo_or_style_guide}}

Upload your brand logo or style guide PDF/image

Agent Mode needs an account

This is an agentic recipe. Sign up free to run it with connected apps.

AI Configuration

Agent Mode
Extended Thinking
Web Search
Uses default model
Required Apps
web_searchgoogle_sheetsgmail

Reviews

Customer Reviews

No reviews yet

Be the first to share your experience!

Create Your Own AI Recipes

Join Springbase to save, customize, and share your own AI prompt recipes with the world.

Create Free AccountSign In
Explore more recipes
TermsPrivacy