Archive a blog or publication's articles.

Keep every post with its date, title, standfirst, author and text, from the newest back to the first.

Every post becomes a row.

Export every post in a publication with its title, date and text before moving it to a new platform.
Simplescraper
simplescraper.io/dashboard/recipes/newsletter-archive/results
SubstackNewsletter archive
DateTitleStandfirstAuthorWordsOpening lineLink
Nov 3Lenny’s Newsletter holiday gift guide 2026100+ gift ideas—all things I actually use, love, and recommendLenny Rachitsky and Michelle Rial2158The holidays are fast approaching, so I’m back with my sixth (!!) annual gift guide.https://www.lennysnewsletter.com/p/lennys-newsletter-holiday-gift-guide-057
Oct 13How to tell if a startup has a moatA framework for assessing whether the company you’re considering joining is built to lastDan Hockenmaier2191Moats!https://www.lennysnewsletter.com/p/how-to-tell-if-a-startup-has-a-moat
Sep 29All of the Lenny & Friends Summit talks are now online!Plus, some reflections and takeaways from the dayLenny Rachitsky1226I’m excited to share that every main-stage talk from the recent Lenny & Friends Summit is now online.https://www.lennysnewsletter.com/p/all-of-the-lenny-and-friends-summit
Sep 22Advanced evals: How to find (and fix) hidden AI failures in your productWhy you should never skip error discoveryHamel Husain and Shreya Shankar3088Evals have been coming up more and more in my conversations with podcast guests and PMs.https://www.lennysnewsletter.com/p/advanced-evals-how-to-find-and-fix
Sep 1560+ new creative growth ideasHow to stand out when everyone is running the same playbookTom Orbach3933Tom Orbach writes the most delightful and actionable newsletter for anyone looking to grow their product.https://www.lennysnewsletter.com/p/60-creative-growth-ideas
Sep 1How to turn your AI into a world-class designerAn end-to-end process for tapping into AI’s hidden creativityAnshu Chimala3853I’d always thought AI was bad at design.https://www.lennysnewsletter.com/p/how-to-turn-your-ai-into-a-world
Aug 25How to figure out your next career moveSix essential questions to help you navigate changeCliff Maxwell2862Building on last week’s very exciting launch of Lenny’s Jobs (that’s a lot of likes!), I’m thrilled to bring you a companion post that will help you clarify what job to look for in the first place.https://www.lennysnewsletter.com/p/how-to-figure-out-your-next-career
Aug 18Announcing Lenny’s Jobs: The best place in the world to find, vet, and land your dream jobWhere product managers, engineers, designers, and growth/marketing professionals discover high-quality open roles at tech companiesLenny Rachitsky886My goal is to help you succeed in your career.https://www.lennysnewsletter.com/p/announcing-lennys-jobs-the-best-place
Aug 11How to make people care about your startupThree founder archetypes—and how to turn your origin story into a communications strategyKristen Lowe4196Kristen does such an incredible job of introducing this piece that I’ll just skip my regular intro and jump right into it.https://www.lennysnewsletter.com/p/how-to-make-people-care-about-your
Aug 4What if you’re not supposed to have a long-term plan?The case for career emergenceMolly Graham3126Molly Graham’s first guest post, The Waterline Model, quickly rose to be my 7th most popular post of all time—extra impressive for not being about AI.https://www.lennysnewsletter.com/p/what-if-youre-not-supposed-to-have
Jul 2811 products I love, free for a year—the biggest Product Pass expansion in 2 yearsRunway, Higgsfield, Waking Up, Brain.fm, Customer.io, Resend, Pangram, Mercury Personal, Supercut, Readwise, and Jam are joining Product Pass today, all…Lenny Rachitsky2024If you thought this subscription couldn’t possibly get any better, you ain’t seen nothing yet.https://www.lennysnewsletter.com/p/productpass-summer2026launch
Jul 21Why a sabbatical can change everythingHow to take Big Time OffLenny Rachitsky3678This newsletter wouldn’t exist if I hadn’t taken a sabbatical.https://www.lennysnewsletter.com/p/how-to-take-a-sabbatical
Jul 7How tech workers are feeling in 2026: a workforce splitting in twoResults from our second annual tech worker sentiment surveyNoam Segal and Lenny Rachitsky4408A year ago, we ran our first large-scale survey of how tech workers feel about their jobs and careers.https://www.lennysnewsletter.com/p/how-tech-workers-are-feeling-in-2026
Jun 30How top PMs increase their leverage with AIA framework for getting the most out of AI in your day-to-day-workColin Matthews2382For years, the PM job drifted toward coordinating and aligning people.https://www.lennysnewsletter.com/p/how-top-pms-increase-their-leverage
Jun 23The new inner game: Your unfair advantage in the age of AIA playbook for the biggest upheaval of work we’ll see in our lifetimeJoe Hudson3363Joe Hudson is one of the most sought-after executive coaches in Silicon Valley, working with influential leaders like Sam Altman (OpenAI CEO) and founders and execs across Apple, Google, X, and more.https://www.lennysnewsletter.com/p/the-new-inner-game-your-unfair-advantage
Jun 9Essential books for product builders—part 224 more timeless books that’ll make you a better builder, leader, and personLenny Rachitsky1021On the heels of part 1 of my essential books for product builders series, I’m excited to share part 2.https://www.lennysnewsletter.com/p/essential-books-for-product-builderspart-611
May 26Essential books for product builders—part 136 timeless books that’ll make you a better builder, leader, and personLenny Rachitsky1064I was a shy kid growing up, so I spent a lot of time reading books.https://www.lennysnewsletter.com/p/essential-books-for-product-builderspart
May 19The Lenny and Friends Summit is back!September 10th in San Francisco. Applications are now open.Lenny Rachitsky517Two years ago, we held the first-ever Lenny and Friends Summit.https://www.lennysnewsletter.com/p/the-lenny-and-friends-summit-is-back
May 5Why SaaS freemium playbooks don’t work in AI, and what to do insteadHow to build an AI monetization strategy that actually worksVikas Kansal1663Today’s guest author, Vikas Kansal, leads product for Google AI, arguably the most successful consumer subscription bundle in history, with Gemini 3.1, Nano Banana, NotebookLM, Veo3, and terabytes (!) of cloud storage.https://www.lennysnewsletter.com/p/why-saas-freemium-playbooks-dont
Apr 28Your Couch-to-5K for AIA step-by-step guide to building an AI habit that sticksHilary Gridley937I’m teaming up with AI native and my many-time collaborator Hilary Gridley on a project that will accelerate your AI learning more than anything you’ve tried.https://www.lennysnewsletter.com/p/your-couch-to-5k-for-ai
Apr 21New: A free year of Cursor, Google AI Pro, Notion, Supabase, Gumloop, and Fin for subscribersNow 25 incredible products totaling over $30,000 in value—free with your Lenny’s Newsletter subscriptionLenny Rachitsky1542Update: The Product Pass has been updated since this post was published.https://www.lennysnewsletter.com/p/new-a-free-year-of-cursor-google
Apr 14Not all AI agents are created equalA framework for categorizing and prioritizing your agent initiativesHamza Farooq and Jaya Rajwani2901Agents are so hot right now.https://www.lennysnewsletter.com/p/not-all-ai-agents-are-created-equal
Apr 7A visual guide to getting out of a creative slumpOn creating work like a human (and all the feelings that come with it)Michelle Rial1329I’m so, so excited to share a guest post by Michelle Rial, my wife!https://www.lennysnewsletter.com/p/a-visual-guide-to-getting-out-of
Mar 31OpenClaw: The complete guide to building, training, and living with your personal AI agentI built a team of 9 AI agents that run my work and life. Here's how you can too.Claire Vo2271Claire Vo has put together the definitive step-by-step guide to getting started with and mastering OpenClaw.https://www.lennysnewsletter.com/p/openclaw-the-complete-guide-to-building

