Substack Scraper avatar
Substack Scraper

Pricing

from $0.35 / 1,000 posts

Go to Apify Store
Substack Scraper

Substack Scraper

Extract complete data from Substack newsletters including posts, authors, engagement metrics, and article text. 13 fields per post. Fast and reliable.

Pricing

from $0.35 / 1,000 posts

Rating

0.0

(0)

Developer

LIAICHI MUSTAPHA

LIAICHI MUSTAPHA

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

19 hours ago

Last modified

Share

Substack Newsletter Scraper 📰

Extract complete data from Substack newsletters including posts, authors, engagement metrics, and full article text.

What does this Actor do? 🎯

This actor scrapes Substack newsletters and extracts 13 data points per post:

Content Data

  • Post headline & subheading
  • Full article text (or preview for paid posts)
  • Post URL

Author Information

  • Author name
  • Author profile URL

Publishing Data

  • Publication date
  • Free vs Paid status

Engagement Metrics

  • Number of likes ❤️
  • Number of comments 💬
  • Number of restacks 🔄

Perfect for 💡

  • Content Researchers - Analyze trends across newsletters
  • Competitive Analysis - Track what competitors publish
  • Data Scientists - Build training datasets
  • Writers - Research popular topics
  • AI Developers - Collect training data

Input

{
"substackUrls": [
"https://tedhope.substack.com",
"https://theankler.com"
],
"scrapingMethod": "sitemap",
"maxPostsPerSubstack": 100,
"batchSize": 20
}
FieldTypeRequiredDescription
substackUrlsArrayYesList of Substack URLs
scrapingMethodStringNo"sitemap" or "archive"
maxPostsPerSubstackNumberNoLimit posts (0 = unlimited)
batchSizeNumberNoSubstacks per batch

Output

{
"substack_url": "https://example.substack.com",
"post_url": "https://example.substack.com/p/post-title",
"headline": "Amazing Post Title",
"subheading": "Subtitle here",
"author_name": "John Doe",
"author_url": "https://substack.com/@johndoe",
"date": "December 10, 2024",
"free_or_paid": "Free",
"likes": 156,
"comments": 23,
"restacks": 12,
"article_text": "Full article content...",
"content_type": "full"
}

Features ✨

  • Two scraping methods - Sitemap (fast) or Archive (fallback)
  • Complete metadata - 13 fields per post
  • Engagement metrics - Likes, comments, restacks
  • Smart extraction - Handles paywalled content
  • Structured output - Clean JSON/CSV format

Pricing 💰

Based on Compute Units (CUs):

ScaleApproximate CostTime
10 Substacks$0.01-0.052-5 min
100 Substacks$0.50-1.0030-60 min
1,000 Substacks$5-105-10 hours

Start with Apify's free tier - includes $5 monthly credit!

Tips 💪

  1. Test first - Try 2-3 Substacks initially
  2. Use sitemap - Faster and more reliable
  3. Set limits - Use maxPostsPerSubstack for large newsletters
  4. Schedule runs - Set up weekly/monthly automation

FAQ ❓

Q: Can I scrape paywalled content? A: You'll get previews for paid posts, not full content.

Q: How long does it take? A: ~10-30 seconds per Substack with 100 posts.

Q: What if sitemap doesn't work? A: Use "archive" method as fallback.

Support 📧

About 👨‍💻

Built by MUSTAPHA LIAICHI - Automation & Web Scraping Specialist


Happy Scraping! 🚀