How I automate my Substack newsletter with content from my blog
Read OriginalThis article details a developer's automated system for generating his Substack newsletter from his blog. The process involves a complex SQL query in Datasette to format content, a JavaScript-powered Observable notebook to fetch and prepare the HTML, and manual tweaks in Substack before sending. It's a technical deep-dive into a custom content automation pipeline.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
1
Introducing GPT-5.1 for developers
Simon Willison
•
6 votes
2
🧠 Build an Agent Chat that Remembers — Persisting Conversations with Microsoft Agent Framework
Bruno Capuano
•
3 votes
3
Using A Hidden Submit Button To Ensure Unnamed Submissions
Ben Nadel
•
3 votes
4
ServiceNow and Microsoft Copilot
Marius Sandbu
•
2 votes
5
Cursor 2.0 and Composer Model
Codeaholicguy
•
2 votes
6
Agentic AI and Security
Martin Fowler
•
2 votes
7
Springs and Bounces in Native CSS
Josh Comeau
•
2 votes
8
9
Fix “This video format is not supported” on YouTube TV
David Walsh
•
1 votes
10
Tooltip Components Should Not Exist
TkDodo Dominik Dorfmeister
•
1 votes