Substack Newsletter, Author & Sponsorship Leads Scraper (B2B)

Search and enrich Substack publications by industry keyword or publication URL. Extract author names, verified sponsor & contact emails, subscriber counts, bestseller badges, custom domains, social links, and recent posts — zero proxies needed.

---

High-ROI B2B, Agency & AI Workflows

• B2B SaaS & DTC Newsletter Sponsorships: Find high-trust niche newsletters ("B2B SaaS", "AI engineering", "fintech") with direct author emails and sponsorship media-kit links before paying ad-network markups.
• PR, Product Launch & Media List Building: Build curated journalist and independent writer outreach lists with their latest article titles for hyper-personalized pitches.
• Creator & Ghostwriting Agency Prospecting: Filter by custom domain status, posting frequency, and subscriber scale to pitch growth, sponsorship management, or editing services.
• Competitive Content & Trend Intelligence: Pull recent issue headlines and URLs across dozens of industry Substacks into Slack, Notion, or RAG pipelines.

Architecture & Cost Advantage (256MB Zero-Proxy Engine)

• Zero Residential Proxy Markup: Engineered with lightweight TLS/session requests so you do not need expensive residential proxy add-ons just to test or scale runs.
• Ultra-Low 256MB Compute Footprint: Runs cleanly inside a 256MB container (16x less platform memory overhead than 4GB headless-browser scrapers) with incremental dataset streaming and graceful timeout protection.
• Pay-Per-Event Transparency: You only pay a tiny startup fee plus each structured dataset result delivered — with automatic volume discounts up to 60%–70% off on Bronze, Silver, Gold, Platinum, and Diamond Apify plans.

---

Input Parameters

Parameter	Type	Default	Description
searchQueries	array	["B2B SaaS"]	Search Substack publications by topic, industry, or audience (e.g. ['B2B SaaS', 'AI engineering', 'fintech']).
publications	array	[]	Optional list of Substack URLs, custom domains, or subdomains (e.g. ['demandloops', 'https://www.lennysnewsletter.com']).
maxNewslettersPerQuery	integer	15	Maximum number of Substack publications to extract per keyword search.
crawlAboutAndSocials	boolean	true	Fetches the publication /about page and linked author website to uncover sponsorship inquiries, media kits, LinkedIn/X profiles, and direct emails.
includeRecentPosts	boolean	true	Fetches the 3 most recent newsletter posts (titles, URLs, engagement reactions, and publish dates) for personalized sponsorship outreach hooks.
onlyWithEmail	boolean	false	Filter output to publications where at least one verified deliverable contact email was found.
proxyConfiguration	object	{"useApifyProxy": false}	Optional proxy settings. Works out-of-the-box with direct connections at 256MB.

---

Sample Output Dataset Item

{
  "publicationUrl": "https://examplegrowth.substack.com",
  "customDomain": "https://newsletter.examplegrowth.com",
  "subdomain": "examplegrowth",
  "name": "B2B Growth & AI Weekly",
  "description": "Tactical breakdowns on PLG, outbound, and AI agents for 18,000+ operators.",
  "authorName": "Alex Rivera",
  "authorHandle": "alexrivera",
  "subscriberCountText": "18,000+ subscribers",
  "bestsellerTier": 100,
  "emails": [
    "sponsors@examplegrowth.com"
  ],
  "sponsorshipLinks": [
    "https://passionfroot.me/examplegrowth"
  ],
  "socialLinks": {
    "twitter": "https://x.com/alexriverab2b",
    "linkedin": "https://www.linkedin.com/in/alexriverab2b"
  },
  "recentPosts": [
    {
      "title": "How AI SDR Workflows Changed in 2026",
      "url": "https://newsletter.examplegrowth.com/p/ai-sdr-2026"
    }
  ],
  "searchQuery": "B2B SaaS"
}

---

Use as an AI Agent Tool (Claude Desktop, Cursor, Windsurf & MCP)

Every Actor in our suite works out-of-the-box with the Apify Model Context Protocol (MCP) Server so Claude Desktop, Cursor, Windsurf, or custom OpenAI/LangGraph agents can invoke church_of_loujess/substack-newsletter-leads-scraper directly during a conversation:

