Substack Newsletters, Sponsor Leads & Posts Scraper

Extract Substack newsletter profiles, author names, X/Twitter handles, paid tier indicators, average post engagement (avg_reactions, avg_comments), and full newsletter post archives directly from Substack JSON APIs.

---

Core Capabilities

1. Newsletter B2B Sponsor Lead Profiles (record_type: "substack_publication_lead")

Extracts publication_subdomain, publication_url, author_name, author_handle, author_bio, author_twitter, has_paid_subscriptions, avg_reactions, and avg_comments — ideal for newsletter sponsorship outreach and creator B2B lead generation.

2. Full Post & Podcast Episode Archives (record_type: "substack_post")

Extracts post_id, title, subtitle, description, published_at, audience (everyone vs only_paid), reaction_count, comment_count, restack_count, word_count, post_url, and podcast_url.

---

Pre-Configured Task Templates (1-Click Workflows)

Run specialized configurations of this Actor directly on Apify Store:

• Substack Newsletter B2B Sponsorship Leads Scraper
• Substack Posts, Reactions & Engagement Scraper
• Substack Paid Newsletter Authors & Socials Scraper

---

How to Automate in Clay.com, n8n & Make.com (1-Click Templates)

• Open 1-Click Shared Clay.com Workbook Template: https://app.clay.com/shared-workbook/share_0toe8fdqHgFAJtmU6wQ
• Download Ready-to-Import Make.com Scenario Blueprint: 08_substack-newsletter-leads-posts-scraper.blueprint.json
• Download Ready-to-Import n8n.io Workflow JSON: 08_substack-newsletter-leads-posts-scraper_n8n_workflow.json
• Full Automation Hub & Clay.com Recipes Repository: https://github.com/mikrozar-cell/b2b-ecommerce-saas-scrapers-n8n-clay

1. Clay.com (B2B Enrichment Column)

Use the Apify enrichment column or HTTP API column in Clay to enrich thousands of rows automatically:

• Method: POST
• Endpoint: https://api.apify.com/v2/acts/storeintel~substack-newsletter-leads-posts-scraper/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN
• JSON Body (with dynamic Clay column mapping):

{
  "publicationTargets": [
    "{{Substack Subdomain or Domain}}"
  ],
  "scrapePublicationProfiles": true,
  "scrapePosts": true,
  "maxPostsPerPublication": 10,
  "postSortBy": "top"
}

2. n8n.io & Make.com Integration

Import the ready-made Blueprint/Workflow JSON above (in Make.com: Create scenario → More ... → Import Blueprint; in n8n: Import from File/URL), or add an Apify — Run an Actor module pointing to storeintel/substack-newsletter-leads-posts-scraper (dSOldJQGTbikEda10). Because this Actor uses pure async HTTP/JSON with zero headless browser startup delay, synchronous calls (run-sync-get-dataset-items) return structured JSON records in 2–6 seconds.

---

Explore More StoreIntel Labs B2B Scrapers

Build complete B2B outbound & market intelligence pipelines by combining our 8 high-speed JSON/RPC Actors:

• Shopify & WooCommerce Scraper: Products, Stock & Store Leads — E-Commerce & D2C Lead Generation
• Shopify App Store Scraper: Apps, Pricing, Developer Leads & 1-Star Reviews — SaaS Churn & Competitor Intelligence
• Chrome Web Store Scraper: Extensions, Trader Emails, Manifest & Reviews — Browser Extension & Security Intelligence
• WordPress Plugin Directory Scraper: Active Installs, Support & Reviews — WordPress & WooCommerce Ecosystem Leads
• Greenhouse, Lever & Ashby ATS Jobs Scraper: Salaries & B2B Tech Stack Signals — B2B Hiring Intent & Tech Stack Intelligence
• Skool Community & Creator Leads Scraper: Estimated MRR, Pricing & Socials — Creator Economy & High-Ticket Agency Leads
• Y Combinator (YC) Startups & Founders Scraper: LinkedIn, X & Batch Data — Venture & Startup Founder Outbound