Substack Scraper: Posts, Newsletters & Leaderboards
Pricing
from $2.00 / 1,000 results
Substack Scraper: Posts, Newsletters & Leaderboards
Scrape Substack posts with full text, likes, comments and dates. Find newsletters by keyword with subscriber counts, author and bio, or pull Top overall and Top paid category leaderboards. No login, no browser. $2 per 1,000 results.
Pricing
from $2.00 / 1,000 results
Rating
0.0
(0)
Developer
Data Forge
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
11 hours ago
Last modified
Categories
Share
Get Substack posts and newsletter data in one actor: post titles, full text of free posts, likes, comments, restacks, word count and publish date, plus newsletter details like subscriber counts, author, author bio, paid plan and category rank. $2 per 1,000 results. No login, no cookies, no browser.
Three ways to use it
- Posts from these newsletters. Paste newsletter addresses (
https://www.lennysnewsletter.com,astralcodexten.substack.com, or justastralcodexten) and get every post, newest first, with optional full text. - Find newsletters by keyword. Enter keywords like
recruiting,personal financeorartificial intelligenceand get every top newsletter whose name, description, author or author bio mentions them. Searches about 16,000 newsletters across Substack's category leaderboards, and tells you which keyword matched. - Top newsletters by category. Pull Substack's leaderboards for Technology, Business, Finance, Culture and 30 more, either Top overall or Top paid, with each newsletter's rank.
Search and category modes can also return the latest posts from each newsletter found, so one run gives you a list of newsletters and what they are publishing.
What you can use it for
- Sponsorships and partnerships: find newsletters in your niche, ranked, with subscriber counts and author details.
- PR and influencer outreach: build lists of writers who cover your topic, with their public bio and profile link.
- Content and market research: see what top writers publish, how often, and which posts get the most likes and comments.
- AI and data teams: clean, structured long-form text from free posts.
- Monitoring: schedule a daily run with Posts since to catch new posts from the newsletters you follow.
What you get
Posts
| Field | Example |
|---|---|
| title / subtitle | How to price your product |
| url | link to the post |
| publication / publicationUrl | Lenny's Newsletter |
| authors / authorHandles | Lenny Rachitsky |
| postDate | 2026-10-21T13:02:00.000Z |
| audience / isPaywalled | everyone / false |
| reactions / commentCount / restacks | 412 / 38 / 25 |
| wordcount | 3,240 |
| postType / section / tags | newsletter, podcast or thread |
| content / contentLength | full text of free posts (when Include post text is on) |
| coverImage, description, podcastDurationSec, postId |
Newsletters
| Field | Example |
|---|---|
| name / url / customDomain | Recruiting Brainfood |
| description | the newsletter's tagline |
| authorName / authorHandle / authorProfileUrl / authorBio | public author details |
| subscribersText / subscribersMin | Over 42,000 subscribers / 42000 |
| paidSubscriptionsEnabled / paidSubscribersText / bestsellerTier | |
| category / leaderboard / rank | Business / Top overall / 164 |
| matchedKeywords | recruiting |
| language, createdAt, logoUrl, freeBenefits, paidBenefits |
Every row has a type field, post or newsletter, so you can split them in your spreadsheet. The dataset has a Posts view and a Newsletters view.
How to use it
- Pick What to collect.
- For posts: add newsletters, set Max posts per newsletter, and optionally Posts since, Free posts only and Include post text.
- For keyword search: add keywords, and optionally limit to a few categories for a faster run.
- For categories: pick categories and Top overall or Top paid.
- Optional filters for search and category modes: Minimum subscribers and Language.
- Set Max results, run, and download as JSON, CSV or Excel, or use the API.
Paid posts
For paid posts you get everything public: title, subtitle, date, likes, comments and the free preview Substack shows before the paywall. The actor never logs in, so it does not return paid content.
Pricing
$2 per 1,000 results saved (posts and newsletters both count as one result), pay per result. You are never charged for rows removed by your filters or anything beyond your Max results.
Is it legal?
This actor reads only public Substack pages and feeds that anyone can open without an account. It does not log in, it checks robots.txt before reading each site, and it does not collect comments, subscriber lists or private data. Posts are written by their authors, so follow copyright law if you republish them. This actor is not affiliated with Substack.
Integrations and API
Run it from the Apify API, schedule it, or connect it to Make, Zapier, n8n, Google Sheets, Slack, Airtable and AI agents through the Apify MCP server.
More from Data Forge
- App Store Reviews Scraper: Apple App Store reviews from 100+ countries
- Luma Events Scraper: tech and startup events by city
- Douban Reviews Scraper: Chinese film, book and music reviews
