Substack Newsletter Scraper

How to use it: 3 steps

1. Make a free Apify accountApify is the cloud platform where our tools run. The free plan gives you $5 of usage every month, no credit card needed. You pay Apify, not us.
2. Paste your input and press StartNo code needed: you fill in a form (the input). It already has a working example. For example: https://on.substack.com/feed in Full public feed URLs. Each start is one run.
3. Download the resultsWhen the run ends, the results are in a table (the dataset). Open Output, press Export and pick Excel or CSV. JSON and the API are there too.

This tool is an Apify Actor: a small program that runs on Apify. You can also run it on a schedule, for example every Monday. New to it? Read how it works, step by step and the 8 words you need first.

What it does

Get structured post metadata from known public Substack RSS or Atom feeds. This Substack newsletter scraper saves one stable Dataset row per unique feed item and never opens article pages.

• monitoring recent posts from a known list of Substack publications;
• importing newsletter post metadata into a database or workflow;
• comparing publication cadence using public feed dates;
• building a lightweight feed index where stable item identity matters.

Who uses it

Price

Pay per event: you pay for each result the tool saves, plus a small start fee for each run. The price includes Apify platform costs. Apify bills you, not us. Prices below are for the Apify free plan.

Examples

• One post: about $0.0017.
• 1,000 posts: about $1.00.
• Every day 100 posts, for 30 days: about $3.02 a month.

Free to try: the Apify free plan gives you $5 of usage every month, no credit card needed. That is enough for about 4,900 posts.

Prices checked on 24 October 2026. See the current price on Apify.

Questions

Details

For developers

Sample result

One result from a real test run, in JSON. Real values change from run to run. Some values are changed for privacy. In Excel or CSV each field is a column.

{
  "schemaVersion": "v1",
  "recordType": "post",
  "postKey": "v1:sha256:54fa1135afab659a504413c570559306127df98abd78cbba50fbd817cb9b5c4f",
  "feedUrl": "https://on.substack.com/feed",
  "publicationKey": "on.substack.com/feed",
  "publicationName": "On Substack",
  "publicationUrl": "https://on.substack.com/",
  "sourceGuid": "https://on.substack.com/p/a-new-vision-for-sponsorships",
  "canonicalUrl": "https://on.substack.com/p/a-new-vision-for-sponsorships",
  "title": "A new vision for sponsorships",
  "subtitle": null,
  "publishedAt": "2026-10-08T13:14:23.000Z",
  "updatedAt": null,
  "author": "Substack team",
  "categories": [],
  "audience": "unknown",
  "contentMode": "metadata_only",
  "contentAvailability": "unknown",
  "retrievedAt": "2026-10-09T11:24:18.452Z",
  "sourceStatus": "POST_SAVED"
}

Use it from code

Actor ID: cliqtomedia/substack-newsletter-scraper. You need your Apify API token from Apify Console → Settings → API & Integrations.

from apify_client import ApifyClient

client = ApifyClient("YOUR_APIFY_TOKEN")
run = client.actor("cliqtomedia/substack-newsletter-scraper").call(run_input={
    "feedUrls": [
        "https://on.substack.com/feed"
    ],
    "maxPostsPerFeed": 5
})
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

curl -X POST "https://api.apify.com/v2/acts/cliqtomedia~substack-newsletter-scraper/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"feedUrls": ["https://on.substack.com/feed"], "maxPostsPerFeed": 5}'

# pip install langchain-apify
# set APIFY_TOKEN in your environment
from langchain_apify import ApifyActorsTool

tool = ApifyActorsTool("cliqtomedia/substack-newsletter-scraper")
result = tool.invoke({"run_input": {"feedUrls": ["https://on.substack.com/feed"], "maxPostsPerFeed": 5}})
print(result)

The cURL call waits for the results, up to 300 seconds. For longer runs, start a run (/runs) and get the results with a webhook or by checking the run. Apify API docs. LlamaIndex, MCP for AI agents and the JavaScript client: AI agents & MCP.

Use cases with this tool

Each guide shows all the steps and the other tools.

Similar tools

More in Social media & communities.