Substack Newsletter & Author Directory Scraper avatar

Substack Newsletter & Author Directory Scraper

Pricing

Pay per usage

Go to Apify Store
Substack Newsletter & Author Directory Scraper

Substack Newsletter & Author Directory Scraper

Fast and lightweight scraper for Substack publications. Extracts newsletter names, author names, descriptions, reader estimates, and direct URLs for sponsorship outreach and lead generation.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Mustafa Deniz Karatoprak

Mustafa Deniz Karatoprak

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

6 days ago

Last modified

Share

📰 Substack Newsletter & Author Directory Scraper

Fast, reliable, and lightweight scraper to extract publication directories, newsletters, authors, estimated subscriber tiers, and descriptions from Substack.

Ideal for:

  • PR & Media Agencies: Find newsletters to pitch stories and secure press coverage.
  • Sponsorship & Ad Managers: Discover high-growth newsletters to sponsor.
  • Content Creators: Research competing publications in your niche.
  • Lead Generation: Build targeted outreach lists of verified creators and publication owners.

⚡ Features

  • Author & Publication Info: Scrapes publication title, author name, subdomain, and direct URLs.
  • Audience Estimates: Extracts subscriber count badges and member statistics (e.g., "Over 50,000 subscribers").
  • Keyword Filtering: Optionally filter publications by niche keywords (e.g. tech, crypto, finance, health).
  • Deep Sitemap Crawling: Crawls across 400+ Substack publication sitemaps covering hundreds of thousands of newsletters.
  • Zero Captchas / Zero Block: Optimized lightweight HTTP worker pool for maximum speed and stability.

📥 Input Parameters

ParameterTypeDefaultDescription
max_resultsinteger100Maximum number of newsletters to extract.
search_keywordstring""Optional keyword filter (matches name, description, author).
sitemap_pageinteger1Sitemap page index (1 to 446). Each page covers ~300 unique publications.

📤 Sample Output Data (JSON)

{
"name": "ByteByteGo Newsletter",
"subdomain": "bytebytego",
"url": "https://bytebytego.substack.com",
"about_url": "https://bytebytego.substack.com/about",
"author": "Alex Xu",
"reader_estimate": "Over 1,000,000 friendly readers",
"description": "Explain complex systems with simple terms, from the authors of the best-selling system design book series.",
"logo_url": "https://substackcdn.com/image/fetch/..."
}

🚀 How to Run

  1. Click Try for free on Apify Store.
  2. Enter your desired max_results and optional keyword filter.
  3. Click Start and export the clean data to Excel, CSV, or JSON.