{
  "mcpServers": {
    "apify-b2b-intelligence": {
      "url": "https://mcp.apify.com/?actors=church_of_loujess/substack-newsletter-leads-scraper",
      "headers": {
        "Authorization": "Bearer <YOUR_APIFY_API_TOKEN>"
      }
    }
  }
}

API Quickstart (Python, Node.js & cURL)

Python (apify-client)

from apify_client import ApifyClient

client = ApifyClient("<YOUR_APIFY_API_TOKEN>")
run = client.actor("church_of_loujess/substack-newsletter-leads-scraper").call(run_input={
  "searchQueries": [
    "B2B SaaS",
    "AI agents"
  ],
  "publications": [],
  "maxNewslettersPerQuery": 10,
  "crawlAboutAndSocials": true,
  "includeRecentPosts": true,
  "onlyWithEmail": false
})

for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

Node.js / TypeScript (apify-client)

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: '<YOUR_APIFY_API_TOKEN>' });
const run = await client.actor('church_of_loujess/substack-newsletter-leads-scraper').call({
  "searchQueries": [
    "B2B SaaS",
    "AI agents"
  ],
  "publications": [],
  "maxNewslettersPerQuery": 10,
  "crawlAboutAndSocials": true,
  "includeRecentPosts": true,
  "onlyWithEmail": false
});
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

n8n, Make.com & Clay Enrichment Setup

1. Clay: Add an Apify — Run Actor enrichment column -> select church_of_loujess/substack-newsletter-leads-scraper -> map your row's keyword, handle, or URL -> map returned emails/metrics into downstream cold-email columns (Instantly, Smartlead, Lemlist).
2. n8n / Make.com: Trigger on a schedule (daily/weekly) -> call https://api.apify.com/v2/acts/church_of_loujess~substack-newsletter-leads-scraper/run-sync-get-dataset-items?token=<TOKEN> -> route verified leads directly to HubSpot, Slack, Google Sheets, or Airtable.

Frequently Asked Questions (FAQ)

Do I need to configure proxies or cookies?

No. church_of_loujess/substack-newsletter-leads-scraper works out-of-the-box with zero cookies, zero login credentials, and zero residential proxies required.

Can I export results to CSV, Excel, JSON, or Parquet?

Yes. Every run writes clean, flattened fields plus rich nested metadata to your default Apify Dataset, supporting one-click export to CSV, XLSX, JSON, JSONL, XML, or RSS as well as direct webhook delivery.

What happens on large batch runs near the timeout limit?

All Actors in our portfolio stream results incrementally (pushData) and monitor APIFY_TIMEOUT_AT so completed leads are preserved cleanly without losing partial progress.

---

Explore Our B2B Lead Generation & Social Intelligence Suite

Chain this Actor with our other zero-proxy, 256MB-optimized Apify Actors inside n8n, Make.com, Clay, LangChain, or Claude/Cursor MCP:

Actor	Best For	Store Link
TikTok Search Scraper (Fast)	Keywords, hashtags, spoken transcripts & creator discovery	Open in Apify Store
TikTok Profile & Bio Email Scraper	Bulk @username stats, bio emails, posts & ASR subtitles	Open in Apify Store
TikTok Viral Hook & Outlier Cloner	Exact first-3s spoken hooks, WPM pace & outlier ratios	Open in Apify Store
Linktree & Bio-Link B2B Email Finder	Creator, coach & agency emails, Calendly links & storefronts	Open in Apify Store
Shopify App Reviews & Churn Leads	1-2 star competitor churn reviews -> resolved store emails	Open in Apify Store
Substack Newsletter & Sponsor Finder	Niche newsletter authors, subscriber scale & sponsor emails	Open in Apify Store
Show HN & Product Hunt Founder Leads	Newly launched tech startups, domains & founder emails	Open in Apify Store
GitHub Verified Developer & CTO Leads	Stargazers, contributors & commit-verified B2B emails	Open in Apify Store
Reddit Fast Buyer-Intent Scraper	Subreddits, buyer-intent search & nested comment trees	Open in Apify Store
YouTube Channel Sponsorship Leads	Creator business emails, social handles & external links	Open in Apify Store
Telegram Public Channel Scraper	Crypto, OSINT & community feeds + extracted links/emails	Open in Apify Store
Website Contact Email & Phone Crawler	Bulk domain contact page email, phone & social extraction	Open in Apify Store