Substack Scraper

Download every post from any Substack newsletter in a few clicks. Paste a newsletter's link, press Start, and get a spreadsheet of its posts: the full article, likes, comments, shares, the author, and how many subscribers the newsletter has.

No Substack account needed. No copying and pasting posts one by one.

Why people use Substack Scraper

📚 Every post, not just the latest ones. Many tools only grab the newest 12 or 20 posts. This one goes all the way back to the first post, whether a newsletter has 50 posts or 5,000.

✍️ The whole article, ready to use. You get each post's full text, cleaned up with buttons and clutter removed. Read it in a spreadsheet, or paste it straight into ChatGPT, Claude or Notion. It also comes in Markdown, a simple text format that AI tools read best.

🌐 Works with any Substack newsletter. Including the ones with their own web address, like lennysnewsletter.com. Paste the newsletter's link, a single post's link, or the writer's @name, whatever you have.

🔒 Honest about paid posts. For subscriber-only posts, you get the part anyone can read for free, and each one is clearly marked so you know when you don't have the whole article.

🎯 Only the posts you want. Choose a date range (like "the last 30 days"), free or paid posts only, written posts or podcasts, or posts mentioning a keyword. You only pay for the posts you get.

📈 See what's popular. Likes, comments and shares (Substack calls them "restacks") for every post, plus the newsletter's subscriber count and owner.

⚡ Quick and reliable. Most runs finish in seconds to a few minutes. If a link doesn't work, you're told why instead of getting an empty result.

What can you use Substack data for?

• See what works in your niche. Sort a newsletter's posts by likes and comments to find the topics its readers love most.
• Teach an AI a writer's work. Give ChatGPT or another AI tool a newsletter's entire archive, then ask it questions about everything they've written.
• Never miss a post. Run it every day on the newsletters you follow and get new posts sent to Google Sheets, Slack or your email.
• Find partners. Collect newsletter owners and subscriber counts for sponsorships, guest posts or outreach.
• Back up your own newsletter. Save a copy of everything you've published, with the stats.
• Research. Follow how writers have covered a topic over months or years.

How to scrape Substack in 3 steps

1. Paste the newsletters you want, e.g. https://www.lennysnewsletter.com or just astralcodexten.
2. Choose how many posts you want from each, and add a date range if you like.
3. Press Start. Your posts appear in the Output tab within seconds. Download them as an Excel or CSV file, or send them to Google Sheets.

That's it. No setup and no coding.

What you get

Every post is one row in your spreadsheet:

What	Example
Title and link	"Open Thread 453", astralcodexten.com/p/open-thread-453
Published	28 Sep 2026
Author	Scott Alexander
Likes / comments / shares	52 / 616 / 2
The full article	as plain text, plus Markdown and HTML versions for AI tools and websites
Length	299 words
Paid post? Only the free part?	No / No
Newsletter	Astral Codex Ten, offers paid subscriptions, plus the subscriber count when the newsletter shows it (e.g. Lenny's Newsletter: 1.2M+)

The Output tab shows your results three ways: a Posts table with likes and comments, a Full text view for reading the articles, and a Publications list of the newsletters.

How much does it cost to scrape Substack?

You pay only for the posts you receive. No subscription, no monthly fee.

What you get	Price per post	Per 1,000 posts
Post details: title, link, date, likes, comments, author and newsletter info	$0.0015	$1.50
Post details plus the full article	$0.004	$4.00

Examples

You want	Cost
The latest 20 posts of one newsletter, with the articles	$0.08
500 posts with the articles	$2.00
Details of 1,000 posts, without the articles	$1.50
A whole 5,000-post newsletter, with the articles	$20.00

You're never charged for links that don't work or for posts your filters leave out. You can also set a spending limit for each run, and the scraper stops when it reaches it.

Use it with AI assistants, apps and code

• AI assistants: Claude, ChatGPT, Cursor and other AI assistants can use Substack Scraper as a tool through the Apify MCP server. Just ask: "Get the last 20 posts from Lenny's Newsletter."
• Other apps: connect it to Google Sheets, Slack, Zapier, Make or n8n in a few clicks, no coding needed.
• Developers: call it from the Apify API or client libraries:

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: '<YOUR_APIFY_TOKEN>' });
const run = await client.actor('dacoder/substack-scraper').call({
    publications: ['https://www.lennysnewsletter.com'],
    maxPostsPerPublication: 20,
});
const { items } = await client.dataset(run.defaultDatasetId).listItems();

FAQ

Can it get the full text of paid posts? No. You get what anyone can read without paying: the free opening of a paid post, up to where the writer put the paywall. Every paid post is clearly marked, and you can see how many words you got compared with the full article.

Does it work with newsletters that have their own web address? Yes. Paste their address (like www.lennysnewsletter.com) or their .substack.com address; both work.

How many posts can I get? All of them. Set Max posts per publication as high as you like. Very big newsletters take a little longer, especially ones with lots of paid posts.

Can I get only new posts? Yes. Set Posts published after to "1 day" or "7 days" and schedule it to run daily or weekly. You'll get just the new posts each time.

Do I need a Substack account? No. Everything works without logging in.

Need help or a new feature?

Tell us on the Issues tab. Substack changes its website from time to time, and fixes come quickly. Ideas for new features are welcome too. To catch problems early, errors are automatically reported to our private error tracker (with the links you scraped, never your account details).

Also by this author: Threads Search Post Scraper, which finds posts on Threads by keyword.