Substack Scraper: Posts, Full Text, Likes & Comments

Enter Substack newsletters and get their posts in one clean table: title, date, authors, the full text of free posts, and how many likes, comments and restacks each one got.

It reads the public feed every Substack newsletter publishes about itself, so it needs no login and no browser, and it works for newsletters on their own domain as well as on substack.com.

You pay only for posts returned, after your filters are applied. Newsletters that are not found cost nothing.

What you get for each post

Field	What it is
title, subtitle, description	The post's headline, subtitle and summary
url, newsletter	Link to the post, and the newsletter it belongs to
postedAt	Publication date in standard format
authors	Everyone credited on the post
text	The post as plain text, with headings and list items on their own lines
paywalled, textIsPreview	true when the post is for paying subscribers. For those, text holds only the public preview
likes, comments, restacks	Engagement counts
wordCount, tags, section, type	Length, the newsletter's own tags and section, and whether it is a newsletter post, podcast or thread
coverImage	Address of the cover image

Input

{
  "newsletters": ["astralcodexten", "https://www.noahpinion.blog"],
  "maxPostsPerNewsletter": 50,
  "postedWithinDays": 30,
  "keywords": ["ai", "economy"],
  "freeOnly": false,
  "includeContent": true
}

Paste a newsletter's address, the address of any of its posts, or just its Substack name. Newsletters that could not be found are listed in the run's NOT_FOUND record.

Typical uses

• Research and AI pipelines: collect a writer's whole free archive as clean text.
• Monitoring: run daily with postedWithinDays set to 1 to get only new posts from a list of newsletters.
• Content and competitor analysis: see which posts drew the most likes and comments, and how often a newsletter publishes.
• Curation: pull posts matching your keywords across many newsletters.

Pricing

$2.00 per 1,000 posts ($0.002 each). One charge per post returned, with or without its text.

The latest 50 posts of a newsletter cost $0.10. A 1,200-post archive costs $2.40.

Each run also has a start charge of $0.00005. There is no separate charge for computing time. Apify's paid plans get 10% to 30% off these prices; the Pricing tab shows yours. Apify's free plan includes $5 of credit a month, which covers 2,500 posts.

Limits

• Posts for paying subscribers are returned with their public preview only. This tool does not log in and cannot read paid content.
• Comment texts are not included, only the number of comments.
• Subscriber counts are not public and are not returned.

Questions

Can I run it on a schedule?

Yes. Save your input as a task and add an Apify schedule, for example every morning.

How do I get the results into Excel or Google Sheets?

Every run's results can be downloaded as Excel, CSV or JSON from the run's Output tab. Apify's integrations with Make, Zapier, n8n and Google Sheets can pass them on automatically.

Can I call it from my own code or from an AI agent?

Yes. The API tab has ready-made code for Python, JavaScript and cURL, and the tool can be connected to AI agents through Apify's MCP server.

Does it work for newsletters on a custom domain?

Yes. Paste the newsletter's own address, for example https://www.noahpinion.blog.

Something looks wrong or is missing

Open a report under the Issues tab and include the input you used.