vøiddo guidesAll Actors on Apify

Substack Scraper: how to get Newsletter Posts by Publication as JSON/CSV (API, Python, no code)

Substack scraper for newsletter posts. This guide shows the output fields, a working input, and Python, JavaScript and cURL code for the Actor v0iddo/substack-newsletter-posts on Apify.

Open Substack Scraper on Apify

What data you get

One row per result. Every row can be downloaded as JSON, CSV, Excel or HTML, or read through the API.

FieldLabelTypeExample
newsletterNewslettertexton.substack.com
newsletterTitleNewsletter TitletextOn Substack
titleTitletextModel Behavior: Rick Rubin
linkLinkURLhttps://on.substack.com/p/model-behavior-rick-rubin
authorAuthortext
pubDatePub DatetextThu, 22 Oct 2026 17:02:28 GMT
summarySummarytext
idtexthttps://on.substack.com/p/model-behavior-rick-rubin

Input example

This is the input that is pre-filled on the Actor page. Change the values for your own run.

{
  "newsletters": [
    "on.substack.com",
    "astralcodexten",
    "www.slowboring.com"
  ]
}
Input fieldTypeWhat it does
newslettersarrayEach newsletter as its Substack subdomain (slowboring for slowboring.substack.com), its own domain (www.slowboring.com) or any link on it.
maxPostsPerNewsletterintegerThe most posts to return for each newsletter.

Output sample

Real rows from a run of the Actor. Fields that name people are left out of the sample.

[
  {
    "newsletter": "on.substack.com",
    "newsletterTitle": "On Substack",
    "id": "https://on.substack.com/p/model-behavior-rick-rubin",
    "title": "Model Behavior: Rick Rubin",
    "link": "https://on.substack.com/p/model-behavior-rick-rubin",
    "pubDate": "Thu, 22 Oct 2026 17:02:28 GMT"
  },
  {
    "newsletter": "on.substack.com",
    "newsletterTitle": "On Substack",
    "id": "https://on.substack.com/p/introducing-podcast-sponsorships",
    "title": "Introducing podcast sponsorships on Substack",
    "link": "https://on.substack.com/p/introducing-podcast-sponsorships",
    "pubDate": "Wed, 21 Oct 2026 13:00:41 GMT",
    "summary": "Dynamic ad insertion, paid subscriptions, and community, all in one place"
  }
]

Code: Python, JavaScript and cURL

Get your API token in Apify Console under Settings, then Integrations. The Actor id is v0iddo/substack-newsletter-posts.

Python (apify-client)

from apify_client import ApifyClient

client = ApifyClient("YOUR_APIFY_TOKEN")

run_input = {'newsletters': ['on.substack.com', 'astralcodexten', 'www.slowboring.com']}

run = client.actor("v0iddo/substack-newsletter-posts").call(run_input=run_input)
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

JavaScript (apify-client)

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: 'YOUR_APIFY_TOKEN' });

const input = {
  "newsletters": [
    "on.substack.com",
    "astralcodexten",
    "www.slowboring.com"
  ]
};

const run = await client.actor('v0iddo/substack-newsletter-posts').call(input);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

cURL

curl -X POST "https://api.apify.com/v2/acts/v0iddo~substack-newsletter-posts/run-sync-get-dataset-items" \
  -H "Authorization: Bearer YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"newsletters": ["on.substack.com", "astralcodexten", "www.slowboring.com"]}'

Price

$1.06 per 1,000 results. You pay per result row. There is no separate charge per run. Higher Apify plans pay less per result, down to $0.74 per 1,000. See the pricing tab for your plan. A new Apify account gets $5 of platform credit every month.

FAQ

What data does the Substack Scraper return?

Each result is one row in an Apify dataset. Fields include newsletter, newsletterTitle, title, link, author, pubDate, summary, id. The table above shows every field with an example value.

How do I use the Substack Scraper from Python?

Install the apify-client package, create a client with your Apify API token, call the Actor v0iddo/substack-newsletter-posts with an input like the one above, and read the rows from the run's dataset. The Python snippet above does exactly that.

Can I use it without writing code?

Yes. Open the Actor page on Apify, fill in the input form (an example is already filled in), press Start, and download the results as JSON, CSV, Excel or HTML. You can also schedule runs there.

How much does it cost?

$1.06 per 1,000 results. You pay per result row. There is no separate charge per run. Higher Apify plans pay less per result, down to $0.74 per 1,000. A new Apify account gets $5 of platform credit every month.

How do I limit the number of results?

Set a maximum cost for a run in the run options on Apify, and the run stops when it is reached.

Can I send the results to Google Sheets, Make, Zapier or n8n?

Yes. Apify datasets connect to Google Sheets, Slack, Make, Zapier and n8n, and a webhook can call your own service when a run finishes. You can also export the dataset as JSON, CSV or Excel.

Open Substack Scraper on Apify

Related guides