Spiral gives your agent every tool with one account. Browse the tools →

AlexandriaNews & MediaAvailable now

Substack · Archive

substack-com/newsletters/archive

Get news and media data with Substack · Archive from Alexandria through one Spiral API key. One page of a Substack publication's archive, newest or top first, or only its pinned posts. Each entry carries title, subtitle, URL, publish time, audience (free or paid), word count, engagement counts, section, tags and bylines. Page with cursor (or offset) and limit. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.00873 per call.

Limits

Runs
In the background
Returns
json
Longest queue wait
1 hour
Run deadline
5 minutes
Longest run, end to end
225 minutes
Largest inline input
1 MB
Largest input file
2 GB
Largest output
5 GB

Input

FieldKindDefaultDescription
publication requiredtext—

Substack slug or a declared custom publication host (www.astralcodexten.com, www.lennysnewsletter.com, www.noahpinion.blog). Other custom domains are not supported by this program.

sortone of
new, top, pinned
new

new = newest first, top = most popular, pinned = the publication's pinned posts only (usually one, a single page).

limitnumber
1 to 50
12

Posts to return. Substack serves 25 per request, so larger pages take two requests.

cursortext—

next_cursor from the previous page of the same publication, sort and query. Takes precedence over offset.

offsetnumber
0 to 10000
0

Posts to skip. new listings reach at most 250 by offset; follow next_cursor for deeper pages. Ignored when cursor is set.

Same request in code

curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "substack-com/newsletters/archive",
    "input": {
      "publication": "<publication>"
    }
  }'

Frequently asked questions

How much does Substack · Archive cost?

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

How do I use Substack · Archive through an API?

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "substack-com/newsletters/archive"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

Do I need an account with Alexandria to use Substack · Archive?

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

Can my AI agent use Substack · Archive?

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.