Substack Newsletter Scraper & Author Extractor

Turn 3 hours of manual newsletter monitoring into 60 seconds. 1,000 posts for $0.50.

---

---

Why You Need This

A PR agency monitoring 50 newsletters manually spends 3 hours a week reading, copying, and pasting. At a $50/hr billing rate, that's $125/week in lost billable time.

This tool does the same job in 60 seconds for $0.50.

No browser. No manual reading. No coding. Paste your Substack URLs, click Start, and download a structured dataset ready for your CRM, newsletter research, or competitive analysis.

Public content only. No login required. No paywall bypass. Robots.txt respected.

---

What You Get

Export Formats	Output Fields
JSON, CSV, Excel (XLSX), XML	21 fields per post: newsletter metadata, post details, engagement stats, full content, author profile, media links

Sample output (CSV):

newsletterName,newsletterUrl,title,publishedAt,authorName,wordCount,likeCount
Lenny's Newsletter,https://lenny.substack.com,"How to run effective brainstorming sessions",2026-07-10,Lenny Rachitsky,2400,847

---

How to Run It

1. Click Start — Lenny's Newsletter is pre-filled. First 10 posts are free. No typing required.
2. Configure filters — date range, keyword match, post limit (optional).
3. Results appear — in under 60 seconds.
4. Download your dataset — CSV, Excel, JSON, or XML. Ready for your CRM.

The tool checks robots.txt before every crawl, respects rate limits, and never accesses subscriber-only content.

---

Pricing

What You Pay	Price	Example Run
Per post exported	$0.00050	1,000 posts = $0.50
Full content fetch	+$0.00030/post	1,000 posts with article text = $0.80
Free preview	First 10 posts	$0.00

---

For Everyone Else

You're a...	Here's what this tool does for you
Newsletter Sponsor	Export engagement stats (likes, comments, restacks) across 20 candidates. Sort by audience activity. Know exactly which newsletter to sponsor.
VC or Investor	Feed 30 thought-leader newsletters through keyword filters. Get a structured deal-flow intelligence feed — not a flooded inbox.
Recruiter	Identify domain experts by newsletter. Export author bios and public profiles for direct outreach.
Audience Research Team	Enrich B2B contact databases with newsletter authorship signals. Every writer is a potential buyer, partner, or influencer.

---

Example Use Cases

Weekly PR Coverage Report

newsletterUrls: ["client1.substack.com", "client2.substack.com"]
keywordFilter: "ClientBrandName"
includeContent: false
maxPosts: 0

Exports every mention of your client. Run weekly. ~$0.30/run.

Newsletter Sponsorship Audit

newsletterUrls: ["candidate1.substack.com", "candidate2.substack.com"]
includeContent: false
maxPosts: 100

Compare engagement across candidates. ~$0.10 per newsletter.

VC Deal Flow Monitor

newsletterUrls: ["analyst1.substack.com", "analyst2.substack.com"]
keywordFilter: "fundraising|funding|series A"
dateFrom: "2026-01-01"

Track funding announcements. ~$0.50/run.

---

Screenshots

---

Technical Details

The tool uses Substack's public RSS feeds and JSON API — no browser automation, no login, no reverse engineering.

Component	Responsibility
src/fetcher.py	RSS parsing, JSON API, robots.txt enforcement, rate-limit handling
src/parser.py	Extracts 21 fields from raw data
src/exporter.py	Outputs JSON, CSV, XLSX, XML
src/utils.py	URL validation, domain extraction

Depends on: Python 3.11+, apify, httpx, beautifulsoup4, lxml, openpyxl