Substack Publications & Newsletters Scraper
Scrape Substack category leaderboards for ranked publications and newsletters with author, category, leaderboard rank, bestseller tier, paid status, subscriber signal, subscription pricing, description, socials and links. Export to JSON, CSV or Excel.
{ "publicationName": "ByteByteGo Newsletter", "author": "Alex Xu", "authorHandle": "bytebytego", "authorBio": "Author of 3 Bestselling Books | Co-Founder of …", "category": "technology", "categoryName": "Technology", "subscriberRank": 1, "bestsellerTier": 0, "badgeType": "subscriber" }
Every run returns clean, typed records, ready for your CRM, spreadsheet or database.
- One clean record per result, deduped and normalized
- Stable schema in JSON, CSV or Excel, or read it via the Apify API
- Pay per use in the cloud, nothing to install or maintain
A real example record, exactly the shape you receive.
| Publication Name | Author | Author Handle | Author Bio |
|---|---|---|---|
| ByteByteGo Newsletter | Alex Xu | bytebytego | Author of 3 Bestselling Books | C… |
| The Pragmatic Engineer | Gergely Orosz | pragmaticengineer | Big Tech and startups from the in… |
| Pirate Wires | Pirate Wires | piratewires | technology, politics, culture |
| Career Brew | Career Brew | careerbrew | We help 550K+ people learn how to… |
| SemiAnalysis | Dylan Patel | semianalysis | Bridging the gap between business… |
{ "publicationName": "ByteByteGo Newsletter", "author": "Alex Xu", "authorHandle": "bytebytego", "authorBio": "Author of 3 Bestselling Books | Co-Founder of …", "category": "technology", "categoryName": "Technology", "subscriberRank": 1, "bestsellerTier": 0, "badgeType": "subscriber" }
Frequently asked questions
Which categories can I use?
Any Substack leaderboard category slug, such as `technology`, `business`, `finance`, `crypto`, `culture`, `news`, `health`, `sports`, `us-politics`, `music`, `science` and more. Add several in one run.
What is the bestseller tier?
It is Substack's badge that reflects how many paid subscribers a publication has crossed. A higher tier signals a larger paying audience.
Do I get subscriber counts?
You get the public subscriber signal Substack exposes (an order-of-magnitude estimate like `233K+`) plus the leaderboard rank, which together indicate reach and momentum.
Are empty runs charged?
No. You are only charged for real publication records. A run that returns nothing is not billed.
How fresh is the data?
Leaderboards are read live at run time, so each record reflects the ranking at the moment of the run (see observedAt).
Ready when you are.
Run the scraper live on Apify right now, or have us build one tailored to exactly what you need.