Primary publication
primaryPublicationName
Optional
Name of the author's primary publication
Substack Scraper – Posts, Comments, Publications & Authors
Pricing
from $3.50 / 1,000 results
Scrape Substack newsletters without logging in: posts with full HTML and plain text, likes and restacks, flattened comment threads, paywall flags, category leaderboards and author profiles as clean typed rows.
Record type
recordType
Required
post, comment, publication or author — filter on it when mixing posts and comments
Scraped at
scrapedAt
Required
ISO 8601 timestamp of extraction
Post ID
postId
Optional
Substack post id
URL
url
Optional
Canonical post URL, publication URL or author profile URL
Slug
slug
Optional
Post slug
Publication
publicationName
Optional
Publication name (best effort, from the homepage metadata)
Publication host
publicationHost
Optional
Final host of the publication after redirects
Publication subdomain
publicationSubdomain
Optional
Substack subdomain
Publication URL
publicationUrl
Optional
https://{host}
Publication tagline
publicationTagline
Optional
Publication hero text
Publication subscribers
publicationFreeSubscriberCount
Optional
Free subscriber count when Substack exposes it
Title
title
Optional
Post title
Subtitle
subtitle
Optional
Post subtitle
Description
description
Optional
Short description / social preview text
Posted at
postDate
Optional
ISO 8601 publication date
Type
type
Optional
newsletter, podcast, thread or video
Audience
audience
Optional
everyone, only_paid or founding
Paywalled
isPaywalled
Optional
True for subscriber-only posts (content is a preview)
Word count
wordCount
Optional
Substack's word count
Likes
likes
Optional
Heart reactions
Comments
commentCount
Optional
Number of comments
Restacks
restacks
Optional
Number of restacks
Cover image
coverImageUrl
Optional
Cover image URL
Section
sectionName
Optional
Publication section the post belongs to
Podcast URL
podcastUrl
Optional
Audio file for podcast posts
Podcast duration (s)
podcastDurationSeconds
Optional
Episode length in seconds
Body (HTML)
bodyHtml
Optional
Full post HTML (preview for paid posts); null when includeContent is off
Body (text)
bodyText
Optional
Readable plain text of the post with subscribe widgets removed
Content status
contentStatus
Optional
full, preview (paid post), not_fetched (includeContent off) or failed
Source
source
Optional
The publication or post URL from your input that produced this row
Comment ID
commentId
Optional
Substack comment id
Post URL
postUrl
Optional
URL of the commented post
Parent comment ID
parentCommentId
Optional
Id of the comment this one replies to; null for top-level comments
Depth
depth
Optional
0 for top-level comments, 1 for replies, …
Comment body
body
Optional
Comment text
Comment date
date
Optional
ISO 8601 timestamp
Edited at
editedAt
Optional
ISO 8601 timestamp of the last edit
Replies
childrenCount
Optional
Number of direct replies
Publication ID
publicationId
Optional
Substack publication id
Name
name
Optional
Publication or author name
Subdomain
subdomain
Optional
Substack subdomain
Custom domain
customDomain
Optional
Custom domain when set
Host
host
Optional
Host the publication is served from
Tagline
tagline
Optional
Publication hero text
Logo
logoUrl
Optional
Publication logo URL
Free subscribers
freeSubscriberCount
Optional
Free subscriber count when exposed
Subscriber magnitude
freeSubscriberCountOrderOfMagnitude
Optional
Order of magnitude of the subscriber count when exposed
Ranking detail
rankingDetail
Optional
Substack's ranking label (e.g. "Thousands of paid subscribers")
Tier
tier
Optional
Publication tier
Category
categorySlug
Optional
Category leaderboard the row came from
Rank
categoryRank
Optional
1-based position in the category leaderboard
Language
language
Optional
Publication language code
Created at
createdAt
Optional
ISO 8601 creation date of the publication
User ID
userId
Optional
Substack user id of the author
Handle
handle
Optional
Author handle
Profile URL
profileUrl
Optional
Bio
bio
Optional
Author bio
Photo
photoUrl
Optional
Author avatar URL
Subscribers
subscriberCount
Optional
Author subscriber count
Subscribers (text)
subscriberCountString
Optional
Subscriber count as displayed
Followers
followerCount
Optional
Author follower count
Bestseller tier
bestsellerTier
Optional
Bestseller badge tier
Primary publication
primaryPublicationName
Optional
Name of the author's primary publication
Primary publication host
primaryPublicationHost
Optional
Host of the author's primary publication
Publications
publicationHosts
Optional
Hosts of every publication the author writes for
[ "lennysan.substack.com"]Links
links
Optional
Author's profile links
[]