Substack Scraper API - Newsletter Posts, Stats & Full Text avatar

Substack Scraper API - Newsletter Posts, Stats & Full Text

Pricing

from $1.50 / 1,000 posts

Go to Apify Store
Substack Scraper API - Newsletter Posts, Stats & Full Text

Substack Scraper API - Newsletter Posts, Stats & Full Text

Scrape any Substack newsletter: every post with title, date, author, likes, comments, restacks, word count, tags and the full text of free posts. Filter by date, keyword and free or paid. No login.

Pricing

from $1.50 / 1,000 posts

Rating

0.0

(0)

Developer

Sndz Data

Sndz Data

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

13 days ago

Last modified

Features

Limited permissions

Share

Substack Scraper API: Newsletter Posts, Stats & Full Text

Scrape any Substack newsletter: every post with title, subtitle, date, authors, likes, comments, restacks, word count, tags, cover image and link, plus the full text of free posts. Works with name.substack.com and custom domains. No login, no API key.

Why this one?

  • Engagement stats for every post: likes, comments and restacks, to see what really works.
  • Full text of free posts, ready for AI summaries, research or archives. Paid posts are respected: you only get their public preview.
  • Any number of newsletters in one run, newest posts first.
  • Filters by date, keyword and free or paid.

Use cases

  • Competitor and content research: which topics and formats get the most engagement in your niche.
  • Sponsorship and partnerships: find active newsletters and their best posts before you pitch.
  • AI and research: collect posts to summarize, classify or feed a RAG system.
  • Archiving and monitoring: keep a copy of the newsletters you follow and get new posts daily.

Input

FieldWhat it does
Substack newslettersLinks or names, one per line.
Max posts per newsletterNewest first.
Only posts published sinceOptional date.
KeywordsKeep posts about a topic.
Free or paid postsAll, only free or only paid.
Include full text of free postsAdds the complete text.
{
"publications": ["https://www.lennysnewsletter.com", "astralcodexten"],
"maxPostsPerPublication": 100,
"includeFullText": true
}

Output

{
"publication": "https://www.lennysnewsletter.com",
"title": "Lenny's Newsletter holiday gift guide 2026",
"subtitle": "100+ gift ideas, all things I actually use, love, and recommend",
"url": "https://www.lennysnewsletter.com/p/lennys-newsletter-holiday-gift-guide-057",
"postDate": "2026-11-03T14:45:33.089Z",
"audience": "paid",
"authors": ["Lenny Rachitsky"],
"wordCount": 2759,
"reactions": 360,
"comments": 13,
"restacks": 5,
"tags": ["Gift guide"],
"hasPodcast": false,
"preview": "Hey there, I'm Lenny..."
}

Good to know

  • Reads Substack's public API, the same the website uses, at a polite pace.
  • Paid posts only include the preview Substack shows to non-subscribers.

Integrations

Schedule it daily with "Only posts published since" and send new posts to Google Sheets, Notion, Slack, Make, Zapier or n8n.

How to use it

  1. Click Try for free (or Start) at the top of this page.
  2. Fill in the input, or keep the example to see it working in seconds.
  3. Click Start and wait for the run to finish.
  4. Download the results as Excel, CSV, JSON or HTML, or get them through the Apify API.

How much does it cost?

$0.0015 per post ($1.50 per 1,000). No start fee, no monthly fee, and you only pay for the results saved to your dataset.

ExampleCost
The last 100 posts of 10 newslettersabout $1.50
Every post of one big newsletter (500)about $0.75

Apify's free plan includes monthly credit, so you can try it for free.

FAQ

Do I need a Substack account?

No. It reads the public API that Substack's own website uses.

Does it get paid posts?

Only their public preview. The full text is included for free posts.

Does it work with custom domains?

Yes, for example lennysnewsletter.com as well as name.substack.com.

Which stats are included?

Likes, comments, restacks and word count for every post.

More tools from Sndz Data

Support

Need comments, subscriber counts or another field? Open an issue on the Issues tab.

If this Actor saves you time, a quick ⭐ review helps a lot and keeps it maintained. Thank you!