Download, pull via API, sync to Google Sheets, or send to any app, webhook and data store.

Why archive a publication.

Own your back catalogue

Keep every post you published in your own files, whatever the platform does next.

Move without losing a post

Carry each title, date, byline and text to the new platform in one pass.

Search everything at once

Find any piece by author, date or topic instead of scrolling an archive page.

Feed your research or AI

Give an analysis or an assistant every post in one clean table.

Keep the whole back catalogue.

Every page, not just the first.

Follow next-page links and infinite scroll to scrape every page of results.

Learn more

Scrape on a schedule.

Run every few minutes, daily or only on the days you choose.

Learn more

Skip duplicates automatically.

Run it again and only new listings are added, with nothing saved twice.

Learn more

Add a column with AI.

Ask a question about every listing and get the answer as a new column.

Learn more

Send it where you work.

Rows go straight to Google Sheets, Airtable, Zapier, a webhook or the API.

Archive a publication in five steps.

  1. Open the archive

    Find the publication's archive, blog index or author page that lists every post.

  2. Choose the fields you need

    In the Chrome extension or the dashboard, select one post and pick its title, standfirst, date, author and link.

  3. Reach the first post

    Turn on infinite scroll or pagination so the run loads the whole back catalogue.

  4. Read each post

    Open every post's link in the same run to add its text or Markdown to the row.

  5. Download your archive

    Get every post as a spreadsheet, JSON or Markdown, or send new posts to your own database.

Choose how you get your archive.

Archive the posts yourself with Simplescraper

Create a reusable scraper for any blog, newsletter or news site archive.

Build it yourself

Have us archive the posts

Send us the publication and we'll deliver every post as a spreadsheet or Markdown files.

Get in touch

FAQ

Which blogs and publications does this work on?

Public blogs, newsletters and news sites, whatever platform they run on, from an archive page, blog index or author page.

Can I get the full text of every post?

Yes, for posts on public pages. Simplescraper opens each link and reads the text or Markdown into the same row.

What about paid or members-only posts?

Only with your own subscription. A paid post shows its free preview to everyone else, so run the recipe in the Chrome extension while you are signed in.

Can I go all the way back to the first post?

Yes. Infinite scroll and pagination load the archive until it ends, so the first run reaches the oldest post.

Can I keep the archive up to date?

Yes. Schedule the recipe and each run adds only the posts published since the last one.

Start your publication archive today.

Start scraping free