This advanced content intelligence skill transforms raw podcast transcripts into strategic assets for thought leadership positioning. Whether you're a solopreneur, consultant, or agency, this skill automatically:
The skill integrates with Slack for notifications, Google Search for podcast discovery, WordPress for blog syndication of guest posts, and Zapier for workflow automation. It uses OpenAI's GPT-4 for semantic analysis and natural language extraction, ensuring intelligent identification of context-relevant content rather than simple keyword matching.
Why this matters: Manual transcript review takes 2-4 hours per episode. This skill processes an entire podcast season in minutes, surfacing your best moments and identifying 10-15 qualified podcast outreach targets automatically.
Upload my podcast transcript (PDF or text file) and extract the 5 most
quote-worthy moments about digital marketing strategy. Format them as
social media posts (280 characters) and LinkedIn posts (1,300 characters).
I've appeared on 8 podcasts in the last 6 months. Here are the transcript
links: [list]. Create a professional guest appearance portfolio page in
Markdown format that I can add to my website. Include episode titles,
hosts, key topics discussed, and a 2-sentence bio for each appearance.
Analyze these 3 competitor transcripts and identify 15 podcasts in the
"B2B SaaS" and "Startup Founder" categories that would be perfect for me
as a guest. For each podcast, generate a personalized 150-word pitch email
that references something the host said in a recent episode.
Search for podcasts in my niche (executive coaching, tech founders) that
have 50K-500K monthly listeners. Identify which ones have never had a guest
with my background (10+ years in tech, 5 exits). Create a prioritized list
with contact information and suggested episode angles.
Extract all key insights from this podcast transcript and generate:
- 10 LinkedIn carousel slide ideas
- 1 blog post outline (1,500 words)
- 5 Twitter threads (5 tweets each)
- 3 TikTok/Shorts scripts (60 seconds)
- 1 email newsletter edition
OPENAI_API_KEY=sk-... # GPT-4 access for semantic analysis
GOOGLE_SEARCH_API_KEY=AIza... # Podcast discovery and research
SLACK_WEBHOOK_URL=https://hooks.slack... # Notifications and team updates
WHISPER_API_KEY=sk-... # Audio transcription (optional, for MP3s)
WORDPRESS_API_KEY=... # WordPress integration (optional)
WORDPRESS_SITE_URL=https://yoursite.com # Your WordPress domain
# config.yml
extraction:
min_quote_length: 15 # Minimum words for soundbite
max_quote_length: 280 # Maximum words for social posts
sentiment_threshold: 0.7 # 0-1 scale for emotional moments
podcast_discovery:
listener_min: 10000 # Minimum monthly listeners
listener_max: 1000000 # Maximum monthly listeners
language: "en"
output_formats:
- linkedin_carousel
- twitter_thread
- blog_post
- email_newsletter
- slack_message
repurposing:
blog_word_count: 1500
email_subject_variants: 3
twitter_thread_length: 5
tiktok_duration: 60
Step 1: Connect Your Data Sources
# Link your podcast RSS feeds
openclaw podcast-mining add-feed https://feeds.example.com/podcast.xml
# Or upload transcripts directly
openclaw podcast-mining upload ./transcripts/
Step 2: Configure Slack Notifications
# Get your Slack webhook URL from Slack App settings
# Paste into SLACK_WEBHOOK_URL environment variable
# Test connection:
openclaw podcast-mining test-slack
Step 3: Set Up WordPress Integration (Optional)
# Generate WordPress API token in Settings > REST API
openclaw podcast-mining configure-wordpress \
--site-url https://yoursite.com \
--api-key YOUR_KEY
Step 4: Customize Extraction Preferences
# Edit extraction rules for your niche
openclaw podcast-mining configure \
--min-quote-length 20 \
--sentiment-threshold 0.8 \
--output-formats linkedin_carousel,blog_post
{
"episode": {
"title": "From Zero to $10M ARR: Scaling Your SaaS",
"host": "Sarah Chen",
"podcast": "The Founder's Journey",
"publish_date": "2024-01-15",
"listener_count": 125000,
"episode_url": "https://example.com/episode-42"
},
"soundbites": [
{
"quote": "The biggest mistake founders make is optimizing for growth before optimizing for retention. You can't scale a leaky bucket.",
"timestamp": "18:42",
"sentiment": 0.92,
"category": "business_strategy",
"social_post_280": "The biggest mistake founders make is optimizing for growth before optimizing for retention. You can't scale a leaky bucket. - [Your Name] on The Founder's Journey",
"linkedin_post": "\"The biggest mistake founders make is optimizing for growth before optimizing for retention. You can't scale a leaky bucket.\"\n\nThis insight from my recent appearance on The Founder's Journey resonates deeply with my experience scaling [Company]. Here's why retention should come first...",
"blog_pullquote": "The biggest mistake founders make is optimizing for growth before optimizing for retention. You can't scale a leaky bucket."
}
]
}
<div class="guest-appearances">
<h2>Featured Guest Appearances</h2>
<div class="appearance-card">
<h3>From Zero to $10M ARR: Scaling Your SaaS</h3>
<p class="podcast-info">
<strong>Podcast:</strong> The Founder's Journey<br>
<strong>Host:</strong> Sarah Chen<br>
<strong>Date:</strong> January 15, 2024<br>
<strong>Listeners:</strong> 125K/month
</p>
<p class="topics">
<strong>Topics:</strong> SaaS Scaling, Retention Strategy, Founder Mindset
</p>
<blockquote>
"The biggest mistake founders make is optimizing for growth before
optimizing for retention."
</blockquote>
<a href="[episode-url]" class="listen-btn">Listen Now</a>
</div>
</div>
Subject: Guest idea: [Your Name] on scaling SaaS retention (The Founder's Journey listener here!)
Hi Sarah,
I've been a long-time listener of The Founder's Journey—your recent episode
with [Previous Guest] on founder burnout really hit home. I've faced similar
challenges scaling [Your Company] from $0 to $5M ARR.
I'd love to be a guest and dive into a topic your audience clearly cares about:
**How to prioritize retention over growth when you're under pressure to scale.**
In my experience:
- Most founders optimize for growth metrics first (which is backwards)
- A 5% improvement in retention compounds to 50%+ revenue impact
- This shift in mindset saved us $2M in acquisition costs
I think your listeners would find this perspective valuable, especially founders
in the 6-12 month growth stage.
Would you be open to a 45-minute conversation? I'm flexible on timing.
Best,
[Your Name]
[Your Title]
[Your Website]
# LinkedIn Carousel: "5 Lessons from 8 Podcast Guest Appearances"
Slide 1: "I've appeared on 8 podcasts in 6 months. Here are the 5 biggest
lessons that surprised me about audience building, positioning, and growth."
Slide 2: "Lesson 1: Your best content isn't what you think it is. The moments
that got the most engagement were unscripted, vulnerable, and messy—not polished
talking points."
Slide 3: "Lesson 2: Podcast listeners are HUNGRY for specific, tactical advice.
Generic frameworks don't work. They want the exact playbook you used."
Slide 4: "Lesson 3: Host chemistry matters more than topic. The best episodes
were with hosts who challenged me, asked follow-ups, and weren't afraid to
disagree."
Slide 5: "Lesson 4: Repurposing is non-negotiable. One 45-min episode generated
12 pieces of content, 50K+ impressions, and 3 qualified leads."
Slide 6: "Lesson 5: Guest appearances compound. Each appearance makes the next
one easier. Hosts see your previous appearances and trust you more."
共 1 个版本