Substack Newsletter Finder & Scraper

Find Substack newsletters by keyword or category and get, for each one: subscriber count, the author's X/Twitter, LinkedIn, website, YouTube and Bluesky, language, whether it has a paid plan or podcast, and how active it is (last post date, posts in the last 30 days).

Second mode: export posts from any Substack newsletter, with full text of free posts.

Built for newsletter sponsorships, PR and outreach, influencer research, competitor monitoring and feeding AI / RAG pipelines with newsletter content.

What you can do with it

• 📣 Find newsletters to sponsor. Search "fintech" or browse the Finance category, keep only English newsletters with 10,000+ subscribers that posted in the last 30 days.
• 🤝 Build an outreach list. Author name, Substack profile, X/Twitter, LinkedIn and website in one table, ready for a CRM.
• 🔎 Map a niche. Who writes about "product management" or "crypto", how big they are, who has a paid plan.
• 🧠 Collect content. Export posts with text, likes and comments for analysis, summaries or a RAG knowledge base.

Input

Field	What it does
What to collect	Find newsletters or Export posts from newsletters
Search keywords	Topics to search, each one separately: saas, ai agents, real estate investing
Categories	Whole Substack categories: Technology, Business, Finance, Culture, Science, Health & Wellness…
Minimum subscribers	Keep only newsletters with at least this public audience
Language	en, es, de… empty = any
Add author social links	X/Twitter, LinkedIn, website, YouTube, Bluesky, plus exact subscriber and follower counts
Check posting activity	Adds last post date and posts in the last 30 days
Only active within (days)	Skip newsletters that have gone quiet
Max newsletters	Stop after this many
Newsletter URLs	For post export: name.substack.com, a custom domain or any post link
Include post text	Adds full text of free posts and the public preview of paid ones

Example: find English tech and business newsletters with 5,000+ subscribers that posted this month.

{
  "mode": "newsletters",
  "searchQueries": ["saas", "startup marketing"],
  "categories": ["Technology", "Business"],
  "minSubscribers": 5000,
  "language": "en",
  "checkActivity": true,
  "activeWithinDays": 30,
  "maxResults": 200
}

Output

One row per newsletter:

{
  "name": "The Pragmatic Engineer",
  "url": "https://newsletter.pragmaticengineer.com",
  "description": "Big Tech and startups, from the inside. Highly relevant for software engineers, AI engineers and engineering leaders, useful for those working in tech.",
  "language": "en",
  "subscribersLabel": "Over 1,100,000 subscribers",
  "subscribersMin": 1100000,
  "subscribers": 1100000,
  "authorFollowers": 1221564,
  "hasPaidPlan": true,
  "hasPodcast": true,
  "author": {
    "name": "Gergely Orosz",
    "handle": "pragmaticengineer",
    "bio": "Big Tech and startups from the inside. Especially relevant for software engineers / AI engineers, useful for anyone working in tech.",
    "twitter": "https://x.com/GergelyOrosz",
    "profileUrl": "https://substack.com/@pragmaticengineer"
  },
  "links": {
    "twitter": "https://x.com/GergelyOrosz",
    "linkedin": "https://www.linkedin.com/in/gergelyorosz/",
    "youtube": "https://www.youtube.com/@pragmaticengineer",
    "bluesky": "https://bsky.app/profile/gergely.pragmaticengineer.com",
    "website": "https://www.pragmaticengineer.com/",
    "other": [{ "label": "Books", "url": "https://thetechresume.com/" }]
  },
  "contactEmail": null,
  "lastPostAt": "2026-10-22T14:08:21.295Z",
  "postsLast30Days": 13,
  "source": "category",
  "foundBy": "Technology"
}

Post export rows contain title, subtitle, url, publishedAt, audience (everyone or only_paid), likes, comments, restacks, wordcount and text.

Download results as JSON, CSV, Excel or pull them through the Apify API, schedule runs, or connect to Make, Zapier, n8n and Google Sheets.

Pricing

Pay only for results, no start fee:

• $2.50 per 1,000 newsletters, including author social links and activity
• $0.90 per 1,000 posts without text
• $1.80 per 1,000 posts with full text

Set a maximum budget for a run and the scraper stops cleanly when it is reached.

Good to know

• Subscriber counts are the ranges Substack shows publicly ("Over 10,000 subscribers"). subscribersMin is the number from that label, so it is a lower bound. Newsletters that hide their audience have null.
• subscribers is the most exact public number: from the author's profile when available, otherwise the lower bound from the label. authorFollowers is the author's follower count on Substack.
• contactEmail is only filled in when a newsletter publishes a support email, which is rare. Most authors are easiest to reach through the links in links.
• Newsletters that moved off Substack keep their old Substack data but post export skips them and says so in the log.
• Paid posts are exported with their public preview only. The scraper never logs in and never bypasses a paywall.
• Only public data is collected. Use it in line with Substack's terms and the privacy laws that apply to you (for example GDPR when contacting people in the EU).

FAQ

How many newsletters can one keyword find? Usually 50 to 200. Categories go much deeper: thousands of newsletters per category.

Is it fast? About 20 to 60 newsletters per minute with author links and activity on. Turn both off for a quick list.

Something broke or you need a field? Open an issue on the Actor page and it will be fixed quickly.