Substack Newsletter, Posts & Author Leads Scraper

Extract newsletter articles, engagement metrics (reactionCount, commentCount, restackCount, wordCount), verified publication subscriber counts, and author B2B social profiles (LinkedIn, X/Twitter, YouTube, Website) from any Substack publication or creator handle.

Built in Golang (128 MB RAM) for instant execution and full Model Context Protocol (MCP) compatibility with Clay, n8n, Make, Zapier, and AI research agents.

---

Key Capabilities

• Substack Post & Archive Extraction: Scrape latest (new) or top-performing (top) newsletter articles from any .substack.com subdomain, custom domain (e.g. www.lennysnewsletter.com, newsletter.pragmaticengineer.com), or @handle.
• Verified Author B2B Lead Enrichment: Automatically queries the author's Substack public profile to extract subscriber counts (e.g. 1,200,000 / 1.2M+ subscribers), bestseller tier, and clickable LinkedIn, X/Twitter, YouTube, and Website links.
• Engagement & Sponsorship Intelligence: Analyze reactionCount, commentCount, restackCount, wordCount, and audience (everyone vs only_paid) to qualify newsletters for B2B sponsorships, PR outreach, or content research.

---

Input Parameters

Field	Type	Default	Description
targets	array	["pragmaticengineer", "lenny", "bytebytego"]	Substack subdomains, custom domain URLs, or @handles.
sort	string	"new"	Sort posts by "new" (latest) or "top" (most popular).
keyword	string	""	Optional keyword filter applied to title, subtitle, tags, or author.
audienceFilter	string	"all"	Filter by "all", "everyone" (free posts), or "only_paid".
includeBodyText	boolean	false	Fetch full plain-text article body for each post.
maxItems	integer	30	Maximum number of posts to extract across all targets.

---

Sample Output JSON

{
  "postId": 222810010,
  "title": "The Pulse: Anthropic kills the coding interview",
  "subtitle": "AI is rendering the Leetcode-style interview pointless and now Anthropic has deleted it from its interview loop.",
  "slug": "the-pulse-anthropic-kills-the-coding",
  "postUrl": "https://newsletter.pragmaticengineer.com/p/the-pulse-anthropic-kills-the-coding",
  "publishedAt": "2026-10-30T16:37:51.401Z",
  "audience": "only_paid",
  "isFree": false,
  "wordCount": 4545,
  "reactionCount": 61,
  "commentCount": 4,
  "restackCount": 2,
  "tags": ["incident.io", "Microsoft", "Anthropic", "Industry trends"],
  "publicationId": 458709,
  "publicationName": "The Pragmatic Engineer",
  "publicationSubdomain": "pragmaticengineer",
  "publicationUrl": "https://newsletter.pragmaticengineer.com",
  "subscriberCount": 1100000,
  "subscriberCountText": "1.1M+ subscribers",
  "bestsellerTier": 10000,
  "authorName": "Gergely Orosz",
  "authorHandle": "pragmaticengineer",
  "authorLinkedIn": "https://www.linkedin.com/in/gergelyorosz/",
  "authorTwitter": "https://x.com/GergelyOrosz",
  "authorYouTube": "https://www.youtube.com/@pragmaticengineer",
  "authorWebsite": "https://www.pragmaticengineer.com/",
  "scrapedAt": "2026-11-03T06:58:00Z"
}