Go to example tasks
Substack Newsletter Archive
Created by
SIÁN OÜ
Page through a Substack publication's full archive and export post titles, subtitles, authors, dates, engagement and cover images to CSV or JSON.
Substack API & Scraper — Posts, Authors & Newsletterssian.agency/substack-scraper
🖼️ Thumbnail
🆔 Post ID
📝 Title
🏷️ Subtitle
+26 fieldsTextNumberBooleanListObject
Input
🧭 Scrape Mode:overview
📚 Publications:bigtechnology
🗂️ Archive Endpoint:archive
↕️ Sort Order:new
🔢 Max Posts Per Run:25
Output fields
🖼️ Thumbnail
🆔 Post ID
📝 Title
🏷️ Subtitle
📄 Description
🔗 Post URL
🔡 Slug
🗂️ Post Type
🔓 Audience
🔒 Paywalled
📅 Post Date
🌐 Language
❤️ Reactions
😀 Reaction Breakdown
💬 Comments
🔁 Restacks
📊 Engagement Total
🔢 Word Count
✍️ Authors
🏠 Publication Host
🆔 Publication ID
🖼️ Cover Image
📸 Images
🔢 Image Count
🎙️ Podcast Duration
🎧 Podcast URL
📃 Preview Text
📰 Article HTML
🧭 Source Mode
🧾 Run Metadata
Sign up on Apify01
Create your Apify account to access the Substack API & Scraper — Posts, Authors & Newsletters.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
