Fortunately, Substack still offers RSS (<substack_url>/feed).

For other newsletters, I've been a long time user of "Kill the Newsletter!" [0], which "converts" a newsletter email address to an RSS feed in a single click.

[0]https://kill-the-newsletter.com/